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

5.4t Convert European History Diagrams

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.

5.6t Convert Dental Office Diagram

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