Chapter 9 Quiz Answers – Flashcards

Flashcard maker : Alexander Rose
“Should the existing system be replaced?” is a question that is asked during the ____ stage of the SDLC.
Planning

“What are the requirements of the current system’s end users?”is a question asked during the ____ phase of the SDLC.
Analysis

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

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

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

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

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

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

Installation and fine tuning are part of 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

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

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

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

The SDLC is most important to the ____.
System designer

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

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

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

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 database initial study phase of the DBLC involves ____.
Defining objectives

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

The design of the system’s processes is completed during the ____ phase of the SDLC.
Detailed Systems Design

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

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

The first step in the ER model verification process is to ____.
Identify the ER model’s central entity

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

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

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

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

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

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

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

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

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

The traditional SDLC is divided into ____ phases.
Five

There are ____ classical approaches to database design.
Two

There are ____ stages in the DBLC.
Six

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

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

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

Get an explanation on any task
Get unstuck with the help of our AI assistant in seconds
New