need assistance in clear steps using crows feet to create an ERD and entity relationship based on the provided table with the following keys identifying the following types of keys.

primary, super, candidate, foreign, and secondary key.

thank you.

Table name: CHARTER Database name: Ch03_AviaCo The destinations are indicated by standard three-letter airport codes. For example, STL=St. Louis, MO ATL= Atlanta, GA Table name: AIRCRAFT Table name: MODEL BNA= Nashville, TN AC-TTAF = Aircraft total time, airfame (hours) AC-TTEL = Total time, left engine (hours) AC_TIER = Total time, right engine (hours) In a fully developed system, such attribute values would be updated by application software when the CHARTER table entries were posted. Customers are charged per round-trip mile, using the MOD_CHG_MILE rate. The MOD_SEATS column lists the total number of seats in the airplane, including the pilot and copilot seats. Therefore, a PA31-350 trip that is flown by a pilot and a copilot has eight passenger seats available. Use the database shown in Figure P3.24 to answer Problems 24-31. AviaCo is an aircraft charter company that supplies on-demand charter flight services using a fleet of four aircraft. Aircraft are identified by a unique registration number. Therefore, the aircraft registration number is an appropriate primary key for the AIRCRAFT table