CSCI 5333.2 DBMS
Spring 2020
Homework #2

Conversion of UML Class Diagram to Relational Schema

Based on the suggested solution of HW#1, provide a reasonable set of relation schema for implementing the class diagram. Use the suggested solution of HW #1, not your own solution. Identify all candidate keys and foreign keys. List all nullable and non-nullable attributes. Use this docx template for your answer.

Submit your homework through Blackboard using a MS Words document: <<lastname>>_<<student_id>>_h2.docx.