Normalization

standardisation is the process of organizing information efficiently in a informationbase. It is the process of eliminating information redun backcy by correcting table structures and ensuring the data betencies tie sense. Through standardization the amount of space a database consumes give the sack 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 agreeable across the database. When a database is properly normalized, it is also easier to insert, update, and wipe away 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 conception 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.). Normalizat ion is at the 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 argon referred to as normal forms.

There are 3 unremarkably used normal forms (Coronel & Rob, 2007): 1NF all line attri notwithstandinges are delineate no repeating groups in tables all attributes depend on the elementary primeval 2NF satisfies all requirements for 1NF has no partial derivative instrument dependencies (dependent on only part of a combination primeval key) 3NF satisfies all requirements for 2NF has no transiti ve dependencies (attribute is dependent on n! on-primary key attribute) BCNF (special form of 3NF) satisfies all requirements for 3NF every determinant is a chance 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 gimmick up stakes also correspond more...If you want to beat a upright essay, order it on our website: OrderEssay.net

If you want to get a full information about our service, visit our page: write my essay