Relational Constructs in Database Design
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.
Relational Database Model
The relational database model improves on the restriction of a hierarchical structure, not completely abandoning the hierarchy of data. Any table can be accessed directly without having to access all parent objects. The key is to know what to look for.
If you want to find the address of a specific employee, you have to know which employee to look for, or you can simply examine all employees. You do not have to search the entire hierarchy from the company downward, to find a single employee. Another benefit of the relational database model is that different tables can be linked together, regardless of their hierarchical position. Obviously, a relationship should exist between the two tables, but you are not restricted by a strict hierarchical structure.
Therefore, a table can be linked to both any number of parent tables and any number of child tables.
Many of today's businesses rely on their database systems for accurate,up-to-date information. 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.