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 ...
Get Database Systems: Concepts, Design and Applications now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
