1. HSCI 709: Healthcare Databases Normalization of Databases

 2. Objectives of Design

 3. Design Principles

 4. Normalization

 5. Design Flaw 1

 6. First Normal Form

 7. Functional Dependency

 8. Full Functional Dependency

 9. Example for Full Functional Dependence

10. Second Normal Form

11. Violation of Second Normal Form

12. Third Normal Form

13. Violation of Third Normal Form

14. Rules for Good Design