Exam 4: Relational Model Characteristics

If the foreign key contains either matching values or nulls, the table that makes use of that foreign key is said to exhibit ____________________ integrity

____ yields only the rows that appear in both tables.

Fortunately, the problems inherent in the ____________________ relationship can easily be avoided by creating a composite entity.

____________________ relationships cannot be implemented as such in the relational model.

The ____________________ catalog can be described as a detailed system data dictionary that describes all objects within the database, including data about table names, the table's creator and creation date, the number of columns in each table, the data type corresponding to each column, index filenames, index creators, authorized users, and access privileges.

In a relational table, each column has a specific range of values known as the ____________________ domain.

A(n) ____ join only returns matched records from the tables that are being joined.

A(n) ____________________ index is an index in which the index key can have only one pointer value (row) associated with it.

Another name for a composite entity is a ____ entity.

Because the relational model uses attribute values to establish relationships among tables, many database users correctly assume that the term relation refers to such relationships.

You can think of a table as a persistent representation of a logical relation.

The DIFFERENCE operator subtracts one table from the other.

____, also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition.

____________________ is the real power behind the relational database, allowing the use of independent tables linked by common attributes.

Numeric data are data on which you can perform meaningful arithmetic procedures.

A(n) ____ join links tables by selecting only the rows with common values in their common attribute(s).

A(n) ____________________ is an orderly arrangement used to logically access rows in a table.

All primary key entries are unique, and no part of a primary key may be ____.

A left outer join on tables CUSTOMER and AGENT yields all of the rows in the CUSTOMER table, including those that do not have a matching value in the AGENT table.

A data dictionary is sometimes described as "the database designer's database" because it records the design decisions about tables and their structures.