FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Relational Model Characteristics

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

True/False

Review LaterAdd Note

Review Later

The idea of determination is unique to the database environment.

A) True
B) False

Correct Answer

verified

Show Answer

Question 32

Short Answer

Review LaterAdd Note

Review Later

The index key can have multiple attributes, this is called a(n) ____________________ index.

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

The attribute B is ____ the attribute A if each value in column A determines one and only one value in column B.

Since it is used to link the tables that originally were related in a M:N relationship, the composite entity structure includes-as foreign keys-at least the ____ keys of the tables that are to be linked.

In a database context, the word ____ indicates the use of the same attribute name to label different attributes.

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

DBMSs use indexes for many different purposes.

No data entry at all is known as a(n) ____.

A CUSTOMER table's primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and all entries are unique. This is an example of ____ integrity.

Controlled ____ makes a relational database work.

A(n) ____ is an ordered arrangement of keys and pointers.

The relational model's creator, E. F. Codd, used the term relation as a synonym for ____.

PRODUCT yields all possible pairs of rows from two tables-also known as the ____________________ product.

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

Tables must have the same attribute characteristics (the columns and domains must be compatible) to be used in a UNION.

The practical significance of taking the logical view of a database is that it serves as a reminder of the simple file concept of data storage.

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

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

____ logic, used extensively in mathematics, provides a framework in which an assertion (statement of fact) can be verified as either true or false.

Date attributes contain calendar dates stored in a special format known as the ____ date format.