数据库课件Part 4 - 4 Database Design - Validation by Normalization 2011.pdf

Database Systems Design Part III : Normalization • Software School of Hunan University • Jin-Min Yang • 2011.04 Database Design Flow Diagram Investigation, Modeling analysis, (identify, deduce Individual research refine, abstract) Individual Part 1 , Part 1 Requirements ER-diagram Individual Requirements ER-diagram Individual Part n Part n Transformation User view 1 User view 1 Rational Rational Relations Relations Relations Relations User view n User view n Implement in Normalization Implement in particular DBMS particular DBMS Objectives ⇒What is normalization? ⇒Why is normalization is necessary? ⇒What is general principle of normalization? ⇒What is the theory basic of normalization? ⇒ How to normalize? ⇒Evaluating normalization in terms of the time versus space tradeoff. Contents ① motivations for normalization ⇒potential problems with data redundancy ②The principle of normalization. ⇒lossless-join property and dependency preservation property. ③the theory basic of normalization ⇒the concept of a functional dependency ④Normalization forms: 1NF. How to convert non-1NF relation to 1NF. 2NF. How to convert 1NF relat