Exam 17: Database Design

In an organization, the administrative department consists of one clerk whose sole responsibility is the management of various administrative functions.The notation that accurately indicates this relationship is ________.

To represent an N:M relationship between two entities, two normalized tables are sufficient.

A database contains a description of both the data and the relationships among the data.

The data integrity problem can occur only if data are ________.

The maximum number of entities that can be involved in a relationship is known as maximum cardinality.

Explain the database development process.

Explain the role of users in designing a database.

The crow's foot notation shows the minimum number of entities that can be involved in a relationship.

In an entity-relationship (E-R)diagram, a line is used to represent a relationship between two entities.

Which of the following is true of an entity-relationship (E-R)diagram?

The data integrity problem can occur only if data are missing.

Which of the following is a highly popular technique for creating a data model with which the developers describe the content of a database by defining what is to be stored in the database and the associations among them?

Maximum cardinality in an entity-relationship (E-R)diagram refers to the maximum number of ________.

The general goal of normalization is to ________.

Which of the following is true of a data model?

According to the kinds of problems they have, database practitioners classify tables into various ________.

Which of the following notations signifies that an adviser can be related to many students and that a student can be related to many advisers?

Which of the following is true of entities?

What are the different types of relationships represented in a data model?

A data model does not depict the relationships among the data.