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

Multiple Choice

Review LaterAdd Note

Review Later

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

A) meta dictionary
B) schema
C) data dictionary
D) system catalog

Correct Answer

verified

Show Answer

Question 22

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 23

Multiple Choice

Review LaterAdd Note

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

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

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

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

____ yields only the rows that appear in both tables.

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

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

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

Describe the use of the UNION operator.

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

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

DBMSs use indexes for many different purposes.

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

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

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

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.

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.