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.
1
vote
1answer
249 views
Multiple values in lookup fields
I know newer versions of MS Access allow multiple selections in lookup fields.
For example, if I'm collecting information on my students, I can have a field called Race with lookup values that ...
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 ...
2
votes
3answers
253 views
Simple scenario needs to go from Unnormalized Data to 3NF - Review Please
NOTE: The Question has been updated. View Edit Revisions to view original question.
The scenario. An animal charity that at the moment, track their establishment's costs via a spreadsheet like so:
...
4
votes
1answer
807 views
2NF decomposition + database normalization
If anyone knows about 2NF I'd greatly appreciate if you could tell me if my understanding of it correct my book does not even mention it (except to say is of "historical significance") and I haven't ...
1
vote
1answer
484 views
Confusion in BCNF
I understood all the three normal forms which comes before BCNF but when it comes to the BCNF i am finding it extremely confusing and difficult and over the net also i found no good tutorial on it. ...
