DB 9 – Flashcard

23 test answers

Unlock all answers in this set

Unlock answers 23
question
The primary objective of database design is ____.
answer
To create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models
question
There are ____ classical approaches to database design.
answer
two
question
The conceptual design step that identifies ER modules and validates insert, update, and delete rules is ____.
answer
data-model verification
question
The database initial study phase of the DBLC involves ____.
answer
defining objectives
question
The initial assessment and the feasibility study are part of the SDLC's ____ phase.
answer
planning
Unlock the answer
question
The ____ design is the process of selecting the data storage and data access characteristics of the database.
answer
physical
Unlock the answer
question
The maintenance and evolution phase of the DBLC involves ____.
answer
introducing changes
Unlock the answer
question
The first step in the DBLC is ____.
answer
database initial study
Unlock the answer
question
The SDLC is most important to the ____.
answer
system designer
Unlock the answer
question
Detailed system specification is part of the ____ phase of the SDLC.
answer
detailed systems design
Unlock the answer
question
The implementation and loading phase of the DBLC involves ____.
answer
installing the DBMS
Unlock the answer
question
Once the data has been loaded into the database, the ____ tests and fine-tunes the database for performance, integrity, concurrent access, and security constraints.
answer
database administrator
Unlock the answer
question
____ coupling describes the extent to which modules are independent of one another.
answer
Module
Unlock the answer
question
Testing, fine-tuning, and evaluating the database and its applications are part of the ____ phase of the DBLC.
answer
testing and evaluation
Unlock the answer
question
Analyzing the company situation is part of the ____ phase of the DBLC.
answer
database initial study
Unlock the answer
question
The last step in the DBLC is ____.
answer
maintenance and evolution
Unlock the answer
question
The conceptual design step that defines entities, attributes, and relationships is ____.
answer
entity relationship modeling and normalization
Unlock the answer
question
The traditional SDLC is divided into ____ phases.
answer
five
Unlock the answer
question
The process of database design and implementation is ____ development.
answer
database
Unlock the answer
question
Installation and fine tuning are part of the ____ phase of the SDLC.
answer
implementation
Unlock the answer
question
The logical systems design is created during the ____ phase of the SDLC.
answer
analysis
Unlock the answer
question
The first step in developing the conceptual model using ER diagrams is to ____.
answer
identify, analyze, and refine the business rules
Unlock the answer
question
User requirements, existing system evaluation, and logical system design are part of the ____ phase of the SDLC.
answer
analysis
Unlock the answer
Get an explanation on any task
Get unstuck with the help of our AI assistant in seconds
New