use sub-type hirearchy notation to create a crows foot notation

FIGURE P3.24 THE CH03_AVIACO DATABASE TABLES Table name: CHARTER Database name: Ch03_AviaCo CHATOARDAIS CHARLOUCHAR.COPE ON A MACHAR CESTATION CHARCUSTANCE CHAREHOURS FLOW CHAR HOURS WATCHARFLER GALLOS CAROEGES CS00 *0001 104 220 200 10000 51 22 OS Fb:10 100 27 ERA 3541 10011 2006 10003 ta 05.10 00 105 10342 726 100te 15140 10004 70 00 38 10014 106 1414 2 STL 10004 23 45 92 06-7-14 101 229 ATL 10030 10013 57 10006 35 06.16 10 37 42TY STL 2 10011 0-16 4720 104 20 52 105 TV GNV . 10017 10000 15940 79 OT.F.16 108 00 163P 04 TV5 2 10012 546 41 10000 00 UT-10 105 2203 1406 GRY 10014 1914 1000 077-16 230 409 101 AL 10017 62 1000 3 OT 101 299 104 14 320 10016 10013 15 07. 100 21 10012 42 1000) 07:10 104 NY 2150 TY 5440 10010 1001 45 09.16 100 1163 ATL 100 61 21 007.10 104 06 0 101 2201 G 10017 10018 15460 00 09-760-16 100 103 21 NOY 4385 2 10016 10011 3520 00 107-10 101 2 ST 10011 500 31 10018 00 105 1038 107-16 10142 10014 1449 1001 we 2432 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 = Aircraft total time, airframe (hours) AC NUMBER MOD CODE AC TTAF AC TTEL ACTTER AC-TTEL = Total time, left engine (hours) 1484P PA23-250 1833 11 18331 101.8 AC_TTER = Total time, right engine (hours) 2209L C-90A 42438 7889 11234 2778V PA31-350 79929 15131 7895 In a fully developed system, such attribute values 4278Y PA31-350 21473 6221 would be updated by application software when the CHARTER table entries were posted. Table name: MODEL MOD_CODE MOD_MANUFACTURER MOD_NAME MOD_SEATS MOD_CHO_MLE B200 Beechcraft Super KingAir 10 1.93 C-90A Beechcraft King Air 8 2.67 PA23-250 Piper Aztec 6 1.93 PA31-350 Piper Navajo Chieftain 10 2.35 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. FIGURE P3.24 THE CHO3_AVIACO DATABASE TABLES Table name: CHARTER Database name: Ch03_AviaCo OPONAR DATE CHWILOT CHARCOPLOTA MERCURESTINATION OW_DSTANCE CHALLMOLLOY WERE WATCWL_GALLONSOWO OTCA.CO 1000 10:10 100 2303 AL 9900 51 22 10000 05-Feb-10 101 . 2778 BU tB 00 1000 105 100 4TBY ON 10016 15740 10 00 2 10004 18 100 . 10014 1450 STI 4120 23 49 10006 06-10-10 100 220 ATL 32 1 10019 10230 35 10006 3977 16-18 2 10011 4278 SIL 4730 25 52 1000 104 1171 0 1062 GNV 15740 79 10017 00 3434 10012 10000 017-18 14 2 TYS 43 00 10000 07 Feb 18 105 2201 ON 15740 68 23.4 10010 100 017 499.9 ATL 0 10017 4207 2 32 1001 2737 o D-10 101 104 14 10010 3520 19 33 54 10012 00-10-10 01 . 0012 MOD 0040 43 42 100 2151 18-Feb-16 105 O ODIO 4278 5440 3.9 45 toon 1743 001 12 10011 ALL 61 21 2026 O 10015 09.10 100 1012203 10017 ON 15410 81 00 2505 09-10 509 2 MOY 016 105 TOV 312.0 1.5 1001? 00 17 0 101 STL 5080 21 00 10010 10718 10014 104 4270Y TYS 45 10017 10016 10011 1055 1833 1 1123 4 15131 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 = Aircraft total time, airframe (hours) AC NUMBER MOD CODE AC_TTAF AC TTEL AC TTER AC-TTEL = Total time, left engine (hours) 1484P PA23-250 1833 1 101.8 AC_TTER = Total time, right engine (hours) 22891 C-90A 4243.8 768.9 2778V PA31-350 79929 789,5 In a fully developed system, such attribute values 4278Y PA31-350 21473 6221 243 2 would be updated by application software when the CHARTER table entries were posted. Table name: MODEL MOD_CODE MOD_MANUFACTURER MOO_NAME MOD_SEATS MOD_CHG_MILE B200 Beechcraft Super Kingar 10 1.93 C-90A Beechcraft King Air 2.67 PA23-250 Aztec PA31-350 Piper Navajo Chieftain 10 2.35 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 seals. Therefore, a PA31-350 trip that is flown by a pilot and a copilot has eight passenger seats available. Piper 8 6 1.93 FIGURE P3.24 THE CH03_AVIACO DATABASE TABLES Table name: CHARTER Database name: Ch03_AviaCo CHATOARDAIS CHARLOUCHAR.COPE ON A MACHAR CESTATION CHARCUSTANCE CHAREHOURS FLOW CHAR HOURS WATCHARFLER GALLOS CAROEGES CS00 *0001 104 220 200 10000 51 22 OS Fb:10 100 27 ERA 3541 10011 2006 10003 ta 05.10 00 105 10342 726 100te 15140 10004 70 00 38 10014 106 1414 2 STL 10004 23 45 92 06-7-14 101 229 ATL 10030 10013 57 10006 35 06.16 10 37 42TY STL 2 10011 0-16 4720 104 20 52 105 TV GNV . 10017 10000 15940 79 OT.F.16 108 00 163P 04 TV5 2 10012 546 41 10000 00 UT-10 105 2203 1406 GRY 10014 1914 1000 077-16 230 409 101 AL 10017 62 1000 3 OT 101 299 104 14 320 10016 10013 15 07. 100 21 10012 42 1000) 07:10 104 NY 2150 TY 5440 10010 1001 45 09.16 100 1163 ATL 100 61 21 007.10 104 06 0 101 2201 G 10017 10018 15460 00 09-760-16 100 103 21 NOY 4385 2 10016 10011 3520 00 107-10 101 2 ST 10011 500 31 10018 00 105 1038 107-16 10142 10014 1449 1001 we 2432 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 = Aircraft total time, airframe (hours) AC NUMBER MOD CODE AC TTAF AC TTEL ACTTER AC-TTEL = Total time, left engine (hours) 1484P PA23-250 1833 11 18331 101.8 AC_TTER = Total time, right engine (hours) 2209L C-90A 42438 7889 11234 2778V PA31-350 79929 15131 7895 In a fully developed system, such attribute values 4278Y PA31-350 21473 6221 would be updated by application software when the CHARTER table entries were posted. Table name: MODEL MOD_CODE MOD_MANUFACTURER MOD_NAME MOD_SEATS MOD_CHO_MLE B200 Beechcraft Super KingAir 10 1.93 C-90A Beechcraft King Air 8 2.67 PA23-250 Piper Aztec 6 1.93 PA31-350 Piper Navajo Chieftain 10 2.35 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. FIGURE P3.24 THE CHO3_AVIACO DATABASE TABLES Table name: CHARTER Database name: Ch03_AviaCo OPONAR DATE CHWILOT CHARCOPLOTA MERCURESTINATION OW_DSTANCE CHALLMOLLOY WERE WATCWL_GALLONSOWO OTCA.CO 1000 10:10 100 2303 AL 9900 51 22 10000 05-Feb-10 101 . 2778 BU tB 00 1000 105 100 4TBY ON 10016 15740 10 00 2 10004 18 100 . 10014 1450 STI 4120 23 49 10006 06-10-10 100 220 ATL 32 1 10019 10230 35 10006 3977 16-18 2 10011 4278 SIL 4730 25 52 1000 104 1171 0 1062 GNV 15740 79 10017 00 3434 10012 10000 017-18 14 2 TYS 43 00 10000 07 Feb 18 105 2201 ON 15740 68 23.4 10010 100 017 499.9 ATL 0 10017 4207 2 32 1001 2737 o D-10 101 104 14 10010 3520 19 33 54 10012 00-10-10 01 . 0012 MOD 0040 43 42 100 2151 18-Feb-16 105 O ODIO 4278 5440 3.9 45 toon 1743 001 12 10011 ALL 61 21 2026 O 10015 09.10 100 1012203 10017 ON 15410 81 00 2505 09-10 509 2 MOY 016 105 TOV 312.0 1.5 1001? 00 17 0 101 STL 5080 21 00 10010 10718 10014 104 4270Y TYS 45 10017 10016 10011 1055 1833 1 1123 4 15131 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 = Aircraft total time, airframe (hours) AC NUMBER MOD CODE AC_TTAF AC TTEL AC TTER AC-TTEL = Total time, left engine (hours) 1484P PA23-250 1833 1 101.8 AC_TTER = Total time, right engine (hours) 22891 C-90A 4243.8 768.9 2778V PA31-350 79929 789,5 In a fully developed system, such attribute values 4278Y PA31-350 21473 6221 243 2 would be updated by application software when the CHARTER table entries were posted. Table name: MODEL MOD_CODE MOD_MANUFACTURER MOO_NAME MOD_SEATS MOD_CHG_MILE B200 Beechcraft Super Kingar 10 1.93 C-90A Beechcraft King Air 2.67 PA23-250 Aztec PA31-350 Piper Navajo Chieftain 10 2.35 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 seals. Therefore, a PA31-350 trip that is flown by a pilot and a copilot has eight passenger seats available. Piper 8 6 1.93