August 2009
Intermediate to advanced
893 pages
26h 48m
English
Content preview from Database Systems: Concepts, Design and Applications
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
10.3. Normal Forms
A normal form is a state of a relation that results from applying simple rules regarding functional dependencies (FDs) to that relation. It refers to the highest normal form of condition that it meets. Hence, it indicates the degree to which it has been normalised. The normal forms are used to ensure that various types of anomalies and inconsistencies are not introduced into the database. For determining whether a particular relation is in normal form or not, the FDs between the attributes in the relation are examined and not the current contents of the relation. First C. Berri and his co-workers proposed a notation to emphasise these relational characteristics. They proposed that the relation is defined as containing two ...