Chapter 9 MC

"What are the requirements of the current system's end users?"is a question asked during the ____ phase of the SDLC.

Analysis

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

Analysis

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

Analysis

The database initial study phase of the DBLC involves ____.

Defining objectives

Evaluation, maintenance, and enhancement are part of the ____ phase of the SDLC.

Maintenance

The last step in the DBLC is ____.

Maintenance and evolution

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

Planning

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

Testing and Evaluation

The primary objective of database design is ____.

To create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models

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

Verification

The conceptual design step that determines end-user views, outputs, and transaction-processing requirements is ____.

Data analysis and requirements

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

Data-model verification

The process of database design and implementation is ____ development.

Database

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

Creating the conceptual design and selecting DBMS software are part of the ____ phase of the DBLC.

Database design

Analyzing the company situation is part of the ____ phase of the DBLC.

Database initial study

The first step in the DBLC is ____.

Database initial study

"Should the existing system be replaced?" is a question that is asked during the ____ stage of the SDLC.

Planning

The implementation of ____-produced applications tends to prolong the operational life of systems by making them easier to update and maintain.

CASE

The design of the system's processes is completed during the ____ phase of the SDLC.

Detailed Systems Design

Detailed system specification is part of the ____ phase of the SDLC.

Detailed systems design

The conceptual design step that defines the DBMS and data model to use is ____.

Distributed database design

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

Identify the ER model's central entity

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

Identify, analyze, and refine the business rules

Coding, testing, and debugging are part of the ____ phase of the SDLC.

Implementation

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

Implementation

The database is loaded during the ____ phase of the SDLC.

Implementation

Installing the DBMS, creating the database, and loading or converting the data are part of the ____ phase of the DBLC.

Implementation and Loading

The implementation and loading phase of the DBLC involves ____.

Installing the DBMS

The maintenance and evolution phase of the DBLC involves ____.

Introducing changes

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

Module

Producing the required information flow is part of the ____ phase of the DBLC.

Operation

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

Physical

____ allow(s) physical access to areas by authorized personnel only.

Physical Security

There are ____ stages in the DBLC.

Six

The SDLC is most important to the ____.

System designer

The process of creating an information system is known as ____ development.

Systems

There are ____ classical approaches to database design.

Two