Exam 14: Using Relational Databases

Database software provides the means to ensure that data integrity is enforced.

To ____ a table is to reduce it to a lower normal form by placing some repeated information back into the table.

A database has ____ when it follows a set of rules that makes the data accurate and consistent.

A ____ relationship is the most common type of relationship between tables.

Normalization involves altering a table so that it satisfies one or more of four normal forms, or sets of rules for constructing a well-designed database.

A(n) ____________________ is a long-term database lock required when users want to maintain a consistent view of their data while making modifications over a long transaction.

Discuss a shorthand way to describe a table.

Discuss how to create databases and design tables.

List the three types of relationships that can exist between tables.

List four major issues with database performance and security.

Entering data into an existing table is not difficult, but it requires a good deal of time and accurate typing.

A table that contains repeating groups is ____.

Discuss how to sort the records in a table.

When a field in a database contains a null value, it means that ____.

After you choose a primary key from among candidate keys, the remaining candidate keys become ____ keys.

Database developers also refer to operations or transactions as ____ transactions when they appear to execute completely or not at all.

A ____________________ is a binary large object, which is a collection of binary data such as an image, video, or audio clip stored in a database system.

Discuss the issue of recovering lost data.

Database software recognizes the distinction between text and numeric data.

A ____ is a mechanism that prevents changes to a database for a period of time.