Normalization

standardisation is the process of organizing information efficiently in a database. It is the process of eliminating data redun backcy by correcting table structures and ensuring the data betencies bandage sense. Through standardization the amount of space a database consumes buns be reduced and ensures the data is logically stored (Coronel & Rob, 2007). Redundant data non only wastes resources, it creats the possibility of storing values that ar not coherent across the database. When a database is properly normalized, it is also easier to insert, update, and wipe erupt data because each attri ande value is represented in a single location. Lastly, a normalized database provides a solid cloth for modifying and extending the radiation pattern of the database as future needs arise. E.F. Codd coined the term normalization in 1972 after hearing President Nixon talk slightly normalizing dealings with China in a speech (Nadkarni, n.d.). Normalization is at th e heart of good database design. Without normalization, the design is doomed to second-rater at best. During the normalization process, the database designer or developer determines whether the design meets real goals that ar referred to as normal forms.

There are 3 unremarkably used normal forms (Coronel & Rob, 2007): 1NF all line attri simplyes are delimit no repeating groups in tables all attributes depend on the elementary lynchpin 2NF satisfies all requirements for 1NF has no partial derived function dependencies (dependent on only part of a combination unproblematic key) 3NF satisfies all requirements for 2NF has no transitive dependencies (at! tribute is dependent on non-primary key attribute) BCNF (special form of 3NF) satisfies all requirements for 3NF every determinant is a medical prognosis key (has same characteristics as primary key but was not chosen to be PK) Normalizing tables helps manage the complexity of the data they contain and makes the database easier to maintain in the future. Table organization haul up stakes also correspond more...If you want to commence a upright essay, order it on our website: BestEssayCheap.com

If you want to get a full essay, visit our page: cheap essay