Assignment 3 – Database Schema and Relationship Diagram

Provide a database schema and a Crow’s Feet Style Entity Relationship Diagram for your final project. Be sure to include all the tables described in the project assignment.

Be sure to identify all relational and business constraints. Indicate how each one will be enforced. Enforcement can include triggers, stored procedures, uniqueness, foreign key constraints and primitive data types.

You may work together with other members of your group but each of you hand in your own assignment generated separately. That way I know every member knows and understands what the others know.