Data Normalization :: Essays Papers

selective in stratumation NormalizationData standardisation is an important step in some(prenominal) database development process. Through this tedious process a developer can pass away duplication and develop standards by which exclusively data can be measured. This paper addresses the history and function of data generalization as it applies to the pargonntage at hand.In 1970, Dr. E.F. Codds seminal paper A Relational lesson for Large Shared Databanks was published in Communications of the ACM. This paper introduced the guinea pig of data universalization, so-named because, at the time, President Nixon was prevalentizing relations with China.Data normalization is a technique used during logical data modeling to ensure that in that respect is only maven way to know a event, by removing all structures that provide more than one way to know the same fact as represented in a database relation (table). The goal of normalization is to control and eliminate redundancy, and mitigate the effects of modification anomalies -- which are broadly insertion and deletion anomalies. (Insertion anomalies occur when the storage of in directation about one attribute requires additional in excogitateation about a second attribute. cut anomalies occur when the deletion of one fact results in the loss of a second fact).NormalizationThere are six generally recognise normal forms of a relation first normal form, second normal form, third normal form, Boyce/Codd normal form, fourth normal form, and fifth normal form, also called projection/join normal form. Other normal forms (e.g., realm/Key) exist but will not be discussed here. The normal forms are hierarchical, i.e., each normal form builds upon its predecessor. Although many people consider a relation to be normalized only when it is in third normal form, technically speaking, a relation in only first normal form can be considered normalized. The Normal FormsFirst normal form (1NF) - totally attributes must be atomic. That is, there can exist no reiterate groups in an attribute. For example, in a relation that describes a student, the students classes should not be stored in one field, separated by commas. Rather, the classes should be moved to their give birth relation, which should include a link back to the student relation (called a foreign key).Second normal form (2NF) - A relation is in second normal form if it is in first normal form and each attribute is fully functionally dependent on the entire primary key. That is, no subset of the key can determine an attributes value.Third normal form (3NF) - A relation is in third normal form if it is in second normal form and each non-key attribute is fully functionally dependent on the entire primary key, and not on any other non-key attribute.