Question 1 (70 pts) Consider the ER diagram illustrated in the following figure (this is similar to the ER diagram from HW1 couple modifications have been made to make the diagram simpler.) Convert the ER diagram to relations and write SQL DDL statements for creating the tables for those relations. Pick suitable data types for each attribute. For string attributes pick reasonable lengths. Include the appropriate constraints (domain, primary key, foreign key, UNIQUE, and NULL constraints) in your SQL DDL statements