DB 9 – Flashcard
Unlock all answers in this set
Unlock answersquestion
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
question
The ____ design is the process of selecting the data storage and data access characteristics of the database.
answer
physical
question
The maintenance and evolution phase of the DBLC involves ____.
answer
introducing changes
question
The first step in the DBLC is ____.
answer
database initial study
question
The SDLC is most important to the ____.
answer
system designer
question
Detailed system specification is part of the ____ phase of the SDLC.
answer
detailed systems design
question
The implementation and loading phase of the DBLC involves ____.
answer
installing the DBMS
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
question
____ coupling describes the extent to which modules are independent of one another.
answer
Module
question
Testing, fine-tuning, and evaluating the database and its applications are part of the ____ phase of the DBLC.
answer
testing and evaluation
question
Analyzing the company situation is part of the ____ phase of the DBLC.
answer
database initial study
question
The last step in the DBLC is ____.
answer
maintenance and evolution
question
The conceptual design step that defines entities, attributes, and relationships is ____.
answer
entity relationship modeling and normalization
question
The traditional SDLC is divided into ____ phases.
answer
five
question
The process of database design and implementation is ____ development.
answer
database
question
Installation and fine tuning are part of the ____ phase of the SDLC.
answer
implementation
question
The logical systems design is created during the ____ phase of the SDLC.
answer
analysis
question
The first step in developing the conceptual model using ER diagrams is to ____.
answer
identify, analyze, and refine the business rules
question
User requirements, existing system evaluation, and logical system design are part of the ____ phase of the SDLC.
answer
analysis
