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
- Create A Relational Schema For Each Of The Following Diagrams Using The Following Notation Table Names Are Shown In Bol 1 (57.31 KiB) Viewed 30 times