List all the attributes and foreign key attributes of the relation AIRPLANE resulting from mapping the entity AIRPLANE.

 

Transcribed Image Text:

Model Reg Number Capacity PLANE-TYPE 1 OF-TYPE N AIRPLANE N STORED-IN HANGAR Capacity Weight Location Date N N N WORKS-ON Workcode FLIES Date/workcode OWNS Pdate M M Name N MAINTAIN SERVICE PLANE SERVICE N CORPORATION Address Restr M Salary Phone EMPLOYEE Hours PILOT OWNER San Shift Lic-num Nicknames PERSON Address Phone Model Reg Number Capacity PLANE-TYPE 1 OF-TYPE N AIRPLANE N STORED-IN HANGAR Capacity Weight Location Date N N N WORKS-ON Workcode FLIES Date/workcode OWNS Pdate M M Name N MAINTAIN SERVICE PLANE SERVICE N CORPORATION Address Restr M Salary Phone EMPLOYEE Hours PILOT OWNER San Shift Lic-num Nicknames PERSON Address Phone

Answer rating: 100% (QA)

Here are the attributes and foreign key attributes of the relation AIRPLANE Attribute Foreign Key Model PLANETYPE Weight Capacity python import pandas as pd Define the entity relationship diagram erd ... View the full answer