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

Short Answer

Review LaterAdd Note

Review Later

____________________ relationships can be implemented by creating a new entity in 1:M relationships with the original entities.

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

____ yields only the rows that appear in both tables.

A) INTERSECT
B) UNION
C) DIFFERENCE
D) SELECT

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

Correct Answer

verified

Show Answer

Question 23

Short Answer

Review LaterAdd Note

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.

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

Controlled ____ makes a relational database work.

The DIVIDE operation uses one single-column table (e.g.,column "a")as the divisor and one two-column table (e.g.,columns "a" and "b")as the dividend.

Tables within a database share common attributes that enable the tables to be linked together.

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

____ data can have only a true or false (yes or no) values.

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

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

In a relational model,if A determines B,C,and D,you write A = B,C,D.

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

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

A data dictionary is sometimes described as "the database designer's database" because it records the design decisions about tables and their structures.

A(n)____________________ provides a detailed description of all tables found within the user/designer-created database.

Describe the use of the UNION operator.

The order of the rows and columns is important to the DBMS.

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

DBMSs use indexes for many different purposes.