Exam 9: Database Design

Which of the following is a hardware-induced database failure?

Training principles and methodologies are planned during the _____ phase of the Systems Development Life Cycle (SDLC).

The primary objective in database design is to create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models.

In the context of the database design process, the conceptual design step that defines the fragmentation and allocation strategy is _____.

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

The _____ stage uses data modeling to create an abstract database structure that represents real-world objects in the most realistic way possible.

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

The overall purpose of the database initial study is to create the conceptual design.

The process of creating an information system is known as _____.

Once the data has been loaded into the database, the _____ tests and fine-tunes the database for performance, integrity, concurrent access, and security constraints.

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

During decentralized design, after the _____ has been completed, all modules are integrated into one conceptual model.

Producing the required information flow is part of the _____ phase of the Database Life Cycle (DBLC).

List and briefly describe the three types of system maintenance activities.

The first step in the ER model verification process is to _____.

In the context of the database design process, the conceptual design step that determines end-user views, outputs, and transaction-processing requirements is _____.

In the Systems Development Life Cycle (SDLC), problems defined during the planning phase are examined in greater detail during the analysis phase.

List and describe the different levels at which database backups can be performed.

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.

An initial assessment of the information flow-and-extent requirements must be made during the _____ portion of the Systems Development Life Cycle (SDLC).