BUS 309 -Assignment 2 You will submit two files for this assignment. The first question is about primary key and foreign keys. Enter your answers into the the tables in page 3 and save this document as assignment2 yourFIRSTNAME.docx. The second question is about ERD. You should submit your ERD in another file. Any file format for ERD is fine(pdf, jpeg. png and so on...). ROBCOR is an aircraft charter company that supplies on-demand charter flight services using a fleet of four aireraft. Airerafts are identified by a unique registration number. Therefore, the aircraft registration number is an appropriate primary key for the AIRCRAFT table. The destmations are inficaled ly sasdest three teder airport cofes. For exanple. SIL = SU. Leutk, 110 ATL = Adanta, CA Bhet in fiastrifte. Hik airplane, including the pillot and cepilot aeals. Therefore, PAJ1350 trip that is flowit by a plist and a copilot has eight pasierger seats avallable. The nulls in the CHARTER table's CHAR_COPILOT column indicate that a copllot is not required for some charter trips or for some alrcraft. Federal Aviation Administration (FAA) rules require a copilot on jet aireraft and on aireraft having a gross take-off weight over 12,500 pounds. None of the aireraft in the AIRCRAFT table are governed by this requirement: however, some customers may require the presence of a copilot for insurance reasons. All charter trips are recorded in the CHARTER table. Database name: Cho3_Avlaco The plist licenses shown in the Pitor table inclebe the ATP - Mrine Transpont Piot and Cod - Conmecial Phot. bushermes Bat. operale "ce dernand" at sencices ane goveresed by Part 135 of the Fedwral Air Hegulolom FFARs) that are endorced by he Federal (PA urd tres 2.3 1. For each table, where possible, identify: a. The primary key ( 2 points) b. The foreign key(s) ( 2 points) c. A superkeys (2 points)