$2.$ Consider the following EER diagram. Map it into a relational database schema. Hint: Do not forget to add UNIQUE and NOT NULL in the schema where they needed. $(50$ pts$)$ PL

Note: For simplicity, the domain for each attribute can be omitted in the schema. The database schema should use the following format for each table:

Relation$\_$name $($attribute name list$),$ PK: $...,$ FK $($if any$)$: $...$ PLEASE DRAW THE DIAGRAM references $...,$ UNIQUE, NOT NULL

For example:

Project $($ProjectNo$,$ ProjectName$),$ PK: ProjectNo.

Employee $($EmployeeNo$,$ Name, WorksOn$),$ PK: EmployeeNo, FK: WorksOn references Project, Workson: UNIQUE, NOT NULL.

$*$ Assume that workson is a $1$:$1$ total relationship for Employee between Employee and Project.