A) Assuming that the sample data are representative, draw a dependency diagram that shows all functional dependencies including both partial and transitive dependencies. Make sure to label each dependency as full dependency , partial dependency , or transitive dependency B) Draw a fully labeled Crow's Foot E-R Diagram in Visio, including all entities, attributes, primary keys, foreign keys, and relationships, clearly labeled.

C) Using what you completed in Part D, write out the relational schema. Label primary key attributes and foreign key attributes.

ATTRIBUTE SAMPLE SAMPLE SAMPLE SAMPLE