Exam 5: Database Processing

In data models, physical objects are represented as entities, whereas logical constructs and transactions are represented as attributes.

The crow's-foot notation in an E-R diagram shows the maximum number of entities that can be involved in a relationship.

________ in an E-R diagram refer to the least number of entities required in a relationship.

In the case of single-user databases, the application, the DBMS, and the database all reside on the user's computer.

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

Metadata refers to entities of a database that users want to process.

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

In a database, when data items disagree with one another, it leads to a(n) ________.

A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.

Each table in a database must have two or more primary keys.

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

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

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

A database management system (DBMS) is a program used to create, process, and administer a database.

A many-to-many (N:M) relationship means that more than one entity is allowed on each side of the relationship and that the number of entities on each side can be different.

Which of the following formations on a line in an E-R diagram means that the relationship need not have an entity of that type?

Which of the following is an example of a database management system?

Constraints on the number of entities in a relationship are called ________ cardinalities.

Which of the following is a developmental task of database administration?

A database is a self-describing collection of integrated records.