Chapter 4: DB 2

weak

A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.

person's age

A ____ should be a derived attribute.

associative

A(n) ____ entity is composed of the primary keys of each of the entities to be connected.

strong

Another word for existence-independent is ____.

recu

If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ____ relationship.

(min, max)

In the ERD, cardinality is indicated using the ____ notation.

(1:1)

The Crow's foot symbol with two parallel lines indicates ____ cardinality.

mandatory

The existence of a(n) ____ relationship indicates that the minimum cardinality is at least 1 for the mandatory entity.

optionality

The term "____" is used to label any condition in which one or more optional relationships exist.

weak

When the PK of one entity does not contain the PK of a related entity, the relationship is ____.