Chapter 3

Each table in a relational database must have a primary key.

• True

• False

Referential and entity integrity are two names for the same thing.

• True

• False

A data dictionary contains metadata-data about data.

• True

• False

Character data can contain any character or symbol intended for mathematical manipulation.

• True

• False

As rare as 1:1 relationships should be, certain conditions absolutely require their use.

• True

• False

Only a single attribute, not multiple attributes, can define functional dependence.

• True

• False

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.

• True

• False

Another name for a composite entity is a ____ entity.

• bridge

• 
  linked

• 
  directive

• referring

In a natural join, the column on which the join was made occurs twice in the new table.

• True

• False

The result set of computing the Product of the following two tables will be:

• 
• 
• 
•