Question 1

Any row that determines another row is called a determinant.

Accepted Answer

A) True 
 B)False

Question 2

An interrelation ____________________ is a condition that involves two or more relations.

Accepted Answer

The answer of An interrelation ____________________ is a condition that...

Question 3

What is a table that contains a repeating group called?

Accepted Answer

A)  normalized relation 
B)  unnormalized relation 
C)  nominal relation 
D)  non-nominal relation 
A)  normalized relation 
B)  unnormalized relation 
C)  nominal relation 
D)  non-nominal relation

Question 4

What is an alternate key?

Accepted Answer

A)  foreign key 
B)  primary key 
C)  column that could be a primary key but was not chosen 
D)  row that could be a primary key but was not chosen 
A)  foreign key 
B)  primary key 
C)  column that could be a primary key but was not chosen 
D)  row that could be a primary key but was not chosen

Question 5

Which of the following is a column or collection of columns on which all columns in the table are functionally dependent?

Accepted Answer

A)  index key 
B)  candidate key 
C)  major key 
D)  special key 
A)  index key 
B)  candidate key 
C)  major key 
D)  special key

Question 6

When you normalize a table by breaking down the relations into progressively finer levels of detail, it is called?_____________________.

Accepted Answer

The answer of When you normalize a table by breaking...

Question 7

Discuss how candidate keys, primary key, and alternate keys are related.

Accepted Answer

Similar to a primary key, a candidate ke

Question 8

Which normal form has an additional condition that the only determinants the table contains are candidate keys?

Accepted Answer

A)  First 
B)  Second 
C)  Third 
D)  Fourth 
A)  First 
B)  Second 
C)  Third 
D)  Fourth

Question 9

When is a 1NF table automatically a 2NF table?

Accepted Answer

A)  when two or more columns make up the primary key 
B)  when there are no interrelation constraints 
C)  when there are only nonkey columns 
D)  when the primary key contains only a single column 
A)  when two or more columns make up the primary key 
B)  when there are no interrelation constraints 
C)  when there are only nonkey columns 
D)  when the primary key contains only a single column

Question 10

A column is a nonkey column when it is part of the primary key.

Accepted Answer

A) True 
 B)False

Question 11

The normalization process is a series of steps that will automatically restructure your database to resolve design flaws.

Accepted Answer

A) True 
 B)False

Question 12

Tables without repeating groups are said to be in first normal form.

Accepted Answer

A) True 
 B)False

Question 13

What is a nonkey column?

Accepted Answer

A)  A column that is not part of the primary key. 
B)  A column that has a null value. 
C)  A column that is part of a repeating group. 
D)  A column that contains a numeric value. 
A)  A column that is not part of the primary key. 
B)  A column that has a null value. 
C)  A column that is part of a repeating group. 
D)  A column that contains a numeric value.

Question 14

What do you call a data inconsistency that results from data redundancy or the use of inappropriate nulls?

Accepted Answer

A)  update anomaly 
B)  insertion anomaly 
C)  deletion anomaly 
D)  relational anomaly 
A)  update anomaly 
B)  insertion anomaly 
C)  deletion anomaly 
D)  relational anomaly

Question 15

What is a potential problem, if any, if you design a database in which the last name of a consultant functionally determines the consultant's address?

Accepted Answer

A)  There is no problem with this design. 
B)  There could be two consultants living at the same address. 
C)  There could be more than one consultant with the same last name. 
D)  The address will automatically functionally determine the consultant's last name. 
A)  There is no problem with this design. 
B)  There could be two consultants living at the same address. 
C)  There could be more than one consultant with the same last name. 
D)  The address will automatically functionally determine the consultant's last name.

Question 16

What type of diagram uses arrows to indicate all the functional dependencies present in a table?

Accepted Answer

A)  interrelation diagram 
B)  functional diagram 
C)  dependency diagram 
D)  index diagram 
A)  interrelation diagram 
B)  functional diagram 
C)  dependency diagram 
D)  index diagram

Question 17

An interrelation constraint is a condition that involves two or more relations.

Accepted Answer

A) True 
 B)False

Question 18

If there is more than one possible choice for the primary key, and one of the possibilities is chosen to be the primary key. What are the others called?

Accepted Answer

A)  canceled keys 
B)  alternate keys 
C)  nonkey attributes 
D)  contributory keys 
A)  canceled keys 
B)  alternate keys 
C)  nonkey attributes 
D)  contributory keys

Question 19

A table that contains a ________________ that is not a candidate key indicates the table is not in third normal form.

Accepted Answer

The answer of A table that contains a ________________ that...

Question 20

The ____________________ process enables you to identify the existence of potential problems in the design of a database.

Accepted Answer

The answer of The ____________________ process enables you to identify...

Any row that determines another row is called a determinant.

An interrelation ____________________ is a condition that involves two or more relations.

What is a table that contains a repeating group called?

What is an alternate key?

Which of the following is a column or collection of columns on which all columns in the table are functionally dependent?

When you normalize a table by breaking down the relations into progressively finer levels of detail, it is called?_____________________.

Discuss how candidate keys, primary key, and alternate keys are related.

Which normal form has an additional condition that the only determinants the table contains are candidate keys?

When is a 1NF table automatically a 2NF table?

A column is a nonkey column when it is part of the primary key.

The normalization process is a series of steps that will automatically restructure your database to resolve design flaws.

Tables without repeating groups are said to be in first normal form.

What is a nonkey column?

What do you call a data inconsistency that results from data redundancy or the use of inappropriate nulls?

What is a potential problem, if any, if you design a database in which the last name of a consultant functionally determines the consultant's address?

What type of diagram uses arrows to indicate all the functional dependencies present in a table?

An interrelation constraint is a condition that involves two or more relations.

If there is more than one possible choice for the primary key, and one of the possibilities is chosen to be the primary key. What are the others called?

A table that contains a ________________ that is not a candidate key indicates the table is not in third normal form.

The ____________________ process enables you to identify the existence of potential problems in the design of a database.

Introduction to Database Management

The Relational Model 1: Introduction, QBE, and Relational Algebra

The Relational Model 2: SQL

The Relational Model 3: Advanced Topics

Database Design 2: Design Method

Dbms Functions

Database Administration

Database Management Approaches

Filters

Exam 5: Database Design 1: Normalization

Any row that determines another row is called a determinant.

An interrelation ____________________ is a condition that involves two or more relations.

What is a table that contains a repeating group called?

What is an alternate key?

Which of the following is a column or collection of columns on which all columns in the table are functionally dependent?

When you normalize a table by breaking down the relations into progressively finer levels of detail, it is called?_____________________.

Discuss how candidate keys, primary key, and alternate keys are related.

Which normal form has an additional condition that the only determinants the table contains are candidate keys?

When is a 1NF table automatically a 2NF table?

A column is a nonkey column when it is part of the primary key.

The normalization process is a series of steps that will automatically restructure your database to resolve design flaws.

Tables without repeating groups are said to be in first normal form.

What is a nonkey column?

What do you call a data inconsistency that results from data redundancy or the use of inappropriate nulls?

What is a potential problem, if any, if you design a database in which the last name of a consultant functionally determines the consultant's address?

What type of diagram uses arrows to indicate all the functional dependencies present in a table?

An interrelation constraint is a condition that involves two or more relations.

If there is more than one possible choice for the primary key, and one of the possibilities is chosen to be the primary key. What are the others called?

A table that contains a ________________ that is not a candidate key indicates the table is not in third normal form.

The ____________________ process enables you to identify the existence of potential problems in the design of a database.

Introduction to Database Management

The Relational Model 1: Introduction, QBE, and Relational Algebra

The Relational Model 2: SQL

The Relational Model 3: Advanced Topics

Database Design 2: Design Method

Dbms Functions

Database Administration

Database Management Approaches

Filters