Name: 
 

databasedesign


Multiple Choice
Identify the letter of the choice that best completes the statement or answers the question.
 

1. 
The performance of an information system depends on
a.
database design and implementation.
b.
application design and implementation.
c.
administrative procedures.
d.
a & b
e.
a, b & c
 

2. 
The traditional SDLC is divided into ________ phases.
a.
two
b.
three
c.
four
d.
five
e.
six
 

3. 
The initial assessment and the feasibility study are part of the sdlc's ___ phase.
a.
planning
b.
analysis
c.
detail System Design
d.
implementation
e.
maintenance
 

4. 
The user requirements, Existing system evaluation, and Logical system design are part of the
a.
planning phase.
b.
analysis phase.
c.
detail System Design phase.
d.
implementation phase.
e.
maintenance phase.
 

5. 
The detailed system specification is part of the
a.
planning phase.
b.
analysis phase.
c.
detail system design phase.
d.
implementation phase.
e.
maintenance phase.
 

6. 
The coding, testing, and debugging are part of the
a.
planning phase.
b.
analysis phase.
c.
detail system design phase
d.
implementation phase
e.
maintenance phase.
 

7. 
The installation and fine tuning are part of the
a.
planning phase.
b.
analysis phase.
c.
detail system design phase.
d.
implementation phase.
e.
maintenance phase.
 

8. 
The evaluation, maintenance, and enhancement are part of the
a.
planning phase.
b.
analysis phase.
c.
detailed systems design phase.
d.
implementation phase.
e.
maintenance phase.
 

9. 
During the initial stages of the implementation phase, the system enters into a cycle of
a.
coding.
b.
testing.
c.
debugging.
d.
a & c
e.
a, b & c
 

10. 
The database contents are loaded using a variety of methods and devices such as
a.
a customized user programs.
b.
a database interface programs.
c.
conversion programs that import the data from a different file structure.
d.
using batch programs, and database utility.
e.
all of the above.
 

11. 
Analyzing the company situation, defining problems and constraints, objectives and scope, and boundaries are part of the
a.
database initial study.
b.
database design.
c.
implementation and loading, testing, and evaluation.
d.
operation.
e.
maintenance and evaluation.
 

12. 
Participants in the SDLC's initial assessment must begin to study and evaluate alternate solutions, such as
a.
the technical aspects of hardware.
b.
software requirements.
c.
the system cost.
d.
a & c only
e.
a, b & c
 

13. 
In creating a logical design, the designer might use tools such as
a.
DFD.
b.
HIPO.
c.
E-R.
d.
all of the above
 

14. 
The purpose of the database initial study is to
a.
analyze the company situation.
b.
define problems and constraints.
c.
define objectives.
d.
define scope and boundaries.
e.
all of the above
 

15. 
Creating the conceptual design, DBMS software selection, creation of the logical design, and creating the physical design are part of the
a.
database initial study phase.
b.
database design phase.
c.
implementation and loading phase.
d.
testing and evaluation phase.
e.
operation phase.
 

16. 
Installing the DBMS, creating the database, and loading or converting the data are part of the
a.
database initial study phase.
b.
database design phase.
c.
implementation and loading phase.
d.
testing and evaluation phase.
e.
operation phase.
 

17. 
Testing, fine-tuning, and evaluating the database and its applications are part of the
a.
database initial study phase.
b.
database design phase.
c.
implementation and loading phase
d.
testing and evaluation phase.
e.
operation phase.
 

18. 
Producing the required information flow, introducing changes, and making enhancements are part of the
a.
database initial study phase.
b.
database design phase.
c.
implementation and loading phase.
d.
testing and evaluation phase.
e.
operation and maintenance and evaluation phases.
 

19. 
In the conceptual design the designer's efforts are focused on
a.
information needs.
b.
information users.
c.
information sources.
d.
information constitution.
e.
all of the above
 

20. 
In the conceptual design, the designer obtains answers to compile the necessary information by
a.
developing and gathering end-user data views.
b.
direct observation of the current system.
c.
interfacing with the systems design group.
d.
a & c only
e.
a, b & c
 

21. 
During the Entity-Relationship modeling process, the designer must
a.
define entities, attributes, primary keys, and foreign keys.
b.
make decisions about adding a new primary key attributes.
c.
make decisions about the treatment of multivalued attributes.
d.
none of the above
e.
all of the above
 

22. 
During the Entity-Relationship modeling process, the designer must
a.
making decisions about adding attributes to satisfy processing requirements.
b.
making decisions about the placement of foreign keys in 1:1 relationships.
c.
avoid unnecessary ternary relationships.
d.
all of the above
e.
none of the above
 

23. 
During the Entity-Relationship modeling process, the designer must
a.
draw corresponding E-R diagram.
b.
normalize the data model.
c.
make decisions about standard naming conventions.
d.
none of the above
e.
all of the above
 



 
Check Your Work     Reset Help