Exam 8: Structuring System Data Requirements

The purpose of the conceptual data model is to show as many rules about the meaning and interrelationships among data as possible.

A single occurrence of an entity type defines:

________ refers to the number of instances of entity B that can (or must)be associated with each instance of entity A.

A ________ is a set of two or more multivalued attributes that are logically related.

A collection of entities that share common properties or characteristics defines:

One way to handle repeating data within an entity is to separate the repeating data into another entity,called a weak entity.

What is a triggering operation? What components are included? Provide an example.

A faculty identification number can serve as an identifier.

Entity integrity means each instance of an entity type must have a unique identifier that is not null.

Briefly identify four important business rules for supertype/subtype relationships.

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

Analysts should use intelligent keys as identifiers.

What is the role of CASE in conceptual modeling? What information is placed in the CASE repository during conceptual modeling?

The primary deliverable from the conceptual data modeling step within the analysis phase is an entity-relationship diagram.

The data manipulation operation (insert,delete,or update)that initiates the operation is called a(n):

Relationships are labeled with verb phrases.

Define the following key data modeling terms: entity,attribute,relationship,degree,cardinality,and associative entity.

Referential integrity constraints are rules concerning the relationships between entity types.

An ________ is a candidate key that has been selected as the unique,identifying characteristic for an entity type.

The names of data stores on primitive-level data flow diagrams often correspond to the names of data entities in entity-relationship diagrams.