Explore BrainMass
Share

Discussing the Concept of Normalization

This content was STOLEN from BrainMass.com - View the original, and get the 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 September 22, 2018, 10:55 am ad1c9bdddf - https://brainmass.com/computer-science/databases/discussing-the-concept-of-normalization-44291

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 ...

$2.19