Exam 14: Database Design

Vertical distribution of the data has specific columns of tables assigned to specific databases and servers.

Key integrity means that the primary key for a record must not take on a value that is outside the range of legal values.

The data manipulation language (DML) is able to specify different views of a database. Views restrict the portion of the database that may be used or accessed by different users and programs.

A descriptive field is any other non-key field that stores business data.

To facilitate searching and sorting, a(n) _________ is frequently created for keys.

The DeptID field in an employee table must match the DeptID of an existing record in the department table . This is an example of:

A(n) __________________________ is the physical implementation of a data attribute.

A record is a collection of fields arranged in a predefined format.