Exam 14: Using Relational Databases

3NF requires that a table be in 2NF and have transitive dependencies.

Structured Query Language is a commonly used language for accessing data in database tables.

If an employee record contains both a company-assigned employee ID and a Social Security number, then both columns are ____ keys.

Connecting two tables based on the values in a common column is called a(n) ____ operation.

Some database designers insert an exclamation point after the key instead of underlining it.

____ is the unnecessary repetition of data.

____ is the process of coding data into a format that human beings cannot read.

A common reason you create a one-to-one relationship is security.

The ____ assigned to a user indicate which parts of the database the user can view, modify, or delete.

____________________ are composed of associated records.

Discuss the use of null values within a database table.