Do the following exercises:

1. Do exercise 14.31.

   • Consider only 1NF, BCNF and 4NF; ignore 2NF and 3NF.

2. Do exercise 14.35. Make the following (potentially counter-intuitive) assumptions.

   • Book_name and edition functionally determine year, but not vice-versa.
   • The title and coauthor names stay the same from edition to edition.

   Your justification of the MVD can be an informal, one-to-two-sentence explanation.

3. Complete the programming elements for the lab exercises.

Store your analysis for the first two exercises in a single homework04.txt file; store your solutions to the lab programming in their original lab files.

Checking in

We will grade your work according to the following criteria:

• 40% — Exercise 1
• 40% — Exercise 2
• 20% — Exercise 3