ASSIGNMENT

Create a relational schema for each of the following diagrams using the following notation

Table names are shown in boldface with attributes listed in parentheses. Primary key are underlined. Foreign keys are indicated by a separate statement that indicates the table referenced on the line immediately following the attribute list.

Here is an example:

Department (DepartmentID, DepartmentName, ManagerID)
ManagerID references Employee

Employee (EmployeeID, FirstName, LastName, HireDate, DepartmentID)
DepartmentID references Department

PerformanceReview (ReviewID, ReviewDate, ReviewScore, Notes, EmployeeID, ManagerID)
EmployeeID references Employee
ManagerID references Employee