Explore BrainMass

Discussing the Concept of Normalization

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Question: In your own words, explain the concept of normalization. What does normalization accomplish? What are the advantages of normalization? In general, how do you go about normalizing a relation?

© BrainMass Inc. brainmass.com October 24, 2018, 6:36 pm ad1c9bdddf

Solution Preview

Normalization is the process of removing redundant data from your tables in order to improve storage efficiency, data integrity and scalability. This improvement is balanced against an increase in complexity and potential performance losses from the joining of the normalized tables at query-time.

In relational database design, the process of organizing data to minimize redundancy. Normalization usually involves dividing a database into two or more tables and defining relationships between the tables. The objective is to isolate data so ...

See Also This Related BrainMass Solution

Basis of normalization principle

The "right" database design can rarely be decided on the basis of normalization principle alone. Do you agree or disagree? Discuss.

View Full Posting Details