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 41

Short Answer

Review LaterAdd Note

Review Later

A(n) ____________________ links tables on the basis of an equality condition that compares specified columns of each table.

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

A(n) ____ is perceived as a two-dimensional structure composed of rows and columns.

A) table
B) rowset
C) attribute
D) intersection

E) B) and C)
F) A) and B)

Correct Answer

verified

Show Answer

Question 43

Short Answer

Review LaterAdd Note

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

A data dictionary contains metadata-data about data.

In the context of a database table, the statement "A ____ B" indicates that if you know the value of attribute A, you can look up the value of attribute B.

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.

The ____ constraint can be placed on a column to ensure that every row in the table has a value for that column.

A null is created when you press the Enter key or the Tab key to move to the next entry without making a prior entry of any kind.

Character data can contain any character or symbol intended for mathematical manipulation.

To be considered minimally relational, the DBMS must support the key relational operators ____, PROJECT, and JOIN.

If one department chair-a professor-can chair only one department and one department can have only one department chair, then the entities PROFESSOR and DEPARTMENT exhibit a(n) ____________________ relationship.

Referential and entity integrity are two names for the same thing.

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

A ____ is any key that uniquely identifies each row.

There is never a good reason to use null values in a database.

Describe the use of the UNION operator.

Current relational database software generally provides only a system catalog (and not a data dictionary).

What is the system catalog?

Codd's Rule of ____ states: If the system supports low-level access to the data, users must not be allowed to bypass the integrity rules of the database

The ____ relational type is the "relational model ideal."