Convert this conceptual model to a database design $($using the E$-$R diagram notations$)$

Your design should include a specification of tables and attributes as well as primary, alternate and foreign keys. Identify the SQL Server data type for each attribute.

List all relationships in your model using the table below.

Summary of design relationships

$\backslash$table$[[$Relationship$,,$Cardinality$],[$Parent$,$Child,$\backslash$table$[[$Type$],[($Identifying$/$Nonidentifying$)]],\backslash$table$[[$Maximum$],[$Cardinality$],[$ or$],[$N:$M$