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 21

Multiple Choice

Review LaterAdd Note

Review Later

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

A) database tuple
B) systematic database
C) unique index
D) system catalog

Correct Answer

verified

Show Answer

Question 22

Essay

Review LaterAdd Note

Review Later

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

Correct Answer

verified

An index is an orderly arrangement used ...

View Answer

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

are especially useful when you are trying to determine what values in related tables cause referential integrity problems.

returns only the attributes requested, in the order in which they are requested.

The SELECT operator yields a vertical subset of a table.

If the attribute (B) is functionally dependent on a composite key (A) but not on any subset of that composite key, the attribute (B) is fully functionally dependent on (A).

Dr. Codd's rule of relational database states that every value in a table is guaranteed to be accessible through a combination of table name, primary key value, and column name.

The relationship is the "relational model ideal."

What is a key and how is it important in a relational model?

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

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

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

According to Codd's rule of relational database, "If the system supports low-level access to the data, users must not be allowed to bypass the integrity rules of the database."

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

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

In a database context, a(n) indicates the use of different names to describe the same attribute.

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

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

RDBMSs enforce integrity rules automatically.

Describe the use of the INTERSECT operator.