Normalization
Download as pptx, pdf1 like728 views
The document discusses database normalization. It defines several normal forms including 1NF, 2NF, 3NF, BCNF, 4NF and 5NF. For each normal form, it provides a brief definition and explains how the current normal form builds upon the previous one by further restricting dependencies between attributes in a database table. The goal of normalization is to eliminate redundant or anomalous data and optimize database structure.
Normalization
- 2. Normalization Normalization Normal Form 3 1 1NF 2 2NF E.F.Codd 3 3NF Boyce/Codd Normal Form BCNF 4 4NF Fagin 5 5NF
- 4. ER-to-Relational Mapping Algorithm Strong Entity (PK) P1101 6 990 P1102 199
- 5. ER-to-Relational Mapping Algorithm PK J1101 2554 Weak Entity J1102 2554 FK) J1101 J1102
- 6. PK 550987786 Associative 550987787 Entity (FK) (FK) 550987786 LSIT1111 89 A 550987787 LSIT1113 49 F PK LSIT1111 LSIT1113
- 8. The Process of Normalization: First Normal Form 1NF 1NF Atomic 1 Repeating groups
- 9. The Process of Normalization: First Normal Form 1NF
- 10. The Process of Normalization: Second Normal Form 2NF 2NF 1NF (Primary key) Composite key Partial Dependency
- 11. The Process of Normalization: Second Normal Form 2NF 1NF 2NF
- 12. 2 NF
- 13. The Process of Normalization: Third Normal Form 3NF 3NF 2NF Transitive Dependency
- 14. The Process of Normalization: Third Normal Form 3NF 2NF 3NF
- 15. Boyce-Codd Normal Form(BCNF) (Candidate key) 2
- 17. BCNF
- 18. The Process of Normalization: Fourth Normal Form 4NF BCNF Multivalued Dependencies (MVDs) 3 2
- 19. BCNF 4NF
- 20. BCNF 4NF
- 21. The Process of Normalization: Fifth Normal Form 5NF 4NF Join Dependency
- 22. 5 NF
- 23. 5 NF