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:
List the steps in the database life cycle (DBLC)
Explain why an ER diagram is translated into relational notation
Describe the characteristics of tables and table types
List the rules for table columns and rows
Describe column domains and domains that support calculations
Describe and explain the purpose of null values
Differentiate key and descriptor columns
Define and identify single-field and composite primary keys
Describe all-key relations
Define and identify foreign keys
Define referential integrity
The next lesson reviews the steps in the database life cycle.
Many of today's businesses rely on their database systems for accurate,
Without those repositories of mission-critical data, most businesses are unable to perform their
normal daily transactions, much less create summary reports that help management make strategic corporate decisions.
To be useful, the data in a database must be accurate, complete, and organized in such a way that data can
be retrieved when needed and in the format desired.
Well-written database application programs, whether they
- execute locally,
- run over a local area network, or
- feed information to a website
are fundamental to timely and accurate data retrieval.
However, without a good underlying database design, even the best program
cannot avoid problems with inaccurate and inconsistent data.