Create a relational schema for each of the following diagrams using the following notation: Table names are shown in bol
Posted: Tue Jul 12, 2022 8:28 am
Create a relational schema for each of the followingdiagrams using the following notation:
Table names are shown in boldface with attributes listed inparentheses. Primary key are underlined. Forigen keysare indicated by a separate statement that indicartes the tablereferenced on the line immediately following the attributelist.
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
Table names are shown in boldface with attributes listed inparentheses. Primary key are underlined. Forigen keysare indicated by a separate statement that indicartes the tablereferenced on the line immediately following the attributelist.
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