a$)$ Convert the above ER diagram into relational schemas. In a PDF file, specify the followings for each relation:

$($i$)$ the name of the relation,

$($ii$)$ the names of its attributes,

$($iii$)$ the domain of each attribute,

$($iv$)$ the primary key, and

$($v$)$ the foreign key$($s$),$ if any.

b$)$ Write SQL commands to create tables and all other structures from part a$.$ For each table in your database, specify primary key and indicate all reasonable foreign key constraints, if any. Use check clause to add the following constraints:

gender can only have $\text{'}M\text{'}$ or $\text{'}F\text{'}$ as values

payment$\_$method can only have $\text{'}1\text{'}$ or $\text{'}2\text{'}$ or $\text{'}3\text{'}$ as values

Include your SQL commands $($create statements$)$ in one script file. Please make sure that your script runs on sqlplus or SQL developer by connecting to Oracle server on Zeus. Submit your script file and a log file showing the output of running the script.