Database Design Methodology: Conceptual, Logical, and Physical Design, Lecture notes of Design

Download Database Design Methodology: Conceptual, Logical, and Physical Design and more Lecture notes Design in PDF only on Docsity! Conceptual Databases Design 2 Design Methodology ◆  A structured approach that uses procedures, techniques, tools, and documentation aids to support and facilitate the process of design. 5 Logical Database Design ◆  The process of constructing a model of the data based on a specific data model (e.g. relational), but independent of a particular DBMS and other physical considerations. 6 Physical Database Design ◆  The process of producing a description of the implementation of the database. It describes the base relations and indexes design used to achieve efficient access to the data, and any security measures. 7 Build Conceptual Data ◆  To build a conceptual data model of the data requirements of the enterprise. –  Identify entity types –  Identify relationship types between entities –  Identify attributes associated with entity or relationship types –  Determine candidate, primary, and alternate key attributes –  Consider use of enhanced modeling concepts, such as specialization / generalization (optional step) –  Review conceptual data model with user