Can I read Understanding Database Normalization on EtoBox?
Understanding Database Normalization by 8121868677p is a document available to read on EtoBox.
What is Understanding Database Normalization about?
The document discusses database normalization. It defines normalization as a process to eliminate redundant data in a database by restructuring tables. The key levels of normalization discussed are 1NF, 2NF, 3NF and BCNF. 1NF ensures fields only contain scalar values. 2NF removes functional dependencies on part of a composite primary key. 3NF removes transitive dependencies where non-key fields depend on other non-prime attributes. Properly normalized databases should be at least 3NF to avoid anomalies.
- Author
- 8121868677p
- Language
- EN