Exam 14: Using Relational Databases

A transitive ____ occurs when the value of a nonkey attribute determines, or predicts, the value of another nonkey attribute.

A ____ is a subset of rows in a database table that all depend on the same key.

____ techniques include storing and verifying passwords or even using physical characteristics, such as fingerprints or voice recognition, before users can view data.

A(n) ____ key is a column that is not a key in a table, but it contains an attribute that is a key in a related table.

When you combine two columns to create a compound key, you are ____ the columns.

List two examples of primary keys.

A key that is constructed from multiple columns is called a compound key or ____ key.

In many database systems, some "deleted" records are not physically removed, but they are just marked as deleted so that they will not be used to process active records.

List and explain the three normal forms.

In database management systems, a particular way of looking at a database is sometimes called a(n) ____.

In a database, the files often are called ____ because you can arrange their contents in rows and columns.

List three reasons why a primary key is important.

Depending on the software you use, you might create a query by filling in blanks in a process called ____.

In some database software packages, such as Microsoft Access, you indicate a primary key simply by selecting a column name and clicking a button that is labeled with a key icon.

A primary key should be ____________________, meaning that a value does not change during normal operation.

The basic form of the SQL statement that retrieves selected records from a table is ____.

____________________ are formed from groups of related fields.

A symbol that means "any" or "all" is known as a ____.

An ____ is an irregularity in a database's design that causes problems and inconveniences.