FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: The Relational Database Model

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Multiple Choice

Review LaterAdd Note

Review Later

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

A) bridge
B) linked
C) directive
D) associative

E) All of the above
F) C) and D)

Correct Answer

verified

Show Answer

Question 42

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 43

Short Answer

Review LaterAdd Note

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.

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

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

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

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

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

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.

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 _____ relationship should be rare in any relational database design.

The DIFFERENCE operator subtracts one table from the other.

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