week 4

A(n) ____ entity is composed of the primary keys of each of the entities to be connected. a. associative b. binary c. recursive d. unary

a. associative

A ____ identifier is composed of more than one attribute. a. composite b. foreign c. domain d. primary

a. composite

An entity is said to be ____-dependent if it can exist in the database only when it is associated with another related entity occurrence. a. existence b. business c. weak d. relationship

a. existence

A ____ relationship exists when an association is maintained within a single entity. a. unary b. ternary c. binary d. weak

a. unary

A ____ relationship exists when two entities are associated. a. unary b. binary c. weak d. ternary

b. binary

A ____ attribute can be further subdivided to yield additional attributes. a. multivalued b. composite c. simple d. single-valued

b. composite

When the PK of one entity does not contain the PK of a related entity, the relationship is ____. a. neutral b. weak c. missing d. strong

b. weak

The step, ____, occurs first in the process of building an ERD. a. Identify the attributes and primary keys that adequately describe the entities. b. Identify the business rules based on the description of operations. c. Create a detailed narrative of the organization's description of operations. d Develop the initial ERD.

c. Create a detailed narrative of the organization's description of operations.

If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ____ relationship. a. looping b. self c. recursive d. self-referring

c. recursive

A relationship is an association between ____. a. databases b. fields c. objects d. entities

d. entities