Font size
WorksheetsDatabase Life Cycle
Total questions: 45
Worksheet time: 26mins
SDLC and DBLC oriented to the same purpose and focus.
TRUE
FALSE
Focus on function
SDLC
DBLC
Ignores data requirement.
SDLC
DBLC
Data oriented.
SDLC
DBLC
How many phases in SDLC ?
Two
Three
Four
Five
Six
How many phases in DBLC ?
Two
Three
Four
Five
Six
Initial study, Design, Implementation and Loading, Testing and Evaluation, Operation, Maintenance and Evolution are phases in (a) .
Planning, Analysis, Design, Implementation and Maintenance are phases in (a) .
In which SDLC phases that end user can begin request changes in the system.
Planning
Analysis
Design
Implementation
Maintenance
In which SDLC phases that all the necessary technical specifications for the screens, menus, report and other devices are begin to develop.
Planning
Analysis
Design
Implementation
Maintenance
In which SDLC phases that the Data Flow Diagram (DFD) is created.
Planning
Analysis
Design
Implementation
Maintenance
In which SDLC phases that involved hardware installation and software debugged.
Planning
Analysis
Design
Implementation
Maintenance
What is the purpose of phase 1 of initial study in DBLC
To create data model
To define problem and constraints
To analyze the organisation situation
To scout the DBMS vendor
To define objectives of the database
The most critical phase in DBLC.
Phase 1: Initial Study
Phase 2 : Design
Phase 3: Implementation and Loading
Phase 4: Testing and Evaluation
Phase 5: Operation
How many design approach in DBLC
One
Two
Three
Four
Data elements (items) ----> Data sets
Top-down design approach
Bottom-up design approach
Data sets ---> Data elements (items)
Top-down design approach
Bottom-up design approach
In bottom-up design approach in DBLC , development start at which level ?
Attribute
Conceptual
Entity
In top-down design approach in DBLC , development start at which level ?
Attribute
Conceptual
Entity
In design phase of DBLC , what is the stage following DBMS selection.
Data modelling
Data model verification
Logical design
Normalization
Physical design
In design phase of DBLC , what is the stage prior to DBMS selection.
Data modelling
Data model verification
Logical design
Normalization
Physical design
In design phase of DBLC , what is the stage prior to DBMS selection.
Data modelling
Data model verification
Logical design
Normalization
Physical design
Which of the following is part of the conceptual design process in DBLC ?
DBMS selection
Data Model Verification
Logical design
Normalization
Data modelling
The first stage in design phase in DBLC
Data modelling
Data model verification
Logical design
Normalization
Physical design
The final stage in design phase in DBLC
Data modelling
Data model verification
Logical design
Normalization
Physical design
ERD in design phase is used to ____________
model the real world objects
model the data conceptually
model the database structure
model the dependency of DBMS
Design phase in DBLC is dependent on the hardware and software.
TRUE
FALSE
Design phase in DBLC is independent from the hardware and software.
TRUE
FALSE
Normalization in conceptual design phase is a process of identifying dependencies between
(a)
What is the stage following the normalization in conceptual design process of DBLC.
DBMS selection
Physical design
Data model verification
Data modelling
What is the stage before the normalization in conceptual design process of DBLC.
DBMS selection
Physical design
Data model verification
Data modelling
In Data Model Verification the (a) model is verified against the processes of the proposed system.
Which of the following is the factors that affecting the DBMS selection.
Cost
Skills
Features and tools
Hardware requirements
The phase that determine the data storage features of DBMS.
Logical design
Physical design
Conceptual design
Mapped to logical design.
Logical design
Physical design
Conceptual design
Following the logical design.
Logical design
Physical design
Conceptual design
DBMS installation is part of the
Phase 1: Initial Study
Phase 2 : Design
Phase 3: Implementation and Loading
Phase 4: Testing and Evaluation
Phase 5: Operation
DBMS will adapt to user.
TRUE
FALSE
User must adapt to DBMS.
TRUE
FALSE
To ensure the database performs as expected is a part of the activity in
Phase 1: Initial Study
Phase 2 : Design
Phase 3: Implementation and Loading
Phase 4: Testing and Evaluation
Phase 5: Operation
Data (a) is enforced by the DBMS through the use of keys and constraints.
Evaluation only to be carried out between the data and database.
TRUE
FALSE
It is not necessary to test the user access privileges to the database system.
TRUE
FALSE
Formal training session will be held in
Phase 1: Initial Study
Phase 2 : Design
Phase 3: Implementation and Loading
Phase 4: Testing and Evaluation
Phase 5: Operation
Routine maintenance for database includes
Adaptive
Corrective
Preventive
Security
