Question 1

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

Accepted Answer

The answer of If B is functionally dependent on A,...

Question 2

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.

Accepted Answer

A) True 
 B)False

Question 3

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.

Accepted Answer

The answer of In a relational database, column B is...

Question 4

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

Accepted Answer

The answer of The four categories of update anomalies are...

Question 5

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.

Accepted Answer

A) True 
 B)False

Question 6

A primary key always comprises a single column.

Accepted Answer

A) True 
 B)False

Question 7

A relationship is an association between ____________________.

Accepted Answer

The answer of A relationship is an association between ____________________....

Question 8

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

Accepted Answer

A)  tuple 
B)  row 
C)  column 
D)  entity

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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.

Accepted Answer

A) True 
 B)False

Question 11

A secondary key is the unique identifier for a table.

Accepted Answer

A) True 
 B)False

Question 12

A tabular database is a collection of tables.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

The answer of When you write a column in the...

Question 15

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

Accepted Answer

A) ORDER_NUM 
B)  PART_NUM 
C)  QUOTED_PRICE 
D)  ORDER_NUM and PART_NUM

Question 16

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.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

The answer of When you combine a column name with...

Question 19

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

Accepted Answer

A)  period (.) 
B)  comma (,) 
C)  backslash (/) 
D)  pound sign (#)

Question 20

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

Accepted Answer

A)  Qualification 
B)  Joining 
C)  Normalization 
D)  Concatenation

Exam 2: Database Design Fundamentals

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

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.

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 four categories of update anomalies are additions, deletions, inconsistent data, and ____________________.

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.

A primary key always comprises a single column.

A relationship is an association between ____________________.

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

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

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.

A secondary key is the unique identifier for a table.

A tabular database is a collection of tables.

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

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

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

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.

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

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

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

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