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 Any remaining anomalies have been removed The table in 0NF : eliminate the nulls by making sure that each repeating group attribute contains an appropriate data va
Comments
Post a Comment