Exam 8: Structuring System Data Requirements

Domains are constraints on valid values for attributes.

An attribute (or combination of attributes)that uniquely identifies each instance of an entity type defines:

An entity instance is a single occurrence of an entity type.

A ternary relationship is the equivalent of three binary relationships.

If STUDENT and COURSE participate in a relationship,their relationship is a(n):

For each entity,the name of the identifier is:

A concise statement of the business rule to be enforced by the triggering operation refers to:

The minimum cardinality of a relationship is the minimum number of instances of entity B that may be associated with each instance of entity A.

A named property or characteristic of an entity that is of interest to the organization defines:

Which of the following specifies that an entity instance of the supertype is allowed not to belong to any subtype?

The primary deliverable from the conceptual modeling step within the analysis phase is a(n):

A relationship that the data modeler chooses to model as an entity type best defines:

A ________ is a generic entity type that has a relationship with one or more subtypes.

Universal data models and industry-specific data models are two types of packaged conceptual data models.

A join is an association between the instances of one or more entity types that is of interest to the organization.

Business rules are specifications that preserve the integrity of the physical data model.

Book,supplier,and state are entity types.

The condition that causes the operation to be triggered:

Referencing an employee entity,an employee's skills are a multivalued attribute.

A subgrouping of the entities in an entity type that is meaningful to the organization and that shares common attributes or relationships distinct from other subgroupings best defines: