Hard
EST. TIME: 40 minNormalization
To analyze and decompose schemas for Normalization (1NF to 5NF).
Theory
Normalization reduces data redundancy and improves data integrity.
Procedure
- Analyze functional dependencies.
- Decompose tables into normal forms.