MySQL 数据库系统设计实现与管理第六版课后习题答案Part 4 Review Questions and Exercises.doc

Word可编辑 PAGE PAGE 29 Word可编辑 SOLUTIONS TO REVIEW QUESTIONS AND EXERCISES FOR PART 4 – METHODOLOGY (CHAPTERS 16 – 19) Solutions to Review Questions and Exercises TOC \o 1-1 \h \z Chapter 16 Methodology - Conceptual Database Design 3 Chapter 17 Methodology - Logical Database Design for Relational Model 13 Chapter 18 Methodology - Physical Database Design for Relational Databases 22 Chapter 19 Methodology – Monitoring and Tuning the Operational System 27  Chapter 16 Methodology - Conceptual Database Design Review Questions 16.1 Describe the purpose of a design methodology. A structured approach that uses procedures, techniques, tools, and documentation aids, to support and facilitate the process of design. A design methodology consists of phases that contain steps, which guide the designer in the choice of techniques that are appropriate at each stage of the project and also helps to plan, manage, control and evaluate database development projects. Furthermore, it is a structured approach for analyzing and modeling a set of requirements for a database in a standardized and organized manner. See Section 16.1. 16.2 Describe the main phases involved database design. Conceptual database design – to build the conceptual representation of the database, which includes identification of the important entities, relationships, and attributes. Logical database design – to translate the conceptual representation to the logical structure of the database, which includes designing the relations. Physical database design – to decide how the logical structure is to be physically implemented (as relations) in the target Database Management System (DBMS). See Section 16.1.2 for complete definitions. 16.3 Identify important factors in the success of logical database design. Work interactively with the users as much as possible Follow a structured methodology throughout the data modeling process Employ a data-driven approach Incorporate structural and integrity c