Exam 9: Database Design

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

In a(n) , only the objects that have been updated or modified since the last full backup are backed up.

To analyze the company situation, the database designer must discover what the company's operational components are, how they function, and how they interact.

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

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

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

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.

In DBLC, the phase after the database initial study is .

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

The implementation and loading phase of the Database Life Cycle (DBLC) involves .

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

From a database point of view, the collection of data becomes meaningful only when the are defined.

can render data useless to unauthorized users who might have violated some of the database security layers.

What are the classical approaches to database design?

The first step in developing the conceptual model using ER diagrams is to .

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

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

Programmers use database tools to the applications during coding of the programs.

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.

In the context of the database design process, the conceptual design step that identifies ER modules and validates insert, update, and delete rules is .