This module reviews the basic concepts and terminology of database design.
Even if you are an experienced database designer, take a few moments to work through this module to reinforce your knowledge of the concepts and vocabulary we will use in the course.

After completing the lessons in this module, you should be able to:

1. List the steps in the database life cycle (DBLC)
2. Explain why an ER diagram is translated into relational notation
3. Describe the characteristics of tables and table types
4. List the rules for table columns and rows
5. Describe column domains and domains that support calculations
6. Describe and explain the purpose of null values
7. Differentiate key and descriptor columns
8. Define and identify single-field and composite primary keys
9. Describe all-key relations
10. Define and identify foreign keys
11. Define referential integrity

The next lesson reviews the steps in the database life cycle.