5.2t Convert Bank Diagrams
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
1.
2.
3.
5.2t Convert Bank Diagrams Create a relational schema for each of the following diagrams using the following notation: T
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
5.2t Convert Bank Diagrams Create a relational schema for each of the following diagrams using the following notation: T
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!