Convert the following $($E$)$ER diagram to a relational model. $(25$ points$)$

$($b$)$ Translate all attributes including derived

attributes, and $($c$)$ Underline the primary key and indicate foreign keys.

The relational models will be evaluated based on the following criteria:

$$ Correct transformation of ER to relational schema

$$ Indicating the right primary key constraints and foreign key constraints

$$ Consistent naming convention and syntax