$1\mathrm{.}2$ Relational Schema

The following is an excerpt from an ER diagram.

Continue and refine the excerpt into relational schemas. Underline the primary keys of the relations and denote foreign keys in the manner Relation. Attribute.

Two $($or more$)$ attributes within a relation R $,$ referring to the same attribute of another relation T $,$ are noted as follows: R: T$.$Attribute$1,$ T$.$Attribute$2,...]\}.($Attribute$1$ and Attribute$2$ are the names of the referring attributes in the relation R and can thus be selected by R$.$Attribute $1$ or R$.$Attribute$2,$ respectively.$)$ Attribute domains $-$ such as INTEGER $-$ may be omitted.

Only the end result matters. You do not need to show steps. You can write the relations right away. The end result must be denoted clearly.