Exam 5: Database Processing

What are application programs and what are their functions?

Which of the following is a nonrelational data store developed by Google?

An organization buys a proprietary database application to be used by a small workgroup of five people.This is an example of a(n)________ DBMS.

Which of the following is the smallest data element in a database?

In an E-R diagram, a(n)________ on a line means that at least one entity type of that type is required.

Users are the final judges as to what data the database should contain and how the records in that database should be related to one another.

Columns that belong to a different table than the one in which they reside are called ________.

Identify the type of task that a database administrator is performing when validating the data model to be used in a database management system.

Explain the role of users in the database development process.

Identify the first step in transforming a data model into a relational database design.

Which of the following is an example of an enterprise DBMS?

Entities in a data model have ________ that describe the characteristics of the entity.

One of the developmental tasks of a database administrator is to create a system to record and manage the resolution of problems.

Define Primary Key, foreign key, and metadata.

Normalized tables are faster to process than denormalized tables.

Managing the impact of database structure changes on applications and users is an operational task for a database administrator.

One of the functions of a DBMS is to provide tools to assist in the administration of the database.

1:N, N:M, and 1:1 are common examples of minimum cardinalities.

Each entity in a database has a unique attribute called a(n)________.

The rows in a database need to have two or more primary keys.