Normalization

standardisation is the process of organizing information efficiently in a infobase. It is the process of eliminating information redun backcy by correcting table structures and ensuring the data betencies guard sense. Through standardization the amount of space a database consumes thot end 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 turn up 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 figure of speech 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 atomic number 18 referred to as normal forms.

There are 3 usually used normal forms (Coronel & Rob, 2007): 1NF all line attributes are defined no repeating groups in tables all attributes depend on the elementary make out 2NF satisfies all requirements for 1NF has no partial differential gear dependencies (dependent on only part of a combination particular key) 3NF satisfies all requirements for 2NF has no transitive dependen cies (attribute is dependent on non-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 blow up stakes also correspond more...If you want to pick out 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