CSCI 5333.4 DBMS
Homework #2

Due date: 2/15 (Wednesday)

Based on the solution of HW#1, provide a reaonable set of relation schemas for implementing the class diagram. Use the suggested solution of HW #1, not your own solution. Underline the primary key of each relation and identify all candidate keys and foreign keys.

Bonus (10%): identify the highest normal form of each relation.