BMGT 402 Lecture Notes - Lecture 19: Conceptual Schema, Relational Model, Database Design

• School: University of Maryland
• Department: Business and Management
• Course: BMGT 402
• Professor: Woei- Jyh Lee

Document Summary

Bmgt402 lecture 19 - chapter 16: database design methodology. Design methodology: a structured approach that uses procedures, techniques, tools, and documentation aids to support and facilitate the process of design, three main phases of database design methodology. Process of constructing a data model used in an enterprise, independent of all physical considerations: logical database design. The process of constructing a specific relational data model, but independent of particular dbms and other physical considerations: physical database design. The process of producing a description of database implementation, which describes base relations, indexes, associated integrity constraints, and security measures: overview. 1. 3 identify and associate attributes with entity or relationship types o. 1. 5 determine candidate, primary, and alternate key attributes o. 1. 6 consider use of enhanced modeling concepts o: (optional step such as specialization, generalization, aggregation) 1. 7 check model for redundancy: redundant o, non redundant o. 1. 8 validate conceptual model against user transactions o. Step 2 build and validate logical data model.