Database Systems

CHAPTER 4

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 ...