Exam 8: Data Modeling and Analysis

____________________________ is a process that prepares a data model for implementation as a simple, nonredundant, flexible and adaptable database.

A non-specific relationship is one in which many instances of one entity are associated with many instances of another entity.

A data-to-location CRUD matrix is a table in which garbage values that fall outside the domain of an attribute are identified and used for data verification.

During the requirements phase, the physical data model is transformed into the logical data model.

A ___________________________ is an entity whose instances inherit some common attributes from an entity supertype and then add other attributes that are unique to its instance.

Every student resides in 0 or 1 dorm. This is an example of:A) domain

In significant position codes, each digit or group of digits describes a measurable or identifiable characteristic of the entity instance.

Data analysis is a process that prepares a logical model for implementation as a redundant, explicit, and finite database through a technique called generalization.

What defines the minimum and maximum number of occurrences of one entity that may be related to a single occurrence of the other entity?

Which of the following is NOT a guideline for creating a business coding scheme?

An entity supertype is an entity whose instances inherit some common attributes from an entity subtype and then add other attributes that are unique to an instance of the supertype.

An entity is something about which the business needs to store data.

Nonidentifying relationships are those in which each of the participating entities has dependent primary keys.

Identifying relationships are those in which the parent entity contributes its primary key to become part of the primary key of the child entity.

A(n) _________________________ is something that the business needs to store data.

The ___________________________ defines what values an attribute can legitimately take.

An entity is in first normal form (1NF) if the values of its nonprimary key attributes are not dependent on any other nonprimary key attributes.

A table in which rows indicate entities (and possible attributes) and the columns indicate locations, and the cells indicate the document level of access including create, read, update or delete is known as:

A key is an attribute, or group of attributes, that assumes a unique value for each entity instance. It is sometimes called an identifier.

Which normal form deals with transitive dependencies?