Convert the following relational database tables to the equivalent OO conceptual representation. Explain each of your conversions with the help of a diagram. ) The Avion Sales database includes the tables shown in Figure PG.7.

Figure PG.7:

Transcribed Image Text:

Database name: Avion_Sales Table name: PRODUCT TOO.0OST CO ICEPOD.OH ROO MGOH OO LAST.ORCE ADF O y AD,pnemoryd ore A SMw-3004 APOLLOe OPS rdd APOLLONO s Mvg r LED prognpe A Pae 17 10 20 12 Mvng na Hn Mow APOLLO- OPS 24 AT-150 Tranporde Sd Pe MCSO, 250- ronte 190000 250 12 Moving m L Hae Tere Pes, e en LCD teng 12 15 OPS OS , S Frortodng 14 Ce-20 Hane ann Arey, e nott, p 12 12 Mvng WMng n, e gan dchg d, eto s Re, e gd ee tioCE 12 14 Mvng ma Pe ending ng Dnding n seton nd cor treece Sk men, 200chve, dteron, gnpend, neto MA34 Ado P d e 0 17 12 12 10 dd Pe 0 12 NCon 12 10 e dn e ng chave, d Pe edng Stren depiay of 2preseiecte 12 10 gece voceactvetroon t postontoge 2 ter dgiy, 20prt rert Audo p d 17 e se 15 10 2e 0 he 2000 12 -2000A OPS Shndd Pae Teree LD, vertca ve, trtce to moing m, p 0 S0 TRT2500 Traponde hended Pel Tes CUS NUM CUS UNAME CUS FNAME CUS INITIAL CUS AREACODE CUS PHONE CUS YTD_BUY CUS CREDIT CUS BALANCE 0.00 1700 51 0.00 Table name: CUSTOMER 10010 Ramas 10011 Dunne 10012 Smith 5000.00 5000.00 5000.00 5000.00 Alfred 615 713 615 844-2573 2011.56 4613 29 3217.94 к 894-1230 Leona Kathy Paul 894-2285 894-2180 222-1672 442-3381 9562 67 Table name: SELLER 4358 55 (EM NUM SEL YTD SALESTSEL PCT SELYIO COMMISSION 0.00 1217 84 1629 95 1232.42 854.76 10013 Olowski 10014 Orlando 10015 OBrian 615 615 713 10020 53 14234 85 3005 77 Myron Amy 7500.00 5000.00 203 21945 51 800 800 263 01 1756 64 10016 Brown 10017 Williams 10018 Fariss 10019 Smith James 615 615 713 615 297-1228 290-2556 5432 76 1629 96 3056 31 8938 43 5000 00 1000.00 2500.00 7500.00 105 305430 1257 00 106 305432 1000 George 500 800 382-7185 297-3809 Anne 29615 68 Olette 1000 62 110 20012 45 500 EMP NUM EMP TITLE EMP UNAME EMPFNAME EMP NTAL EMP HRE DATE EMP DO8EOB.CODE Table name: EMPLOYEE 15-Mars 15 Sep2T 25Apr-90 01-Dec83 T 20-Dec 93 24Ma77S 28Aug6 18May4 A 20-Oct7 00-eS A OBNov 1No72S 06Jan- 2Autas 100 M Kalmya Andrew Barbara Table name: INV_LINE MUNE PRICEMNE TOTAL e500 Lewis 102 M Vandam Marie NNM NMLNE NM 10001 10001 10002 PROD COOMNE UNTS TOPSAVO 2 TMA 00 Jones Lange Willams 103 M Rebert 104 Dr 1700 00 10S M 10 Ms George Du Darte Wesenbach Tr 1TNLIODC) 2 MA24 Judith 10003 10003 K. 18Mas 108 Ms. 18 No 10003 10003 з сРам 4 00 0 00 Rubeta 19Sep 9 S 30-ansS జ 14 Apr9 01-Dec03 109 Peter 110 M Genkai George Table name: INVOICE NV NUM CUS NUM EMP NUM NV DATE NV SUB NV_TAX8% NV_TOTAL NV_PYMT NV BALANCE 10001 10015 103 14-Jan-14 2325.00 186.00 2511.00 2511.00 0.00 10018 0.00 10002 105 14-Jan-14 1599.00 127.92 1726.92 1726.92 2066.72 10003 10010 105 15-Jan-14 7284.00 582.72 7866.72 5000.00