Chapter 2

Question 1

An attribute that uniquely identifies an entity and consists of a composite attribute is called a(n):

Answer 1

composite identifier.

Question 2

An entity that associates the instances of one or more entity types and contains attributes specific to the relationships is called a(n):

Answer 2

associative entity.

Question 3

The number of entity types that participate in a relationship is called the:

Answer 3

degree.

Question 4

A relationship between the instances of a single entity type is called a(n) ________ relationship.

Answer 4

unary

Question 5

A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a ________ relationship.

Answer 5

many-to-many

Question 6

A ________ specifies the number of instances of one entity that can be associated with each instance of another entity.

Answer 6

cardinality constraint

Question 7

A simultaneous relationship among the instances of three entity types is called a(n) ________ relationship.

Answer 7

ternary

Question 8

A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship.

Answer 8

mandatory one

Question 9

A value that indicates the date or time of a data value is called a(n):

Answer 9

time stamp.

Question 10

A mutually exclusive relationship is one in which:

Answer 10

an entity instance can participate in only one of several alternative relationships.