Exam 1: The Database Environment and Development Process

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

A person is an example of an entity.

An internal schema consists of a ________ and a ________.

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

Redundancy increases the risk of inconsistent data.

Loss of metadata integrity is often a result of:

Database processing programs are coded and tested during the design stage of the systems development life cycle.

Application programs are only used with databases.

Applications built with a multitier architecture are meant to support departments.

A(n)________ is an older application based on file processing and/or older database technology.

A workgroup database is stored on a central device called a(n):

________ are persons who concentrate on determining the requirements and design for the database component of the information system.

A relatively small team of people who collaborate on the same project is called a(n):

Identifying data integrity and security details is done in the ________ phase of the SDLC.

________ is a tool even non-programmers can use to access information from a database.

The steps of the systems development life cycle can only be viewed as a linear process.

A(n)________ utilizes Internet protocols to provide limited access to company information by customers and suppliers.

E.F.Codd developed the relational model in the

A database management system is an integrated development environment.

One disadvantage of file-processing systems is that applications are often developed independently causing ________ data.