Database Reference
In-Depth Information
Integrity Rules and
Normalization
In order to design high quality databases, you need to be cognizant of the fundamental
integrity and normalization rules. We will discuss these rules in this chapter. Sub-topics
to be discussed include:
•
Fundamental Integrity Rules
•
Foreign Key Concept
•
Rationale for Normalization
•
Functional Dependence and Non-loss Decomposition
•
First Normal Form
•
Second Normal Form
•
Third Normal Form
•
Boyce/Codd Normal Form
•
Fourth Normal Form
•
Fifth Normal Form
•
Other Normal Forms
•
Summary and Concluding Remarks
4.1 Fundamental Integrity Rules
Two fundamental integrity rules that the database designer must be cognizant of are the
entity integrity rule
and the
referential integrity rule
.