Exam 8: Data Modeling and Analysis

A relationship is a natural business association that exists between one or more entities.

______________________________________ is a technique for organizing and documenting a system's data.

The value that is recorded in an attribute if a user does not specify one is known as the:

The requirements analysis results in a physical data model that is developed in stages as follows: (1) normalized data model; (2) key-based data model; (3) fully attributed data model; and (4) the context data model.

If use-case narratives have been written during the requirements analysis phase, analysts can scan them for verbs to discover data attributes and entities.

An attribute is a descriptive property or characteristic of an entity.

Controls must be installed to ensure that the value of a key is valid.

__________________ codes assign numbers that have been divided into groups based on some business meaning.

The process that prepares a data model for implementation as a database is known as:

A ___________________________ is an entity whose instances store attributes that are common to one or more entity subtypes.

All relationships are implicitly _____________________________.

Many nonspecific relationships can be resolved into two one-to-many relationships using an associative entity.

An enterprise data model typically identifies and defines only the most complex entities used by the enterprise.

The context data model is prepared during the problem analysis phase and only includes entities and relationships, but no attributes.

A good data model is inflexible because it is an accurate representation of the business data requirements.

An attribute or concatenated attribute whose values divide all entity instances into useful subsets is known as:

_________________________ is a data analysis technique that organizes data attributes such that they are grouped to form nonredundant, stable, flexible, and adaptive entities.

The value of a key should not change over the lifetime of each entity instance.

The process that prepares a data model for implementation as a simple, nonredundant, flexible and adaptable database is known as:

A _______________________________________ is an attribute (or concatenated attribute) whose finite values divide all entity instances into useful subsets.