1. Worksheets

The purpose of this weeks worksheet is to provide additional practice. Please attempt the worksheet without using provided answers. 

2. Questions and Completion

To receive credit for completing the worksheet, you must say ‘Done’ on the worksheet folder.

If you have questions as you go through this worksheet, please feel free to email the instructor.

3. Functional Dependencies

Suppose we decompose relation R(L,M,N,O,P) into relation S(L,M,N) and other relations. Given the functional dependencies that hold in S if the dependencies for R are:

• LM --> OP
• N --> P
• O --> N
• P --> L

4. Normalization
Produce the Third Normal Form of this document by normalization. 

5. Normalization

Consider the following table: Student_Major_Advisor

The following is known about the database domain:

• Each student may major in several subjects.
• For each major, a given student has only one advisor.
• Each major has several advisors.
• Each advisor advises only one major.
• Each advisor advises several students in one major.

Answer the following questions:

• Identify functional dependencies.
• Which of the insert/update/delete anomalies hold on this database.
• Identify candidate keys.
• Is the table in 3NF?
• Is it in BCNF?

6. Check answers

Answers are here, but look at these answers after you have tried the questions.