Chapter 09 Database Design Completion

Chapter 09: Database Design Completion 51. A(n) _____ is a carefully designed and constructed repository of facts that is a part of a larger whole known as an information system. ANSWER: database 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 52. _____ is the process that establishes the need for, and the extent of, an information system. ANSWER: Systems analysis 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 53. The traditional Systems Development Life Cycle (SDLC) phases are _____, analysis, detailed systems design, implementation, and maintenance. ANSWER: planning DIFFICULTY: REFERENCES: Difficulty: Easy 9-2 The Systems Development Life Cycle LEARNINGOBJECTIVES: 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 54. An initial assessment of the information flow-and-extent requirements must be made during the _____ portion of the Systems Development Life Cycle (SDLC). ANSWER: planning DIFFICULTY: Difficulty: Easy REFERENCES: 9-2a Planning LEARNINGOBJECTIVES: 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 55. After testing is concluded, the final _____ is reviewed and printed and end users are trained. ANSWER: documentation DIFFICULTY: Difficulty: Easy REFERENCES: 9-2d Implementation LEARNINGOBJECTIVES: 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 56. The advent of very sophisticated application generators and _____ has substantially decreased coding and testing time. ANSWER: debugging tools DIFFICULTY: Difficulty: Easy REFERENCES: 9-2d Implementation Page10 Chapter 09: Database Design LEARNINGOBJECTIVES: 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 57. The system’s _____ defines the extent of the design according to operational requirements. ANSWER: scope DIFFICULTY: Difficulty: Easy REFERENCES: 9-3a The Database Initial Study LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 58. The proposed system is subject to limits known as _____, which are external to the system. ANSWER: boundaries DIFFICULTY: Difficulty: Easy REFERENCES: 9-3a The Database Initial Study LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 59. _____ are usually provided by the database management system (DBMS) to check for access violations. ANSWER: Audit trails DIFFICULTY: Difficulty: Easy REFERENCES: 9-3d Testing and Evaluation LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 60. _____ allow end users to access the database without being able to download the information from their workstations. ANSWER: Diskless workstations DIFFICULTY: Difficulty: Moderate REFERENCES: 9-3d Testing and Evaluation LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 61. The _____ stage uses data modeling to create an abstract database structure that represents real-world objects in the most realistic way possible. ANSWER: conceptual design DIFFICULTY: Difficulty: Easy REFERENCES: 9-4 Conceptual Design LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 62. The first step in _____ is to discover the data element characteristics. ANSWER: conceptual design DIFFICULTY: Difficulty: Easy REFERENCES: 9-4a Data Analysis and Requirements LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework Page11 Chapter 09: Database Design 63. A designer must have a thorough understanding of the company's data types, extent, and uses in order to develop an accurate _____. ANSWER: data model DIFFICULTY: Difficulty: Easy REFERENCES: 9-4a Data Analysis and Requirements LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 64. A(n) _____ rule is a brief and precise narrative of a policy, procedure, or principle within a specific organization's environment. ANSWER: business rule DIFFICULTY: Difficulty: Easy REFERENCES: 9-4a Data Analysis and Requirements LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 65. Because real-world database design is generally done by teams, the database design is probably divided into major components known as _____. ANSWER: modules DIFFICULTY: Difficulty: Easy REFERENCES: 9-4c Data Model Verification LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 66. A(n) _____ is an information system component that handles a specific business function, such as inventory, orders, or payroll. ANSWER: module DIFFICULTY: Difficulty: Easy REFERENCES: 9-4c Data Model Verification LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 67. The term _____ describes the strength of the relationships found among a module’s entities. ANSWER: cohesivity DIFFICULTY: Difficulty: Easy REFERENCES: 9-4c Data Model Verification LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 68. When selecting DBMS _____, items to consider include processors, RAM, and disk space. ANSWER: hardware DIFFICULTY: Difficulty: Easy REFERENCES: 9-5 DBMS Software Selection LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework Page12 Chapter 09: Database Design 69. The _____ goal is to design an enterprise-wide database based on a specific data model but independent of physicallevel details. ANSWER: logical design DIFFICULTY: Difficulty: Easy REFERENCES: 9-6 Logical Design LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 70. _____ could become a very technical job that affects not only the accessibility of the data in the storage device(s) but also the performance of the system. ANSWER: Physical design DIFFICULTY: Difficulty: Easy REFERENCES: 9-7 Physical Design LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework Page13