Module 2: Understand Data Normalization and Denormalization

Module 2: Understand Data Normalization and Denormalization

• 2.6.1 Database Tables and Normalization (pg. 200) [5 minutes]
• 2.6.2 The Need for Normalization (pg. 200 - 203) [5 minutes]
• 2.6.3 The Normalization (pg. 203 - 209) [5 minutes]
• 2.6.4 Improving the Design (pg. 213 - 217) [5 minutes]
• 2.6.5 Surrogate Key Considerations (pg. 217 - 218) [5 minutes]
• 2.6.6 Higher-Level Normal Forms (pg. 218 - 224) [5 minutes]
• 2.6.7 Normalization and Database Design (pg. 213 - 217) [5 minutes]
• 2.6.8 Denormalization (pg. 227 - 230) [5 minutes]
• 2.6.9 Data-Modeling Checklist (pg. 230 - 231) [5 minutes]