DB 9

The primary objective of database design is ____.
To create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models

There are ____ classical approaches to database design.
two

The conceptual design step that identifies ER modules and validates insert, update, and delete rules is ____.
data-model verification

The database initial study phase of the DBLC involves ____.
defining objectives

The initial assessment and the feasibility study are part of the SDLC’s ____ phase.
planning

The ____ design is the process of selecting the data storage and data access characteristics of the database.
physical

The maintenance and evolution phase of the DBLC involves ____.
introducing changes

The first step in the DBLC is ____.
database initial study

The SDLC is most important to the ____.
system designer

Detailed system specification is part of the ____ phase of the SDLC.
detailed systems design

The implementation and loading phase of the DBLC involves ____.
installing the DBMS

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

____ coupling describes the extent to which modules are independent of one another.
Module

Testing, fine-tuning, and evaluating the database and its applications are part of the ____ phase of the DBLC.
testing and evaluation

Analyzing the company situation is part of the ____ phase of the DBLC.
database initial study

The last step in the DBLC is ____.
maintenance and evolution

The conceptual design step that defines entities, attributes, and relationships is ____.
entity relationship modeling and normalization

The traditional SDLC is divided into ____ phases.
five

The process of database design and implementation is ____ development.
database

Installation and fine tuning are part of the ____ phase of the SDLC.
implementation

The logical systems design is created during the ____ phase of the SDLC.
analysis

The first step in developing the conceptual model using ER diagrams is to ____.
identify, analyze, and refine the business rules

User requirements, existing system evaluation, and logical system design are part of the ____ phase of the SDLC.
analysis