CHAPTER 9: DATABASE DESIGN
1. Systems analysis establishes the need for an information system and its extent.
a. True
b. False
2. The term “database development” is used to describe the process of database design and implementation.
a. True
b. False
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
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
5. The Systems Development Life Cycle (SDLC) traces the history of an information system.
a. True
b. False
6. The Systems Development Life Cycle (SDLC) provides the big picture within which the database design and
application development can be mapped out and evaluated.
a. True
b. False
7. The Systems Development Life Cycle’s (SDLC’s) planning phase yields a general overview of the company
and its objectives.
a. True
b. False
Chapter 9: Database Design
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
b. False
9. The analysis phase of the Systems Development Life Cycle (SDLC) involves a cycle of coding, testing, and
debugging.
a. True
b. False
10. The result of analysis phase of the Systems Development Life Cycle (SDLC) should be a better understanding
of the system’s functional areas, actual and potential problems, and opportunities.
a. True
b. False
systems design phase.
a. True
b. False
12. In the detailed systems design phase of the Systems Development Life Cycle (SDLC), steps are laid out for
the conversion of a database from an old system to a new system.
a. True
b. False
Development Life Cycle (SDLC).
a. True
b. False
14. The detailed systems design phase of the Systems Development Life Cycle (SDLC) includes all the necessary
technical specifications for the screens, menus, reports, and other devices used to make the system more
efficient.
a. True
b. False
Chapter 9: Database Design
15. During the implementation phase of the Systems Development Life Cycle (SDLC), the hardware, database
management system (DBMS) software, and application programs are installed, and the database design is
implemented.
a. True
b. False
16. The system is subjected to exhaustive testing during the testing phase of the Systems Development Life Cycle
(SDLC).
a. True
b. False
17. In the Systems Development Life Cycle (SDLC), after testing is concluded, end-user training is not necessary.
a. True
b. False
18. The database contents might be loaded interactively or in batch mode using a variety of methods and devices
including customized user programs.
a. True
b. False
19. 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
b. False
20. A system maintenance activity generated in response to changes in the business environment is referred to as
corrective maintenance.
a. True
b. False
21. The Systems Development Life Cycle (SDLC) is a sequential process rather than an iterative process.
a. True
b. False
Chapter 9: Database Design
22. To analyze the company situation, the database designer must discover what the company’s operational
components are, how they function, and how they interact.
a. True
b. False
23. 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
b. False
24. The assignment of access rights may restrict operations on predetermined objects such as databases, tables,
views, queries, and reports.
a. True
b. False
25. The main purpose of a backup is to guarantee database restoration following a hardware or software failure.
a. True
b. False
26. In most modern relational DBMSs, a new database implementation requires the creation of special storage–
related constructs to house the end-user tables.
a. True
b. False
27. Data integrity is enforced by the database management system (DBMS) through the proper use of primary and
foreign key rules.
a. True
b. False
28. The testing and evaluation phase of the Database Life Cycle (DBLC) occurs after applications programming.
a. True
b. False
Chapter 9: Database Design
29. Database performance is one of the least important factors in all database implementations.
a. True
b. False
30. The overall purpose of the database initial study is to create the conceptual design.
a. True
b. False
31. Evaluation of database performance is rendered easier by the fact there are no standards to measure it.
a. True
b. False
32. The database administrator must be prepared to perform routine maintenance activities within the database.
a. True
b. False
33. Physical design becomes simpler when data is distributed at different locations.
a. True
b. False
34. Decentralized design is typical of relatively simple, small databases and can be successfully done by a single
person.
a. True
b. False
35. The process of creating an information system is known as .
a. systems development b. database development
c. network development d. enterprise development
36. The traditional Systems Development Life Cycle (SDLC) is divided into phases.
a. two b. three
c. four d. five
Chapter 9: Database Design
37. The initial assessment and the feasibility study are part of the Systems Development Life Cycle’s (SDLC’s)
phase.
a. planning b. analysis
c. detailed systems design d. implementation
38. Discovery of user requirements, existing system evaluation, and logical system design are part of the
phase of the Systems Development Life Cycle (SDLC).
a. planning b. analysis
c. detailed systems design d. implementation
39. Coding, testing, and debugging are part of the phase of the Systems Development Life Cycle (SDLC).
a. planning b. analysis
c. detailed systems design d. implementation
40. Installation and fine tuning are part of the phase of the Systems Development Life Cycle (SDLC).
a. planning b. analysis
c. detailed systems design d. implementation
41. “Should the existing system be replaced?” is a question that is asked during the stage of the Systems
Development Life Cycle (SDLC).
a. planning b. analysis
c. implementation d. maintenance
42. “What are the requirements of the current system’s end users?” is a question asked during the phase of
the Systems Development Life Cycle (SDLC).
a. planning b. analysis
c. implementation d. maintenance
43. The logical systems design is created during the phase of the Systems Development Life Cycle
(SDLC).
a. planning b. analysis
c. implementation d. maintenance
Chapter 9: Database Design
44. The feasibility study during the planning phase of the Systems Development Life Cycle (SDLC) must address
the:
a. requirements of the current system’s end users.
b. problems and constraints related to the company situation.
c. questions about modification and replacement of existing system.
d. technical aspects of hardware and software requirements.
45. The design of the system’s processes is completed during the phase of the Systems Development Life
Cycle (SDLC).
a. planning b. analysis
c. detailed systems design d. implementation
46. The database contents are loaded during the phase of the Systems Development Life Cycle (SDLC).
a. analysis b. detailed systems design
c. implementation d. maintenance
a. four b. five
c. six d. seven
48. The implementation of applications tends to prolong the operational life of systems by making them
easier to update and maintain.
a. database-produced b. network-produced
c. CASE-produced d. design-produced
49. Analyzing the company situation is part of the phase of the Database Life Cycle (DBLC).
a. database initial study
b. database design
c. testing, and evaluation
d. operation
50. Selecting database management system (DBMS) software is part of the phase of the Database Life
Cycle (DBLC).
a. database initial study b. database design
c. implementation and loading d. testing and evaluation
Chapter 9: Database Design
51. Installing the DBMS, creating the database, and loading or converting the data are part of the phase of
the Database Life Cycle (DBLC).
a. database initial study b. database design
c. implementation and loading d. testing and evaluation
52. Producing the required information flow is part of the phase of the Database Life Cycle (DBLC).
a. database initial study b. database design
c. operation d. testing and evaluation
53. The last step in the Database Life Cycle (DBLC) is .
a. maintenance and evolution b. operation
c. testing and evaluation d. implementation and loading
a. operation b. database design
c. database initial study d. implementation and loading
55. The database initial study phase of the Database Life Cycle (DBLC) involves .
a. defining objectives b. introducing changes
c. testing the database d. installing the DBMS
56. is a technique that creates logical representations of computing resources that are independent of the
underlying physical computing resources.
a. Normalization
b. Virtualization
c. Specialization
d. Generalization
57. The implementation and loading phase of the Database Life Cycle (DBLC) involves .
a. defining objectives b. introducing changes
c. testing the database d. installing the DBMS
Chapter 9: Database Design
58. In the context of the database design process, the conceptual design step that determines end-user views,
outputs, and transaction-processing requirements is .
a. data analysis and requirements
b. entity relationship modeling and normalization
c. data model verification
d. distributed database design
59. can render data useless to unauthorized users who might have violated some of the database security
layers.
a. Data encryption
b. Access rights
c. Physical security
d. Password security
60. In the context of the database design process, the conceptual design step that identifies ER modules and
validates insert, update, and delete rules is .
a. database analysis and requirements
b. ER modeling and normalization
c. data model verification
d. distributed database design
61. In the context of the database design process, the conceptual design step that defines the fragmentation and
allocation strategy is .
a. database analysis and requirements
b. ER modeling and normalization
c. data model verification
d. distributed database design
62. Once the data has been loaded into the database, the tests and fine-tunes the database for performance,
integrity, concurrent access, and security constraints.
a. programmer b. manager
c. database administrator d. systems administrator
Chapter 9: Database Design
63. Which of the following is a hardware-induced database failure?
a. Memory chip errors
b. Viruses
c. Malware
d. Abortion due to deadlock
a. defining objectives b. introducing changes
c. testing the database d. installing the DBMS
65. In a(n) , only the objects that have been updated or modified since the last full backup are backed up.
a. transaction log backup
b. conservative backup
c. differential backup
d. adaptive backup
66. The first step in developing the conceptual model using ER diagrams is to .
a. normalize the entities
b. complete the initial ER diagram
c. identify, analyze, and refine the business rules
d. define the attributes, primary keys, and foreign keys for each of the entities
a. identify each module and its components
b. identify the ER model’s central entity
c. verify all processes against the ER model
d. identify each module’s internal transaction requirements
68. is the process of determining the data storage organization and data access characteristics of the
database to ensure its integrity, security, and performance.
a. Conceptual design b. Network design
c. Logical design d. Physical design
Chapter 9: Database Design
69. During decentralized design, after the has been completed, all modules are integrated into one
conceptual model.
a. declaration process b. verification process
c. conceptual process d. logical process
70. A(n) is a carefully designed and constructed repository of facts that is a part of a larger whole known
as an information system.
71. is the process that establishes the need for, and the extent of, an information system.
72. The traditional Systems Development Life Cycle (SDLC) phases are , analysis, detailed systems design,
implementation, and maintenance.
73. An initial assessment of the information flow-and-extent requirements must be made during the portion
of the Systems Development Life Cycle (SDLC).
74. After testing is concluded, the final is reviewed and printed and end users are trained.
75. The advent of very sophisticated application generators and has substantially decreased coding and
testing time.
76. The system and operational costs are addressed by the during the planning phase of the Systems
Development Life Cycle (SDLC).
77. are usually provided by the database management system (DBMS) to check for access violations.
78. The describes the general conditions in which a company operates, its organizational structure, and its
mission.
79. The system’s defines the extent of the design according to operational requirements.
80. The proposed system is subject to limits known as , which are external to the system.
Chapter 9: Database Design
81. Making sure that the final product meets user and system requirements is the most critical phase.
82. Programmers use database tools to the applications during coding of the programs.
83. allow end users to access the database without being able to download the information from their
workstations.
84. allows the assignment of access rights to specific authorized users.
85. The stage uses data modeling to create an abstract database structure that represents real-world objects
in the most realistic way possible.
86. The first step in is to discover the data element characteristics.
87. A designer must have a thorough understanding of the company’s data types, extent, and uses in order to
develop an accurate _____.
88. From a database point of view, the collection of data becomes meaningful only when the are defined.
89. A rule is a brief and precise narrative of a policy, procedure, or principle within a specific
organization’s environment.
90. Because real-world database design is generally done by teams, the database design is probably divided into
major components known as .
91. A is an information system component that handles a specific business function, such as inventory,
orders, or payroll.
92. is the first stage in the database design process.
93. The term describes the extent to which modules are independent of one another.
Chapter 9: Database Design
94. The term describes the strength of the relationships found among a module’s entities.
95. When selecting DBMS , items to consider include processors, RAM, and disk space.
96. The goal is to design an enterprise-wide database based on a specific data model but independent of
physical-level details.
97. 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.
98. List and briefly describe the three types of system maintenance activities.
99. List and describe the different levels at which database backups can be performed.
100. What are the factors affecting the purchasing decision for DBMS software?
Chapter 9: Database Design
101. Explain the concept of logical design and list the steps involved.
102. What are the classical approaches to database design?
103. Explain the differences between a centralized and decentralized approach to database design.