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

The equijoin takes its name from the comparison operator ____ used in the condition.

A) *
B) <
C) =
D) >

Correct Answer

verified

Show Answer

Question 42

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.

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

The idea of determination is unique to the database environment.

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

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

The ____________________ catalog can be described as a detailed system data dictionary that describes all objects within the database,including data about table names,the table's creator and creation date,the number of columns in each table,the data type corresponding to each column,index filenames,index creators,authorized users,and access privileges.

The logical view of the relational database is facilitated by the creation of data relationships based on a logical construct known as a(n)____________________.

RDBMSs enforce integrity rules automatically.

Another name for a composite entity is a ____ entity.

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).

The ____ relationship should be rare in any relational database design.

A foreign key must exist in both tables that have a relationship.

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

Proper data ____________________ design requires carefully defined and controlled data redundancies to function properly.

What are the characteristics of a relational table?

What is a key and why is it important in the relational model?

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

A(n)____________________ is an orderly arrangement used to logically access rows in a table.

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.

Because the relational model uses attribute values to establish relationships among tables,many database users correctly assume that the term relation refers to such relationships.