Convert the following relational database tables to the equivalent OO conceptual representation. Explain each of your conversions with the help of a diagram. The R&C Stores database includes the three tables shown in Figure PG.6.

Figure PG.6:

Transcribed Image Text:

Database name: RC_Stores Table name: EMPLOYEE EMP STATE EMP DPCODE 32119 EMP CODE EMP TITLE EMP LNAME EMP FNAME EMP NTIAL EMP D08 EMP SERVICE STORE CODE EMP AREACOCE EMP PHONE 21-Jun 62 EMP ADORESS 2219 Orchard Road EMP CITY Flagsta Flagstaf Eagleville Gainesvile 101 M 0456 wiamson Raula Greenboro Rumpershe Smt 1545 John Yes 102 Ms Nancy 12-Mar-1967 02-Nov160 01J1960 23-Dec-1967 Yes 2 545 873-5467 345 Lake Circle AZ 32117 4 615 5 901 3 615 1 545 3 615 1 545 2 545 4 703 3 615 2 545 3 615 4 703 5 901 5 901 4 703 103 Ms No R 23, Box 123 3425 NW SSth Temace 1234 Airport Road TN 30123 Lottie 104 Mrs Jennie No 224-8332 FL 38155 105 M Robert Cary Roberto No 123-7009 870-0705 876-1004 Smyma Flagstaf Mufheesboro Flagstaff Flagstaf Aspen Muteesbore Flagstaf Mufteesboro TN 30118 106 M. Renselaer A. 25-Jan-1964 Yes 1108 Orchard Road AZ 32119 30 Aug-1960 11.Oct-1966 19May-163 06-Apn 1964 21-Nov 1970 32130 32119 32120 41234 32130 Ogalo 107 Mr. 108 Ms 109 Mr. No 2345 Meadow View TN Johnsson Elizabeth No 224-7531 1016 Orchard Road AZ Eindumar Yes 224-906 123-9058 123-2214 9e29 East Main Str. 6543 Snowview Circle 4256 Greenbriar Road AZ Jack Rese Tom 110 Ms Jones No 111 M Broderick Washington Smth Smth Olenko Archiale Grimaldo Rosenberg Rosten Zack Mcbee Ryan No TN 112 M Alan 08-Oct-1972 No 875-4447 2896 Tall Pine Road AZ 32119 25Sep-1962 24Jun-1964 24Jun-1962 04-Oct-1968 12-Dec-1968 23Feb-1969 03-Nov 1966 06Apr 190 113 M Robert Sherry No 224-8999 224-0009 123-870 876-3420 123-7890 123-5360 224-7211 73-2210 875-770 567-0903 4345 Oak Temace 2690 Edelweiss Lane 2314 NW 23rd Place 6641 Clear Lake Drive 4356 Snowlake Road 5112 Avalanche View 3256 Tal Timber Lane 67 Deep Water Drive 3256 Treebranch Lane 446 Hadey C TN 32129 Co FL FL co co co 114 Mrs. No Aspen Gainesvile Lake City Aspen Aspen Aspen Flagstaf Flagsta Smyma 41234 115 M 116 M Howard No 38152 38167 Bary No 117 Ms Jeanine Yes 41234 118 M 41236 41234 32117 32120 37123 Andrew Yes 4 703 1 545 1 545 3615 119 Mr. Peter No 120 M 121 Ms 122 M Rabert Yes Jennifer 10-Jan-1972 Yes AZ 06Feb-1967 TN Herman Yes Table name: STORE STORE ADDRESS 108 1234 Cactus Circle 112 2345 Longview Pike 107 9876 Brandywood Road 103 7654 Mountainview Drive 115 4567 Palmetto Road STORE CODE STORE NAME 1 Access Junction 2 Database Comer 3 Tuple Charge 4 Attribute Alley 5 Primary Key Point STORE YTD SALES REGION_CODE EMP CODE STORE CITY Flagstaf STORE STATE STORE ZIP 32117 1403456.00 1821987.00 AZ Flagstaff Murfreesboro AZ 32121 1386783.00 TN 30130 40123 38762 1344569.00 3330099.00 Aspen Gainesville co FL Table name: REGION REGION_CODE REGION_LOCATION 1 East 2 West ৪৪২