Exam 8: Structuring System Data Requirements

How many types of business rules are there in conceptual data modeling?

There is/are ________ principal type(s)of packaged data model(s).

Which benefit of purchased data models provides database planning and analysis by providing a first data model,which we can use to generate specific analysis questions and concrete,not hypothetical or abstract,examples of what might be in the appropriate database?

Projects with purchased models take less time and cost more because the initial discovery steps are no longer necessary,leaving only iterative tailoring and refinement to the local situation.

Which business rule specifies that each instance of an entity type must have a unique identifier that is not null?

An entity ________ is described just once in a data model,whereas many ________ of that may be represented by data stored in the database.

Which business rule specifies the validity of attribute values?

Define unary,binary,and ternary relationships.Provide an example of each relationship.

The ________ rule specifies that each entity instance of the super-type must be a member of some subtype of the relationship.

A(n)________ is an attribute that may take on more than one value for each entity instance.

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

The ________ rule specifies that if an entity instance of the super type is a member of one subtype,it cannot simultaneously be a member of any other subtype.

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

The ________ rule specifies that an entity instance of the super type does not have to belong to any subtype.

An entity has its own identity that distinguishes it from each other entity.

What unique characteristic(s)distinguish(es)each object from other objects of the same type?

A(n)________ is an attribute whose value can be computed from related attribute values.

Each entity type in an E-R model is given a ________ because it represents a class or set,it is singular.

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

The other deliverable from conceptual data modeling is a full set of entries about data objects that will be stored in the project dictionary,repository,or data modeling software.