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

1
vote
1answer
717 views

Multilingual Dictionary Database question

Let's say someone is coding a multilingual dictionary in PHP, and he wants to let people submit both words and definitions in English and Spanish, but wants to track it so they can be filtered. ...
14
votes
5answers
2k views

How far should you go with normalization?

I have a decent amount of data in a database. I have well formed tables and good relationships between them with some redundancy in my data. But how far should I go with normalization? Are there ...
15
votes
3answers
998 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
251 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
3k 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
1k 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 ...