CS 311: Databases

Relational Schema for your Project
(Homework 4)

due on Monday, March 13

This is the second of five assignments for our semester-long project.

For this assignment you are to create a list of relational schema for your project. Every object in your E/R diagram, both Entity Sets and Relationships, should have a schema. For each you should give the key attribute (or attributes), and any non-trivial functional dependencies and multivalued dependencies. You do not need to restate functional dependencies as multvalued ones.

All of your relations should be factored at least into Third Normal Form; if you decide to not factor into BCNF you should explain why. Similarly, you should factor into Fourth Normal Form any relations with multivalued dependencies, or explain why you chose not to

If you have made any changes to your E/R diagram from HW2 you should hand in a new copy of the diagram, with changes clearly indicated. I will compare your schema to your old E/R diagram if you don't submit a new one.