Chapter 09 Database Design True False

Chapter 09: Database Design True / False 1. Systems analysis establishes the need for an information system and its extent.  a. True  b. False ANSWER: True DIFFICULTY: Difficulty: Easy REFERENCES: 9-1 The Information System LEARNINGOBJECTIVES:09.01 - Describe the role of database design as the foundation of a successful information  system 2. The term “database development” is used to describe the process of database design and implementation.  a. True  b. False ANSWER: True DIFFICULTY: Difficulty: Easy REFERENCES: 9-1 The Information System LEARNINGOBJECTIVES:09.01 - Describe the role of database design as the foundation of a successful information  system 3. The primary objective in database design is to create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models.  a. True  b. False ANSWER: True DIFFICULTY: Difficulty: Easy REFERENCES: 9-1 The Information System LEARNINGOBJECTIVES:09.01 - Describe the role of database design as the foundation of a successful information  system 4. The implementation phase of database design includes creating the database storage structure and loading the database, but does not provide for data management.  a. True  b. False ANSWER: False DIFFICULTY: Difficulty: Moderate REFERENCES: 9-1 The Information System LEARNINGOBJECTIVES:09.01 - Describe the role of database design as the foundation of a successful information  system 5. The Systems Development Life Cycle (SDLC) traces the history of an information system.  a. True  b. False ANSWER: True DIFFICULTY: Difficulty: Easy REFERENCES: 9-2 The Systems Development Life Cycle Page1 Chapter 09: Database Design LEARNINGOBJECTIVES: 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 6. The Systems Development Life Cycle (SDLC) is a sequential process rather than an iterative process.   a. True ANSWER: DIFFICULTY: REFERENCES: b. False False Difficulty: Moderate 9-2 The Systems Development Life Cycle LEARNINGOBJECTIVES: 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 7. The Systems Development Life Cycle's (SDLC's) planning phase yields a general overview of the company and its objectives.   a. True ANSWER: DIFFICULTY: REFERENCES: b. True Difficulty: Easy 9-2a Planning False LEARNINGOBJECTIVES: 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 8. In the Systems Development Life Cycle (SDLC), problems defined during the planning phase are examined in greater detail during the analysis phase.   a. True ANSWER: DIFFICULTY: REFERENCES: b. True Difficulty: Easy 9-2b Analysis False LEARNINGOBJECTIVES: 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 9. The analysis phase of the Systems Development Life Cycle (SDLC) involves a cycle of coding, testing, and debugging.   a. True ANSWER: DIFFICULTY: REFERENCES: b. False False Difficulty: Moderate 9-2d Implementation LEARNINGOBJECTIVES: 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 10. In the Systems Development Life Cycle(SDLC), the design of the system's processes begins in the detailed systems design phase.   a. True ANSWER: DIFFICULTY: REFERENCES: b. False False Difficulty: Easy 9-2c Detailed Systems Design LEARNINGOBJECTIVES: 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 11. In the detailed systems design phase of the Systems Development Life Cycle (SDLC), steps are laid out for the Page2 Chapter 09: Database Design conversion of a database from an old system to a new system.   a. True ANSWER: DIFFICULTY: REFERENCES: b. False True Difficulty: Easy 9-2c Detailed Systems Design LEARNINGOBJECTIVES: 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 12. The database contents might be loaded interactively or in batch mode using a variety of methods and devices including customized user programs.   a. True ANSWER: DIFFICULTY: REFERENCES: b. False True Difficulty: Moderate 9-2d Implementation LEARNINGOBJECTIVES: 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 13. A system is always at some stage of SDLC because every request for structural changes requires retracing the steps of the Systems Development Life Cycle (SDLC).   a. True ANSWER: DIFFICULTY: REFERENCES: b. False True Difficulty: Easy 9-2e Maintenance LEARNINGOBJECTIVES: 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 14. A system maintenance activity generated in response to changes in the business environment is referred to as corrective maintenance.   a. True ANSWER: DIFFICULTY: REFERENCES: b. False False Difficulty: Easy 9-2e Maintenance LEARNINGOBJECTIVES: 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 15. The overall purpose of the database initial study is to create the conceptual design.   ANSWER: DIFFICULTY: REFERENCES: a. True b. False False Difficulty: Moderate 9-3a The Database Initial Study LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 16. After the initial declarations in Database Life Cycle (DBLC), the database designer must carefully probe in order to generate additional information that will help define the problem within the larger framework of company operations. a. True Page3 Chapter 09: Database Design  ANSWER: DIFFICULTY: REFERENCES: b. False True Difficulty: Easy 9-3a The Database Initial Study LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 17. In most modern relational DBMSs, a new database implementation requires the creation of special storage-related constructs to house the end-user tables.  a. ANSWER: DIFFICULTY: REFERENCES: True b. False True Difficulty: Easy 9-3c Implementation and Loading LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 18. Data integrity is enforced by the database management system (DBMS) through the proper use of primary and foreign key rules. a. ANSWER: DIFFICULTY: REFERENCES: True b. False True Difficulty: Moderate 9-3d Testing and Evaluation LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 19. The testing and evaluation phase of the Database Life Cycle (DBLC) occurs after applications programming. a. ANSWER: DIFFICULTY: REFERENCES: True b. False False Difficulty: Easy 9-3d Testing and Evaluation LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 20. Evaluation of database performance is rendered easier by the fact there are no standards to measure it. a. ANSWER: DIFFICULTY: REFERENCES: True b. False False Difficulty: Easy 9-3d Testing and Evaluation  LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC)  framework Page4