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

Word可编辑 PAGE PAGE 33 Word可编辑 SOLUTIONS TO REVIEW QUESTIONS AND EXERCISES FOR PART 3 - DATABASE ANALYSIS AND DESIGN (CHAPTERS 10 – 15) Solutions to Review Questions and Exercises TOC \o 1-1 \h \z Chapter 10 Database System Developmemt Lifecycle 3 Chapter 11 Database Analysis and the DreamHome Case Study 6 Chapter 12 Entity-Relationship Modeling 10 Chapter 13 Enhanced Entity-Relationship Modeling 16 Chapter 14 Normalization 19 Chapter 15 Advanced Normalization 28  Chapter 10 Database System Development Lifecycle Review Questions 10.1 Describe the major components of an information system. Database, database software, application software, computer hardware including storage media, and people using and developing the system. 10.2 Discuss the relationship between the information systems lifecycle and the database system development lifecycle. See Sections 10.1 and 10.2. 10.3 Describe the main purpose(s) and activities associated with each stage of the database system development lifecycle. See Table 10.1 in Section 10.2. 10.4 Discuss what a user view represents in the context of a database system. User view: defines what is required of a database system from the perspective of a particular job role (such as Manager or Supervisor) or enterprise application area (such as marketing, personnel, or stock control) (See Section 10.4.1). 10.5 Discuss the main approaches for managing the design of a database system that has multiple user views. Three main approaches: centralized, view integration, and combination of both approaches (see Section 10.5). 10.6 Compare and contrast the three phases of database design. Three phases are conceptual database design, logical database design, and physical database design. Conceptual database design constructs a model of the information used in an enterprise, independent of all physical considerations. Logical database design is based on a specific data model, but independent of all other physical consid