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

Multiple Choice

Review LaterAdd Note

Review Later

Controlled ____ makes a relational database work.

A) relations
B) logic
C) chaos
D) redundancy

E) B) and C)
F) C) and D)

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

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

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

The idea of determination is unique to the database environment.

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

DBMSs use indexes for many different purposes.

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

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

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.

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

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

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

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.

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

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

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

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

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.