(数据库原理课件）Chapter5 Normalization宣讲培训.pptVIP

Chapter 5 Normalization;Objectives;Normalized vs. Denormalized;Denormalized Sample Data;Denormalized Design Causes Update Problems;Normalized Design Eliminates the Insert Problem;Denormalized Design Creates Delete Problems;Normalized Design Eliminates the Delete Problem;First Normal Form (1NF);Solving a 1NF Violation;Tables in 1NF Eliminate Repeating Data Problems;Determinants / Functional Dependence;Determinants and Duplicate Data;Second Normal Form (2NF);Update Problem Caused by 2NF Violation;Solving a 2NF Violation;All Keys Are Now Determinants;2NF Solution with Sample Data;2NF;Third Normal Form (3NF);Update Problem Caused by 3NF Violation;Solving a 3NF Violation;Keys Are Now Determinants;3NF Solution With Sample Data;Boyce-Codd Normal Form (BCNF);Update Problem Caused by a BCNF Violation;Solving a BCNF Violation;Keys Are Now Determinants;BCNF Solution With Sample Data;Fourth Normal Form (4NF);Update Problem Cause by a 4NF Violation;Solving a 4NF Violation;No More Than One Multi-Valued Determinant;4NF Solution with Sample Data;Detecting Normalization Violations;Summary;Summary;Summary;Summary;Summary;Summary;Summary;Summary;Summary;Exercise 1;Exercise 2;Exercise 3;不良的模式设计;范式之间的关系;候选码的计算;候选码的计算;候选码的计算