O'Reilly logo

Database Systems by Shripad V. Godbole, Elvis C. Foster

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 4

image

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required