Exam 9: Data Design

Normal forms beyond 3NF exist, but they rarely are used in business-oriented systems.

The inherent efficiency of high-volume processing on larger computers is called ____________________.

Some abbreviation codes are called ____ codes because they use a specific combination of letters that are easy to remember.

Typically, a DBMS is managed by a person called a(n) ____________________, who assesses overall requirements and maintains the database for the benefit of an entire organization rather than a single department or user.

-In the accompanying figure, any field that could serve as a primary key is called a ____.

To protect stored data, users can be asked to furnish a proper user ID and password to access a file or database.

-In the accompanying figure, a ____ is a field in one table that must match a primary key value in another table in order to establish the relationship between the two tables.

Microsoft Excel uses ____________________ dates in calculations.

One type of validity check, called ____ integrity, is a set of rules that avoids data inconsistency and quality problems.

____________________ codes combine data from different item attributes, or characteristics, to build the code.

Briefly describe (including examples in your answer) at least six of the common coding methods.

List at least 6 guidelines for designing a code.

____ is a coding method used on mainframe computers and high-capacity servers.

-A(n) ____________________, such as that shown in the accompanying figure, contains a set of related records that store data about a specific entity.

A(n) ____, which is used to access stored data, allows a user to specify a task without specifying how the task will be accomplished.

Many database programs generate ____, which is a language that allows client workstations to communicate with servers and mainframe computers.

The ____________________ for DBMS design, which was introduced in the 1970s and continues to be the dominant approach for organizing, storing, and managing business data.

Any field that is not a primary key or a candidate key is called a ____ key.

A table design that does not contain repeating groups is called unnormalized. _________________________

____ describes how instances of one entity relate to instances of another entity.