Name: 
 

Study Guide Chapter Five (Part One)



True/False
Indicate whether the sentence or statement is true or false.
 

1. 

The normalization process enables you to identify the existence of potential problems.
 

2. 

Potential problems that can occur within tables are called disbursement anomalies.
 

3. 

To correct update anomalies in a database, tables must be converted into various types of normal forms.
 
 
chfive1_files/i0050000.jpg
 

4. 

Please refer to the above figure. It can be said that the CustomerName in the Customer table is functionally dependent on RepNum.
 
 
chfive1_files/i0070000.jpg
 

5. 

Please refer to the above figure. We can say that NumOrdered in the OrderLine table is functionally dependent on OrderNum.
 

6. 

Please refer to the above figure. We can see that NumOrdered in the OrderLine table is functionally dependent on both columns OrderNum and PartNum.
 

7. 

Please refer to the above figure. It can be said that NumOrdered, from the OrderLine table, is functionally dependent on PartNum.
 

8. 

Please refer to the above figure. OrderNum is the primary key for the OrderLine table.
 

9. 

Please refer to the above figure. The combination of OrderNum and PartNum is the primary key for the OrderLine table.
 

10. 

Please refer to the above figure.  In the table OrderLine, NumOrdered is functionally dependent on QuotedPrice.     
 

11. 

Attribute B is functionally dependent on attribute A if the value for A determines a single value for B.
 

12. 

Functional dependencies can be determined by looking at sample data.
 
 
chfive1_files/i0160000.jpg
 

13. 

Please refer to the above figure. Class is the primary key for the Part table.
 

14. 

Please refer to the above figure. The combination of PartNum and Description is the primary key for the Part table.
 
 
chfive1_files/i0190000.jpg
 

15. 

Please refer to the above figure. CustomerNum is the primary key for the Customer table.
 

16. 

A table that contains a repeating group is in first normal form.
 

17. 

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

18. 

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

19. 

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

20. 

A table is in third normal form if it is in second normal form and the only determinants are a single primary key.
 

21. 

To put a table in the third normal form, you must remove the determinant.
 

22. 

To put a table into third normal form, make the determinant the primary key of the new table.
 

23. 

A valid decomposition of tables is one in which the functional dependence has been split across two different tables.
 

24. 

A table is in fourth normal form if it is in third normal form and has no multivalued dependencies.
 

25. 

In a table with columns A, B, and C, there is a multivalued dependency of column B on column A if each value for A is associated with a specific collection of values for B, and further, this collection is independent of any values for C.
 

26. 

Given the definition of a multivalued dependency, we can also write it as A ->-> B.
 

27. 

If a table is in third normal form and has multivalued dependencies, then it is considered to be in fourth normal form.
 

28. 

To better normalize a table, all you need is a more sophisticated method for converting an unnormalized table to first normal form.
 

29. 

If there are two or more repeating groups, place each repeating group in a separate table.
 

30. 

If there are two or more repeating groups and you place each repeating group in its own table, then the primary key for each table will be the primary key of the original table.
 

Modified True/False
Indicate whether the sentence or statement is true or false.  If false, change the identified word or phrase to make the sentence or statement true.
 

31. 

The normalization process enables you to identify the existence of potential problems.

 

32. 

Potential problems that can occur within tables are called disbursement anomalies.

 

33. 

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

 
 
chfive1_files/i0400000.jpg
 

34. 

Please refer to the above figure.  Class is the primary key for the Part table.

 

35. 

A column is a(n) nonkey column if it is not a part of the primary key.

 

36. 

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

 

37. 

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

 

38. 

A table is in third normal form if it is in first normal form and the only determinants it contains are candidate keys.

 

39. 

The most recent definition of a third normal form is to refer to it as the Bornes-Culan normal form.

 

40. 

A table is in fourth normal form if it is in third normal form and has no multivalued dependencies.

 

41. 

The correct notation to write that B is dependent on A would be A -> ->B.

 

42. 

The correct notation to write that A multidetermines B is A->->B.

 

43. 

In order to convert a table from third to fourth normal form, you must split the table into separate columns.

 

44. 

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

 

45. 

If there are two or more repeating groups in a table, then each group must be placed in a(n) separate table.

 

46. 

When a table has been split into two tables, the primary key to each new table consists of the concatenation of the original primary key and the primary key to the system groups.

 

47. 

To summarize the concept of the first normal form, no repeating groups must exist.

 

48. 

To summarize the concept of the second normal form, it must be in first normal form and no data column can be dependent on any portion of the primary key.

 



 
Check Your Work     Reset Help