-So this is what I have so far....

I need to know how to add attributes to the 6 entity boxes, designate the FK and PK, designate the required vs. optional attributes and indicate the strength of each relationship (weak vs strong)

FIGURE P3.24 THE CH03 AVIACO DATABASE TABLES Table name: CHARTER Database name: Cho03 AviaCo 0001 05-Feb-16 10002 05-Feb-18 2778V 109 4270Y 936 0 320 0 1001 10016 10014 000305-eb-1 0004 0-Feb-18 10005 08-Feb-16 100060-Feb 16 000706-Feb-16 36 0 1023 0 397 7 10011 10017 1001 2 0014 10017 10018 10012 STL 4270Y 105 2770v 1574 0008 07-Feb-1 44 0 1574 IYS 10009 07-Feb-10 07-Feb-16 001107-Feb-10 10012 09-Feb-16 10013 08-Feb-16 001409-Feb-16 2778V TYS 174.3 302.6 4278Y 101 2209L 105 2778V 1 484P 104 427BY 10011 10017 10016 10011 10014 10017 1645 0 00169-Feb-18 10017 10-Feb-16 STL 105 5 001810-Feb-16 The destinations are indicated by standard three-letter airport codes. For example, STL St. Louis, MO ATL Atlanta, GA BNA Nashville, TN Table name: AIRCRAFT AC-TTAF AC-TTEL Aircraft total time, airframe (hours) = Total time, left engine (hours) AC NUMBER AC TTELT AC TTER I MOD CODE PA23-250 AC TTA 1484P 2289L 2778V 4278Y 1833.1 4243.8 79929 1513.1 7895 In a fully developed system, such attribute values 2147.3 6222432 would be updated by application software when the 1018 AC TTER Total time, right engine (hours) 1123.4 1833.1 768.9 PA31-350 PA31-350 CHARTER table entries were posted. Table name: MODEL ? MOD-SEATS! MOD_c oJLE 1.93 2.67 1.93 2.35 MOD-CO DE B200 C-90ABeechcraft MOD-MANUFACTURER Beechcraft MOD,NAME Super KingAir KingAir Aztec Navajo Chieftain 10 PA23-250 Piper PA31-350 Piper 10 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 air- craft 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