Normalization
Normalization is a process for evaluating and correcting table structures to minimize data redundancies, thereby reducing the likelihood of data anomalies. Normalization starts by identifying the dependencies of a given relation and progressively breaking up the relation (table) into a set of new relations (tables) based on the identified dependencies. Normal Forms 0NF Multi-valued attributes exists 1NF Any multi-valued attributes (repeating groups) have been removed. 2NF Any partial functional dependencies have been removed 3NF Any transitive dependencies have been removed BCNF Any anomalies resulting from functional dependencies have been removed 4NF Any multi valued dependencies have been removed 5NF ...
Comments
Post a Comment