Exam 17: Database Design

An identifier is an attribute whose value is associated with every entity in the data model.

1:N means that more than one entity is allowed on each side of the relationship.

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

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

In an organization,a single clerk is working in the administrative department: The notation that accurately indicates this relationship is ________.

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

What are the steps involved in transforming a data model into a relational database design?

Normalized tables eliminate ________.

Entities have attributes that describe characteristics of the entity.

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?

The general goal of normalization is to construct tables such that every table has a single topic or theme.

Explain the difference between maximum and minimum cardinality.

A(n)________ notation signifies that an adviser can be related to many students and that a student can be related to many advisers.

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

________ describe the characteristics of entities.

Explain the database development process.

The N:N notation indicates that the same number of entities are present on each end of the relationship.

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

Normalization is the process of converting a poorly structured table into two or more well-structured tables.

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