Exam 3: The Relational Database Model

One characteristic of generalization hierarchies is that they are implemented as _____ relationships.

An index key can have multiple _____ (a composite index).

A _____ is the primary key of one table that has been placed into another table to create a common attribute.

The proper use of _____ keys is crucial to controlling data redundancy.

The _____ is actually a system-created database whose tables store the user/designer-created database characteristics and contents.

In the relational model, _____ are important because they are used to ensure that each row in a table is uniquely identifiable.

Define an index. Explain the role of indexes in a relational database.

In a relational model, _____ are used to establish relationships among tables and to ensure the integrity of the data.

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

The DIFFERENCE operator subtracts one table from the other.

The _____ relationship should be rare in any relational database design.

A _____ key is defined as a key that is used strictly for data retrieval purposes.

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

The one-to-many (1:M) relationship is easily implemented in the relational model by putting the foreign key of the "1" side in the table of the "many" side as a primary key.

Another name for a composite entity is a(n) _____ entity.