Exam 1: The Database Environment and Development Process

An enterprise resource planning system integrates all functions of the enterprise.

A knowledge base of information or facts about an enterprise is called a(n):

A database is an organized collection of ________ related data.

Reduced program maintenance is an advantage of file processing systems.

The internal schema consists of the physical schema and the enterprise data model.

An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called:

A rule that CANNOT be violated by database users is called a:

With the traditional file processing approach, each application shares data files, thus enabling much data sharing.

The systems development life cycle is the traditional methodology used to develop, maintain, and replace information systems.

Program-data dependence is caused by:

Database development projects are never done in a bottom-up fashion.

The repository is populated during the analysis phase of the systems development life cycle.

The SDLC phase in which the detailed conceptual data model is created is the ________ phase.

Older systems that often contain data of poor quality are called ________ systems.

Data from prior systems is converted to the new system during the implementation phase of the systems development life cycle.

Multitier client/server database applications contain a business logic layer.

The conceptual schema is always technology specific.

Discuss who is involved in the database development process.

The SDLC phase in which database processing programs are created is the ________ phase.

One reason for improved application development productivity with the database approach is that file design and low-level implementation details do not need to be handled by the application programmer.