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
