Consider the ER diagram illustrated in the following figure. 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.

Note : For the one$-$to$-$many binary relations, combine the relation with the many side. For the superclass$-$subclass entity sets, translate them using the ER$-$approach.