look at the data and come up with a database design in terms of:

Relations, Attributes, Keys, Relationships using the normalization principles studied in class

Document your work by submitting a report listing:

The functional dependencies and state which are full, partial or transitive.

List the candidate keys

Show the sequencing of application of Normal Forms until final design

Draw the ERD representation for your design