Entity $-$ Relationship Diagram give me design a relational schema based on the Entity$-$Relation Diagram $($ERD$)$ or Enhanced Entity$-$Relation Diagram $($EER$)$ in Part #$1.$ All relations must be in $3$NF$.$ In each relation, underline the primary key and the foreign key$($s$),$ if any, with a solid line and a broken line, respectively. You should also specify, for each foreign key, the relation it referencess.