Schema definitions $($in $3$NF$)$ obtained from the E$-$R diagram above with primary and foreign keys clearly

identified for each table.

Then complete schema diagram for the schema definition