(Solved) : 4 Convert Following E R Diagram Relational Database Schema Remember Underline Key Relation Q44004883 . . .
4. Convert the following E/R diagram to a relational database schema. Remember to underline the key for each relation. Justify your conversion if necessary. [15 points] AgencyID Name Operating Agencies Operated by HomeBase Phone Time Name VehicleID Signees Signed out Crafts SSN Passenger Capacity Cargo Capacity Rotor Diameter Vehicle Capacity Vessel Name Aircrafts Helicopters Ferries Pilot License Pilots Pilot Pilot Show transcribed image text 4. Convert the following E/R diagram to a relational database schema. Remember to underline the key for each relation. Justify your conversion if necessary. [15 points] AgencyID Name Operating Agencies Operated by HomeBase Phone Time Name VehicleID Signees Signed out Crafts SSN Passenger Capacity Cargo Capacity Rotor Diameter Vehicle Capacity Vessel Name Aircrafts Helicopters Ferries Pilot License Pilots Pilot Pilot
Expert Answer
Answer to 4. Convert the following E/R diagram to a relational database schema. Remember to underline the key for each relation. J…
OR