Name: 
 

Study Guide - Chapter Five (Part Three)



Completion
Complete each sentence or statement.
 

1. 

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

 

2. 

To correct ____________________ anomalies in a database, you must convert tables into various types of normal forms.
 

 

3. 

A table in a particular ____________________ form possesses a certain desirable collection of properties.
 

 

4. 

An attribute named B is functionally ____________________ on another column named A if a value for A determines a single value for B at any one time.
 

 

5. 

If B is functionally ________________________ on A, we can use the notation A->B.
 

 

6. 

We can say that column A is the ____________________ key for a relation if all columns in the relation are functionally dependent on A and no subcollection of columns in A is also functionally dependent on A.
 

 

7. 

A relation is in first normal form if it does not contain ____________________ groups.
 

 

8. 

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

 

9. 

A relation is in second normal form if it in first normal form and no nonkey column is ____________________ on only a portion of the primary key.
 

 

10. 

Any column that determines another column is called a(n) ____________________.
 

 

11. 

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

 

12. 

A better definition or name for the third normal form is referred to as ____________________ normal form.
 

 

13. 

A table is in fourth normal form if it is in third normal form and there are no ____________________ dependencies.
 

 

14. 

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

 

15. 

A(n) _______________________ dependency of column B on column A of the same table is usually written as A ->-> B.
 

 

16. 

The conversion of a(n) ____________________ form to first normal form requires the removal of repeating groups.
 

 

17. 

If there are two or more repeating groups in a table, you must place each repeating group in a(n) ____________________ table.
 

 

18. 

To summarize the requirements of a first normal form, there must be no ______________________ groups.
 

 

19. 

To summarize the requirements for the third normal form, the table must be in second normal form with the only ____________________ being candidate keys.
 

 

20. 

To summarize the requirements for the fourth normal form, the table must be in third normal form and have no multivalued ____________________.
 

 

Short Answer
 

21. 

What process enables you to identify the existence of potential problems?
 

22. 

There are potential problems that can occur in relations (tables).  What are these problems called?
 

23. 

What is the terminology for a value in column A in a table to determine a single value for column B in the same table at any one time?
 

24. 

If there are a number of columns that could be classified as a primary key, what is the term for all these possibilities?
 

25. 

If a candidate key is not chosen as the primary key, by what term are these candidate keys referred?
 

26. 

What is a column called if it is not a part of the primary key?
 

27. 

If the primary key of a table contains only a single column, then this table is in what normal form?
 

28. 

What is the term for any column that determines another column?
 

29. 

When a table is in third normal form, it is in second normal form and the only determinants it contains are what type of keys?
 

Essay
 
 
chfive3_files/i0330000.jpg
 

30. 

Please refer to the above figure.  Is Class the primary key for the Part table?  Explain your answer.
 
 
chfive3_files/i0350000.jpg
 

31. 

Using the above figure, explain the reason for splitting the Faculty table into two separate tables.   Use the concepts of update, additions, and deletions in examples as the basis for your answer.
 

32. 

How do we divide tables that have two or more repeating groups?  How do we create the new primary key?
 



 
Check Your Work     Reset Help