Exam 8: Structuring System Data Requirements

An object type is a collection of entities that share common properties or characteristics.

A recursive relationship is also known as a ________ relationship.

An entity ________ is a collection of entities that share common properties or characteristics.

Conceptual data modeling is not done in parallel with other requirements analysis and structuring steps during systems analysis.

The ________ rule specifies that an entity instance can simultaneously be a member of two (or more)subtypes.

A(n)________ is a named property or characteristic of an entity that is of interest to the organization.

________ rules are specifications that preserve the integrity of the logical data model.

The ________ of a relationship is the number of entity types that participate in that relationship.

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

A ternary relationship is a simultaneous relationship among instances of ________ entity type(s).

Naming relationships can be difficult.Describe at least three guidelines for naming relationships.

Domain definitions typically specify some (or all)of the following characteristics of attributes: data type,length,format,range,allowable values,meaning,uniqueness,and null support (whether an attribute value may or may not be null).

An entity instance (also known simply as an instance)is a single occurrence of an entity type and is described just once in a data model,whereas many instances of that entity type may be represented by data stored in the database.

A(n)________ is an attribute that has meaningful component parts.

The disjoint rule specifies that if an entity instance of the supertype is a member of one subtype,it can simultaneously be a member of any other subtype.

Operations can be classified into four types,depending on the kind of service requested by clients.

Which benefit of purchased data models refers to the fact that they are very general,covering almost all options employed by the associated functional area or industry?

A physical data model is a detailed model that captures the overall structure of organizational data that is independent of any database management system or other implementation considerations.

A relationship definition explains what action is being taken and possibly why it is important.It may be important to state who or what does the action,but it is not important to explain how the action is taken.

A unary relationship is a relationship between the instances of ________ entity type(s).