Question 1

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 
A)  partial dependencies 
B)  alternate keys 
C)  nonkey columns 
D)  interrelation constraints

Question 2

If you convert a collection of tables to an equivalent third normal form collection of tables, what problems do you remove?

Accepted Answer

A)  those arising from multivalued dependencies 
B)  those arising from functional dependencies 
C)  those arising from inappropriate null values 
D)  those arising from incomplete deletions 
A)  those arising from multivalued dependencies 
B)  those arising from functional dependencies 
C)  those arising from inappropriate null values 
D)  those arising from incomplete deletions

Question 3

Which of the following is a characteristic of a table that is in first normal form?

Accepted Answer

A)  It doesn't contain repeating groups. 
B)  It has at least two foreign keys. 
C)  It doesn't have a primary key 
D)  There are no alternate keys. 
A)  It doesn't contain repeating groups. 
B)  It has at least two foreign keys. 
C)  It doesn't have a primary key 
D)  There are no alternate keys.

Question 4

A(n) ________________ key is a candidate key not chosen ad the primary key.

Accepted Answer

The answer of A(n) ________________ key is a candidate key...

Question 5

To correct anomalies in a database, tables must be converted into various types of normal forms.

Accepted Answer

A) True 
 B)False

Question 6

If the primary key of a table contains only a single column, the table is automatically in third normal form.

Accepted Answer

A) True 
 B)False

Question 7

A table is in fourth normal form when it is in third normal form and there are no ________________ dependencies.

Accepted Answer

The answer of A table is in fourth normal form...

Question 8

Converting to third normal form always avoids the problems related to dependencies.

Accepted Answer

A) True 
 B)False

Question 9

A column B is ____________________ on another column A if each value for A in the database is associated with exactly one value of B.

Accepted Answer

functional

Question 10

With the table Orders (OrderNum, OrderDate, (ItemNum, NumOrdered) ) where OrderNum is the primary key, how would you convert the table to first normal form?

Accepted Answer

A)  by creating a second table with just the columns ItemNum and NumOrdered 
B)  by changing the primary key to OrderDate 
C)  by making ItemNum a foreign key 
D)  by making the primary key a combination of OrderNum and ItemNum 
A)  by creating a second table with just the columns ItemNum and NumOrdered 
B)  by changing the primary key to OrderDate 
C)  by making ItemNum a foreign key 
D)  by making the primary key a combination of OrderNum and ItemNum

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

If you convert a collection of tables to an equivalent third normal form collection of tables, what problems do you remove?

Which of the following is a characteristic of a table that is in first normal form?

A(n) ________________ key is a candidate key not chosen ad the primary key.

To correct anomalies in a database, tables must be converted into various types of normal forms.

If the primary key of a table contains only a single column, the table is automatically in third normal form.

A table is in fourth normal form when it is in third normal form and there are no ________________ dependencies.

Converting to third normal form always avoids the problems related to dependencies.

A column B is ____________________ on another column A if each value for A in the database is associated with exactly one value of B.

With the table Orders (OrderNum, OrderDate, (ItemNum, NumOrdered) ) where OrderNum is the primary key, how would you convert the table to first normal form?

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

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

If you convert a collection of tables to an equivalent third normal form collection of tables, what problems do you remove?

Which of the following is a characteristic of a table that is in first normal form?

A(n) ________________ key is a candidate key not chosen ad the primary key.

To correct anomalies in a database, tables must be converted into various types of normal forms.

If the primary key of a table contains only a single column, the table is automatically in third normal form.

A table is in fourth normal form when it is in third normal form and there are no ________________ dependencies.

Converting to third normal form always avoids the problems related to dependencies.

A column B is ____________________ on another column A if each value for A in the database is associated with exactly one value of B.

With the table Orders (OrderNum, OrderDate, (ItemNum, NumOrdered) ) where OrderNum is the primary key, how would you convert the table to first normal form?

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