Exam 8: Data Modeling and Analysis

A code that provides a top-down interpretation for an entity instance is known as:

Data modeling is sometimes called __________________________________ because a data model is usually implemented as a database.

An alternate key is also known as a secondary key.

_______________________________ is an approach that seeks to discover and exploit the commonalties between entities.

The data type of an attribute defines what type of data can be stored in that attribute.

An intelligent key is a business code whose structure communicates data about an entity instance (such as its classification, size or other properties).

The data model is metadata - that is, it is data about data.

An entity whose instances store attributes that are common to one or more entities is a(n):

A(n) ________________________________ relationship is where many instances of one entity are associated with many instances of another entity.

A relationship where many instances of one entity can be associated with many instances of another entity is known as:

_________________________ is data about the business's data.

Some experts suggest that you avoid the use of intelligent keys when designing your data model. They argue that because characteristics can change it violates the rule that the value of a key should not change over the lifetime of each entity instance.

A compound attribute is an attribute that will be expanded into a separate entity.

Generalization is a technique wherein the domains common to several types of attributes are grouped into their own entity, called an associate entity.

The entity on the "many" side of a one-to-many relationship is called the _____________.

Many organizations have naming standards and approved abbreviations for data attributes.

Another name for the logical data model is the database schema.

The domain of an attribute defines what values an attribute can legitimately take on.

A(n) ________________________________ entity is an entity that inherits its primary key from more than one other entity (parents). Each part of that concatenated key points to one and only one instance of each of the connecting entities.

A(n) _____________________________ relationship is the most common type, where two entities participate.