Question 1

The fact that column B is functionally dependent on column A can be written as ____.​

Accepted Answer

A)   ​A ® B
B)   ​B ® A
C)   ​A ® ® B
D)   ​B ® ® A A

Question 2

The most recent definition of third normal form is referred to as the Boyce-Codd normal form.​

Accepted Answer

A) True 
 B)False  True

Question 3

By splitting relations to achieve third normal form tables,you create the need to express interrelation constraints.​

Accepted Answer

A) True 
 B)False  True

Question 4

The definition for ____ also defines a candidate key.​

Accepted Answer

A)   ​functional key
B)   ​repeating group
C)   ​primary key
D)   ​nonkey column

Question 5

The primary key in a table will be a determinant.​

Accepted Answer

A) True 
 B)False

Question 6

The ____ is a column (or collection of columns)A such that all other columns are functionally dependent on A and no subcollection of the columns in A has this property.​

Accepted Answer

A)   ​functional key
B)   composite key​
C)   ​primary key
D)   ​declared key

Question 7

Any column or collection of columns that determines another column is called a(n)​

Accepted Answer

The answer of Any column or collection of columns that...

Question 8

The conversion of an unnormalized table to first normal form requires the removal of ____.​

Accepted Answer

A)   ​determinants
B)   ​interrelation constraints
C)   ​nonkey columns
D)   ​repeating groups

Question 9

By converting a given collection of tables to an equivalent third normal form collection of tables,you remove any problems arising from ____________________ dependencies.​

Accepted Answer

The answer of By converting a given collection of tables...

Question 10

Second normal form can be defined as a table that is in first normal form but that contains no ____.​

Accepted Answer

A)   ​partial dependencies
B)   ​alternate keys
C)   ​nonkey columns
D)   ​interrelation constraints

Question 11

____ 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

Question 12

Explain what normalization is,including the goal of normalization.​

Accepted Answer

The answer of Explain what normalization is,including the goal of...

Question 13

Potential problems in the design of a relational database are known as ____.​

Accepted Answer

A)   ​update anomalies
B)   ​select anomalies
C)   ​modification anomalies
D)   ​relational anomalies

Question 14

What is the difference between a table in first normal form and one in second normal form?​

Accepted Answer

The answer of What is the difference between a table...

Question 15

​A table that contains a repeating group is called a(n)____.

Accepted Answer

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

Question 16

Tables that are in second normal form do not contain problems.​

Accepted Answer

A) True 
 B)False

Question 17

​The normalization process used to convert a relation or collection of relations to an equivalent collection of third normal form tables is a crucial part of the database design process.

Accepted Answer

A) True 
 B)False

Question 18

Which of the followingcontains a repeating group?​

Accepted Answer

A)   ​Orders (OrderNum, OrderDate, (ItemNum, NumOrdered)  ) 
B)   ​Orders (OrderNum, OrderDate, ItemNum, NumOrdered ) 
C)   ​Orders (OrderNum, OrderDate) 
D)   ​Orders (OrderNum, ItemNum, NumOrdered )

Question 19

If B (an attribute)is functionally dependent on A,we can also say that ____.​

Accepted Answer

A)   ​A functionally determines B
B)   ​A functionally determines another attribute in the table
C)   ​B functionally determines A
D)   ​B does not determine any other attribute

Question 20

An alternate key is a ____.​

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

Exam 5: Database Design 1: Normalization

The fact that column B is functionally dependent on column A can be written as ____.

The most recent definition of third normal form is referred to as the Boyce-Codd normal form.

By splitting relations to achieve third normal form tables,you create the need to express interrelation constraints.

The definition for ____ also defines a candidate key.

The primary key in a table will be a determinant.

The ____ is a column (or collection of columns) A such that all other columns are functionally dependent on A and no subcollection of the columns in A has this property.

Any column or collection of columns that determines another column is called a(n)

The conversion of an unnormalized table to first normal form requires the removal of ____.

By converting a given collection of tables to an equivalent third normal form collection of tables,you remove any problems arising from ____________________ dependencies.

Second normal form can be defined as a table that is in first normal form but that contains no ____.

____ normal form has an additional condition that the only determinants the table contains are candidate keys.

Explain what normalization is,including the goal of normalization.

Potential problems in the design of a relational database are known as ____.

What is the difference between a table in first normal form and one in second normal form?

A table that contains a repeating group is called a(n) ____.

Tables that are in second normal form do not contain problems.

The normalization process used to convert a relation or collection of relations to an equivalent collection of third normal form tables is a crucial part of the database design process.

Which of the followingcontains a repeating group?

If B (an attribute) is functionally dependent on A,we can also say that ____.

An alternate key is a ____.

Exam 5: Database Design 1: Normalization

The fact that column B is functionally dependent on column A can be written as ____.​

The most recent definition of third normal form is referred to as the Boyce-Codd normal form.​

By splitting relations to achieve third normal form tables,you create the need to express interrelation constraints.​

The definition for ____ also defines a candidate key.​

The primary key in a table will be a determinant.​

The ____ is a column (or collection of columns) A such that all other columns are functionally dependent on A and no subcollection of the columns in A has this property.​

Any column or collection of columns that determines another column is called a(n)​

The conversion of an unnormalized table to first normal form requires the removal of ____.​

By converting a given collection of tables to an equivalent third normal form collection of tables,you remove any problems arising from ____________________ dependencies.​

Second normal form can be defined as a table that is in first normal form but that contains no ____.​

____ normal form has an additional condition that the only determinants the table contains are candidate keys.​

Explain what normalization is,including the goal of normalization.​

Potential problems in the design of a relational database are known as ____.​

What is the difference between a table in first normal form and one in second normal form?​

​A table that contains a repeating group is called a(n) ____.

Tables that are in second normal form do not contain problems.​

​The normalization process used to convert a relation or collection of relations to an equivalent collection of third normal form tables is a crucial part of the database design process.

Which of the followingcontains a repeating group?​

If B (an attribute) is functionally dependent on A,we can also say that ____.​

An alternate key is a ____.​

The fact that column B is functionally dependent on column A can be written as ____.

The most recent definition of third normal form is referred to as the Boyce-Codd normal form.

By splitting relations to achieve third normal form tables,you create the need to express interrelation constraints.

The definition for ____ also defines a candidate key.

The primary key in a table will be a determinant.

The ____ is a column (or collection of columns) A such that all other columns are functionally dependent on A and no subcollection of the columns in A has this property.

Any column or collection of columns that determines another column is called a(n)

The conversion of an unnormalized table to first normal form requires the removal of ____.

By converting a given collection of tables to an equivalent third normal form collection of tables,you remove any problems arising from ____________________ dependencies.

Second normal form can be defined as a table that is in first normal form but that contains no ____.

____ normal form has an additional condition that the only determinants the table contains are candidate keys.

Explain what normalization is,including the goal of normalization.

Potential problems in the design of a relational database are known as ____.

What is the difference between a table in first normal form and one in second normal form?

A table that contains a repeating group is called a(n) ____.

Tables that are in second normal form do not contain problems.

The normalization process used to convert a relation or collection of relations to an equivalent collection of third normal form tables is a crucial part of the database design process.

Which of the followingcontains a repeating group?

If B (an attribute) is functionally dependent on A,we can also say that ____.

An alternate key is a ____.