Normalization is the process of organizing columns into tables within a relational database in such a way as to minimize redundancy and avoid insertion, update and deletion anomalies.

learn more… | top users | synonyms

15
votes
3answers
795 views

Duplicate column for faster queries?

The title doesn't make too much sense, but I couldn't think a better title for this problem. I have the following tables Projects id name Customers id id_project name Payments id ...
5
votes
3answers
233 views

Do higher normalized forms always meet the criteria of lower ones?

For example, a database that is 3NF is always 1NF and 2NF; does this hold for 4, 5, and 6?
9
votes
2answers
2k views

Normalization Exercise Resources

I want to sharpen my database normalization skills. Where can I find good quality beginner-to-advanced level exercises (with solutions) on the web ?
3
votes
3answers
900 views

3NF Vs 2NF, which is more strict?

Which of these is true: If a table is in 2nd normal-form then it must be in 3rd normal-form. If a table is in 3rd normal-form then it must be in 2nd normal-form. I know only one of them is ...