Question $2$: Convert the given Enhanced Entity$-$Relationship $($EER$)$ diagram into a set of relational tables. Clearly define each table with its attributes, primary keys, and foreign keys $($if any$).(16$ Points$)$

Question $2$ Evaluation Criteria:

$\backslash$table$[[$Criteria$,$Points$],[$Correct Number of tables,$8],[$Correct Identifiers,$4],[$Correct number of Attributes,$4],[$Total$,16$