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.
5
votes
1answer
187 views
IIS access log to SQL normalization
I am looking for insert IIS 6.0 access log ( 5 servers, and over 400MB daily ) to SQL database. What scares me is the size. There is a lot of information you are duplicating (i.e. site name, url, ...
1
vote
1answer
516 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. ...
13
votes
5answers
1k 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 ...
13
votes
3answers
615 views
Duplicate column for faster queries?
The title doesn't make to much sense but i couldn't think a better title for this problem.
I have the following tabels
Projects
id
name
Customers
id
id_project
name
Payments
id
id_customer
...
5
votes
3answers
191 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
621 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 ...
