Page 1 of 1
2. Consider the ER/EER diagram given below: Model PLANE_TYPE ● M M 4 WORKS ON FLIES N N Salary EMPLOYEE Lic_num PILOT Ss
Posted: Fri Jul 01, 2022 5:51 am
by answerhappygod
- 2 Consider The Er Eer Diagram Given Below Model Plane Type M M 4 Works On Flies N N Salary Employee Lic Num Pilot Ss 1 (205.53 KiB) Viewed 45 times
2. Consider the ER/EER diagram given below: Model PLANE_TYPE ● M M 4 WORKS ON FLIES N N Salary EMPLOYEE Lic_num PILOT Ssn PERSON Write the SQL code to: [10 Marks] Create tables and their attributes as per the ERD. You can pick any data type for the attributes. Create primary keys and foreign keys for these tables If possible, try to reduce/merge the unnecessary tables