Database Implementation and Management 1: The overall purpose of the database in
ID: 3840555 • Letter: D
Question
Database Implementation and Management
1:
The overall purpose of the database initial study includes all of the following EXCEPT:
A: to define objectives.
B: to evaluate employee complaints.
C: to define scope and boundaries.
D: to define problems and constraints.
2:
__________ is a technique that creates logical representations of computing resources that are independent of the underlying physical computing resources.
A: Normalization
B: Specialization
C: Generalization
D: Virtualization
3:
In the context of the database design process, the conceptual design step that defines the fragmentation and allocation strategy is __________.
A: entity relationship (ER) modeling and normalization
B: distributed database design
C: data model verification
D: database analysis and requirements
4:
In the context of the database design process, the conceptual design step that identifies the entity relationship (ER) modules and validates insert, update, and delete rules is __________.
A: ER modeling and normalization
B: data model verification
C: database analysis and requirements
D: distributed database design
5:
The point where the database, its management, its users, and its application programs constitute a complete information system is called the __________ phase of the database life cycle (DBLC).
A: testing and evaluation
B: operation
C: database initial study
D: database design
Explanation / Answer
1. option B
employee complaint evaluation is not included in Database study.
2. option D
Virtualization
3. option B
Distributed Database Design: it defines the locaiton table access requirements and fragmentation strategies
4. option A
ER modelling and Normalization
5. option B
Operational. once the database has passed evaluation stage, it is considered as operational. At this point, the database, its management, its users and applications constitute complete information system.