Question 1

Evaluation,maintenance,and enhancement are part of the ____ phase of the SDLC.

Accepted Answer

A)  planning 
B)  maintenance 
C)  detailed systems design 
D)  implementation

Question 2

In order to develop an accurate data ____________________,the designer must have a thorough understanding of the company's data types,extent,and uses.

Accepted Answer

The answer of In order to develop an accurate data...

Question 3

Coding,testing,and debugging are part of the ____ phase of the SDLC.

Accepted Answer

A)  planning 
B)  analysis 
C)  detailed systems design 
D)  implementation

Question 4

Installation and fine tuning are part of the ____ phase of the SDLC.

Accepted Answer

A)  planning 
B)  analysis 
C)  detailed systems design 
D)  implementation

Question 5

The database administrator must be prepared to perform routine maintenance activities within the database.

Accepted Answer

A) True 
 B)False

Question 6

Database designs that fail to recognize that the database is part of a larger information system are not likely to be successful.

Accepted Answer

A) True 
 B)False

Question 7

Systems analysis is used to determine the need for an information system and to establish its limits.

Accepted Answer

A) True 
 B)False

Question 8

What are the factors affecting the purchasing decision for DBMS software?

Accepted Answer

The answer of What are the factors affecting the purchasing...

Question 9

The testing and evaluation phase occurs after applications programming.

Accepted Answer

A) True 
 B)False

Question 10

There are ____ classical approaches to database design.

Accepted Answer

A)  two 
B)  three 
C)  four 
D)  five

Question 11

The first step in developing the conceptual model using ER diagrams is to ____.

Accepted Answer

A)  normalize the entities 
B)  complete the initial ER diagram 
C)  identify, analyze, and refine the business rules 
D)  define the attributes, primary keys, and foreign keys for each of the entities

Question 12

The first step in the ER model verification process is to ____.

Accepted Answer

A)  identify each module and its components 
B)  identify the ER model's central entity 
C)  verify all processes against the ER model 
D)  identify each module's internal transaction requirements

Question 13

The term "database development" is used to describe the process of database design and implementation.

Accepted Answer

A) True 
 B)False

Question 14

The SDLC traces the history of an information system.

Accepted Answer

A) True 
 B)False

Question 15

The company ____________________ describes the general conditions in which a company operates,its organizational structure,and its mission.

Accepted Answer

The answer of The company ____________________ describes the general conditions...

Question 16

Database performance is one of the least important factors in all database implementations.

Accepted Answer

A) True 
 B)False

Question 17

List and briefly describe the three types of system maintenance activities.

Accepted Answer

The answer of List and briefly describe the three types...

Question 18

The last step in the DBLC is ____.

Accepted Answer

A)  maintenance and evolution 
B)  operation 
C)  testing and evaluation 
D)  implementation and loading

Question 19

____ allow(s)physical access to areas by authorized personnel only.

Accepted Answer

A)  Physical security 
B)  Password security 
C)  Access rights 
D)  Data encryption

Question 20

Explain the differences between a centralized and decentralized approach to database design.

Accepted Answer

The answer of Explain the differences between a centralized and...

Exam 9: Database Design

Evaluation,maintenance,and enhancement are part of the ____ phase of the SDLC.

In order to develop an accurate data ____________________,the designer must have a thorough understanding of the company's data types,extent,and uses.

Coding,testing,and debugging are part of the ____ phase of the SDLC.

Installation and fine tuning are part of the ____ phase of the SDLC.

The database administrator must be prepared to perform routine maintenance activities within the database.

Database designs that fail to recognize that the database is part of a larger information system are not likely to be successful.

Systems analysis is used to determine the need for an information system and to establish its limits.

What are the factors affecting the purchasing decision for DBMS software?

The testing and evaluation phase occurs after applications programming.

There are ____ classical approaches to database design.

The first step in developing the conceptual model using ER diagrams is to ____.

The first step in the ER model verification process is to ____.

The term "database development" is used to describe the process of database design and implementation.

The SDLC traces the history of an information system.

The company ____________________ describes the general conditions in which a company operates,its organizational structure,and its mission.

Database performance is one of the least important factors in all database implementations.

List and briefly describe the three types of system maintenance activities.

The last step in the DBLC is ____.

____ allow(s) physical access to areas by authorized personnel only.

Explain the differences between a centralized and decentralized approach to database design.