1. Consider the following ER diagram. Map it into a relational database schema. Hint: Do not forget to add UNIQUE and NOT NULL in the schema where they needed. 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): ... references ..., UNIQUE, NOT NULL

For example:

Project (ProjectNo, ProjectName), PK: ProjectNo.

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

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

ISBN Title PName) Number of published books ((Locations Book publish Publisher AN End date write M Contract Fee Author review SSN (AName Lic# Lawyer Years First tel