Exam 8: Data Modeling and Analysis

Example data types include: numbers, text, memo, date, time, yes/no, Boolean, value set, or image.

A ternary relationship is:

A(n) _____________________________ is a natural business association that exists between one or more entities.

When a nonkey attribute is dependent on another nonkey attribute (other than by derivation) is known as:

An attribute whose value can be calculated from other attributes is called a(n):

Significant position codes are frequently used to code inventory items.

The three properties of an attribute are: ___________________________, _______________________, and _____________________________.

The data model for a single information system is usually called:

A(n) ________________________ is a piece of data that we want to store about each instance of a given entity.

A code that uses blocks of numbers that are divided into groups that have some business meaning is known as a:

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

Which of the following is a criteria for making a good data model?

Any candidate key that is not selected to become the primary key is called:

An entity is in first normal form (1NF) if there are no attributes that can have more than one value for a single instance of the entity.

An entity that inherits its primary key from more than one entity is called a(n):

Categories of _______________________ include: persons, places, objects, events or concepts.

A data type:

Which normal form deals with repeating attributes?

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

A(n) _____________________________ relationship is one between three different entities.