Chat with us, powered by LiveChat Table names are shown in boldface with attributes listed in parentheses. | paledu.org
  

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. Forigen keys are indicated by a separate statement that indicartes 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