Chapter 9: Database Design

The overall purpose of the database initial study is to create the conceptual design. a. True b. False

ANSWER: False

Systems analysis establishes the need for an information system and its extent. a. True b. False

ANSWER: True

The term "database development" is used to describe the process of database design and implementation. a. True b. False

ANSWER: True

The advent of very sophisticated application generators and _____ has substantially decreased coding and testing time.

ANSWER: debugging tools

_____ are usually provided by the database management system (DBMS) to check for access violations.

ANSWER: Audit trails

_____ allow end users to access the database without being able to download the information from their workstations.

ANSWER: Diskless workstations

A system maintenance activity generated in response to changes in the business environment is referred to as corrective maintenance. a. True b. False

ANSWER: False

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

ANSWER: True

Data integrity is enforced by the database management system (DBMS) through the proper use of primary and foreign key rules. a. True b. False

ANSWER: True

"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

ANSWER: a

The last step in the Database Life Cycle (DBLC) is _____. a. maintenance and evolution b. operation c. testing and evaluation d. implementation and loading

ANSWER: a

The result of the _____ 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. analysis b. implementation c. detailed systems design d. maintenance

ANSWER: a

Which of the following is a hardware-induced database failure? a. Memory chip errors b. Viruses c. Malware d. Abortion due to deadlock

ANSWER: a

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

ANSWER: d

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

The first step in _____ is to discover the data element characteristics.

ANSWER: conceptual design

The term _____ describes the strength of the relationships found among a module's entities.

ANSWER: cohesivity

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

ANSWER: True

Evaluation of database performance is rendered easier by the fact there are no standards to measure it. a. True b. False

ANSWER: False

In the Systems Development Life Cycle(SDLC), the design of the system's processes begins in the detailed systems design phase. a. True b. False

ANSWER: False

The Systems Development Life Cycle (SDLC) is a sequential process rather than an iterative process. a. True b. False

ANSWER: False

The analysis phase of the Systems Development Life Cycle (SDLC) involves a cycle of coding, testing, and debugging. a. True b. False

ANSWER: False

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

The testing and evaluation phase of the Database Life Cycle (DBLC) occurs after applications programming. a. True b. False

ANSWER: False

_____ 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

_____ is the process that establishes the need for, and the extent of, an information system.

ANSWER: Systems analysis

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

ANSWER: True

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

ANSWER: True

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

ANSWER: True

The Systems Development Life Cycle (SDLC) traces the history of an information system. a. True b. False

ANSWER: True

The Systems Development Life Cycle's (SDLC's) planning phase yields a general overview of the company and its objectives. a. True b. False

ANSWER: True

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

ANSWER: True

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

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

ANSWER: a

The process of creating an information system is known as _____. a. systems development b. database development c. network development d. enterprise development

ANSWER: a

_____ 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

ANSWER: a

"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

ANSWER: b

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

ANSWER: b

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

ANSWER: b

In DBLC, the phase after the database initial study is _____. a. operation b. database design c. database initial study d. implementation and loading

ANSWER: b

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

ANSWER: b

The first step in the ER model verification process is to _____. 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

ANSWER: b

The logical systems design is created during the _____ phase of the Systems Development Life Cycle (SDLC). a. planning b. analysis c. implementation d. maintenance

ANSWER: b

The maintenance and evolution phase of the Database Life Cycle (DBLC) involves _____. a. defining objectives b. introducing changes c. testing the database d. installing the DBMS

ANSWER: b

_____ 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

ANSWER: b

The proposed system is subject to limits known as _____, which are external to the system.

ANSWER: boundaries

A(n) _____ rule is a brief and precise narrative of a policy, procedure, or principle within a specific organization's environment.

ANSWER: business rule

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

ANSWER: c

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

ANSWER: c

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

ANSWER: c

The _____ 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. analysis b. implementation c. detailed systems design d. maintenance

ANSWER: c

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

ANSWER: c

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

ANSWER: c

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

ANSWER: c

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

ANSWER: d

During the _____ 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. detailed systems design b. analysis c. maintenance d. implementation

ANSWER: d

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

ANSWER: d

The traditional Systems Development Life Cycle (SDLC) is divided into _____ phases. a. two b. three c. four d. five

ANSWER: d

Training principles and methodologies are planned during the _____ phase of the Systems Development Life Cycle (SDLC). a. maintenance b. implementation c. analysis d. detailed systems design

ANSWER: d

_____ 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

ANSWER: d

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

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

After testing is concluded, the final _____ is reviewed and printed and end users are trained.

ANSWER: documentation

When selecting DBMS _____, items to consider include processors, RAM, and disk space.

ANSWER: hardware

The _____ goal is to design an enterprise-wide database based on a specific data model but independent of physical-level details.

ANSWER: logical design

A(n) _____ is an information system component that handles a specific business function, such as inventory, orders, or payroll.

ANSWER: module

Because real-world database design is generally done by teams, the database design is probably divided into major components known as _____.

ANSWER: modules

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

The traditional Systems Development Life Cycle (SDLC) phases are _____, analysis, detailed systems design, implementation, and maintenance.

ANSWER: planning

The system's _____ defines the extent of the design according to operational requirements.

ANSWER: scope