“Previously, you learned how to represent an organization’s data graphically using an entity-relationship (E-R), or class, diagram. In this unit, you will learn guidelines used to design well-structured and efficient databases, and you will learn about logical and physical database design.”
Valacich, J. S., & George, J. F. (2017). Modern systems analysis and design (8th ed.). Boston: Pearson.
Activities
- Read: Chapter 9 in Modern Systems Analysis and Design
- Complete written assignment 11.1 (WA-11.1)
- Complete practical assignment 10.1
- Complete written assignment 10.1
Objectives
- describe the database design process, its outcomes, and the relational database model;
- describe normalization and the rules for second and third normal form;
- transform an entity-relationship (E-R) diagram into an equivalent set of well-structured (normalized) relations;
- merge normalized relations from separate user views into a consolidated set of well-structured relations; and
- describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to be indexed.
Topics
- Database Design
- Normalization
- Database Design from E-R Diagrams
- Merging Relations