Exam 13: Designing Databases

An update anomaly occurs when the same data are stored in more than one place in the database.

What is denormalization?

Each separate data entity should create its own master database table.

A ________ is a central source of data meant to be shared by many users for a variety of applications.

Within the realm of ________, there are entities and attributes.

An update anomaly occurs when the entire primary key is not known and the database cannot insert a new record.

An associative entity is used for repeating groups.

Which type of file contains all the attributes for an entity as well as a primary key and several secondary keys?

________ is a process to eliminate repeating groups found in variable-length records.

Which doesn't DBMS allow?

A master file contains information used to update master files and produce reports.

Which is incorrect about reality, data, and metadata?

What can be constructed by choosing two or more data items and combining them?

Master files contain all the information about a data entity.

Each distinct data entity may be stored on several master database tables.

Data mining is used to verify or validate patterns that humans are able to make themselves.

A deletion anomaly occurs when the entire primary key is not known and the database cannot delete a record.

A primary key is one of the data items in a record that uniquely identifies a record.

The integrity constraint that ensures that every many record in a one-to-many relationship has a matching record in the one file is called:

Secondary keys can be used to select a group of records that belong to a set.