FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Database Design Fundamentals

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

In an entity-relationship (E-R) diagram, one-to-many relationships between entitities are drawn as ____.

A) ovals
B) equal signs
C) lines
D) circles

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

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

A secondary key is the unique identifier for a table.

A) True
B) False

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

You can indicate a table's primary key by underlining the column or collection of columns that comprises the primary key for each table in the database.

A programmer interviews users, examines existing and proposed documents, and examines organizational policies to determine exactly the type of data needs the database must support.

The four categories of update anomalies are additions, deletions, inconsistent data, and ____________________.

When you write a column in the format CUSTOMER.REP_NUM, you say that you ____________________ the column name.

A field is another term for a(n) ____.

A relationship is an association between ____________________.

Because there is a one-to-many relationship between sales reps and customers in the Premiere Products database, one sales rep can be associated with zero, one, or more customers.

Which of the following symbols is used to qualify column names?

A primary key always comprises a single column.

A tabular database is a collection of tables.

When you combine a column name with a table name, you are said to ____________________ the column name.

If B is functionally dependent on A, you also can say that A functionally ____________________ B.

In a relational database, column B is ____________________ on another column A, if at any point in time a value for A determines a single value for B.

The statement "A sales rep's pay class functionally determines his or her pay rate" means that if you know the pay class, you can determine the pay rate.

____ is the formal term for combining two or more columns to form a primary key.

In a relational database, relationships are implemented by having common columns in two or more tables.

Which of the following is the primary key of the ORDER_LINE (ORDER_NUM, PART_NUM, NUM_ORDERED, QUOTED_PRICE) table?

An unnormalized relation is a relation that may contain repeating groups.