PHYSICS 102 Lecture Notes - Lecture 13: Basel Ii, Functional Dependency, Railways Act 1921
Document Summary
9. 1 describe the database design process, its outcomes, and the relational database model; 9. 2 describe normalization and the rules for second and third normal form; 9. 3 transform an entity-relationship (e-r) diagram into an equivalent set of well-structured (normalized) relations; 9. 4 merge normalized relations from separate user views into a consolidated set of well-structured relations; In this chapter, you will learn guidelines for well-structured and efficient database files, and you will learn about logical and physical database design. The most common style for logical db model is the relational database model. Physical represents the specification for computer files and database in which to store data. In logical database design, you use a process called normalization, which is a way to build a data model that has the properties of simplicity, nonredundancy, and minimal maintenance. There are four key steps in logical database modeling and design: