Your Business is a spreadsheet from a poorly organized database/business. (See Excel File) You are a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
"Your Business" is a spreadsheet from a poorly organized database/business. (See Excel File) You are a database consultant hired to review their data and create a new database. Write your answer in the provided space for each question and save it as a PDF file. Then submit one PDF file only. 1. Find all the dependencies: Solution: 2. Normalize to 2NF. Give each table a name and list the attributes in each table. Provide structural answers only in DBDL showing functionalities and tables. Solution: 3. Specify primary and foreign keys for each table (Tables that are in 3NF). Provide structural answers only in DBDL showing functionalities and tables. Solution: 4. Write a set of business rules to go along with your normalized tables Solution: Do not include the data. The data is provided for your reference. You may have to reuse attributes, but do not create any additional fields. V82 C D 1 Customerll'irstNam MiddleNam astNam 2 11000 V 3 11000 V V A B Jon Jon 4 11000 Jon 5 11000 Jon 6 11000 Jon 7 11000 Jon 8 11000 Jon 11000 Jon 10 11001 Eugene 9 11 11001 Eugene 21 22 23 V V V V V I L L 12 11001 Eugene 13 11001 Eugene 14 11001 Eugene 15 11001 Eugene L 16 11001 Eugene L 11001 Eugene 18 11001 Eugene 17 L L 11001 Eugene L 20 11001 Eugene L 19 11002 Ruben NULL 11002 Ruben NULL 11002 Ruben NULL 24 11002 Ruben NULL 25 11003 Christy NULL 11003 Christy NULL 11003 Christy NULL 11003 Christy NULL 26 27 28 L L fxx E BirthDate Address Phone alesOrderNumb OrderDate)rderQuantit Yang 4/8/1970 2 NW. Bay Meadows Av (500)444-061 SO43793 20050722 Yang 4/8/1970 2 NW. Bay Meadows Av(500)444-061 SO51522 20070722 Yang 4/8/1970 2 NW. Bay Meadows Av (500)444-061 SO51522 20070722 Yang 4/8/1970 2 NW. Bay Meadows Av/500)444-061 SO57418 20071104 Yang 4/8/1970 2 NW. Bay Meadows Av(500)444-061 SO57418 20071104 Yang 4/8/1970 12 NW. Bay Meadows Av(500)444-061 SO57418 20071104 Yang 4/8/1970 12 NW. Bay Meadows Av(500)444-061 SO57418 20071104 Yang 4/8/1970 2 NW. Bay Meadows Av(500)444-061 SO57418 20071104 Huang 5/14/1969 805 Court Court (500)444-062 SO43767 20050718 Huang 5/14/1969 805 Court Court (500)444-062 SO51493 20070720 Huang 5/14/1969 805 Court Court (500)444-062 SO51493 20070720 Huang 5/14/1969 805 Court Court (500)444-062 SO51493 20070720 Huang 5/14/1969 805 Court Court (500)444-062 SO51493 20070720 Huang 5/14/1969 805 Court Court (500)444-062 SO51493 20070720 Huang 5/14/1969 805 Court Court (500)444-062 SO51493 20070720 Huang 5/14/1969 805 Court Court (500)444-062 SO72773 20080612 Huang 5/14/1969 805 Court Court (500)444-062 SO72773 20080612 Huang 5/14/1969 805 Court Court (500)444-062 SO72773 20080612 Huang 5/14/1969 805 Court Court (500)444-062 SO72773 20080612 Torres 8/12/1969 297 S. Lafayette Dr. (500)444-062 SO43736 20050710 Torres 8/12/1969 297 S. Lafayette Dr. (500)444-062 SO51238 20070704 Torres 8/12/1969 297 S. Lafayette Dr. (500)444-062 SO53237 20070827 Torres 8/12/1969 297 S. Lafayette Dr. (500)444-062 SO53237 20070827 Zhu 2/15/1972 82 Brickyard St. (500)444-06: SO43701 20050701 Zhu 2/15/1972 82 Brickyard St. (500)444-06: SO51315 20070709 Zhu 2/15/1972 82 Brickyard St. (500)444-06: SO51315 20070709 Zhu 2/15/1972 82 Brickyard St. (500)444-063 SO51315 20070709 I J 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 K ProductNum M100-$38 M200-$38 FSM T1000-846 TTO01 TT001-T SPH100-R SSClassic-S M100-844 M200-$38 FSM WB-30 MBC Ssclassic-XL AWC-LC R750-844 WB-30 RBC SPH100-B M100-$44 M200-838 T1000-Y46 SPH100-BL M100-$44 M200-842 MBC WB-30 M 0 ProductName UnitPrice alesAmouroductSubcategoryktandardCo ColoristPric Size VeightroductLine Mountain-100 Silver, 38 3399.99 3399.99 1912.154 Silver 3400 38 20.4 Mountain-200 Silver, 38 2319.99 2319.99 1265.62 Silver 2320 38 23.4 Fender Set - Mountain 21.98 21.98 8.2205 NA 21.98 NULL NULL Touring-1000 Blue, 46 2384.07 2384.07 1481.938 Blue 2384 46 25.1 Touring Tire 28.99 28.99 10.8423 NA 28.99 NULL NULL Touring Tire Tube 4.99 4.99 1.8663 4.99 NULL NULL !Sport-100 Helmet, Red 34.99 34.99 13.0863 Red 34.99 NULL NULL nort-Sleeve Classic Jersey 53.99 53.99 41.5723 Yellow 53.99 S NULL Mountain-100 Black, 44 3374.99 3374.99 1898.094 Black 3375 44 21.1 Mountain-200 Silver, 38 2319.99 2319.99 1265.62 Silver 2320 38 23.4 Fender Set - Mountain 21.98 21.98 8.2205 I NA 21.98 NULL NULL Water Bottle - 30 oz. 4.99 4.99 1.8663 4.99 NULL NULL Mountain Bottle Cage 9.99 9.99 3.7363 9.99 NULL NULL ort-Sleeve Classic Jersey, 53.99 53.99 41.5723 Yellow 53.99 XL NULL AWC Logo Cap 8.99 8.99 6.9223 Multi 8.99 NULL NULL Road-750 Black, 44 539.99 539.99 343.6496 Black 540 44 19.8 Water Bottle - 30 oz. 4.99 4.99 1.8663 4.99 NULL NULL Road Bottle Cage 8.99 8.99 3.3623 8.99 NULL NULL Sport-100 Helmet, Black 34.99 34.99 13.0863 Black 34.99 NULL NULL Mountain-100 Silver, 44 3399.99 3399.99 1912.154 Silver 3400 44 21.1 Mountain-200 Black, 38 2294.99 2294.99 1251.981 Black 2295 38 23.4 Touring-1000 Yellow, 46 2384.07 2384.07 1481.938 Yellow 2384 46 25.1 Sport-100 Helmet, Blue 34.99 34.99 13.0863 Blue 34.99 NULL NULL Mountain-100 Silver, 44 3399.99 3399.99 1912.154 Silver 3400 44 21.1 Mountain-200 Black, 42 2294.99 2294.99 1251.981 Black 2295 42 23.8 Mountain Bottle Cage 9.99 9.99 9.99 NULL NULL Water Bottle - 30 oz. 4.99 4.99 4.99 NULL NULL 1 1 30 3 37 37 31 21 1 1 30 28 28 21 19 2 28 28 31 1 1 3 31 1 1 28 28 3.7363 NA 1.8663 N P T U M M M T T T S S M M M S M S S R S R S M M T S M M M S V V82 : 4 x fix B c D E 29 11003 Christy NULL Zhu 2/15/1972 30 11003 Christy NULL Zhu 2/15/1972 31 11003 Christy NULL Zhu 2/15/1972 32 11003 Christy NULL Zhu 2/15/1972 33 11003 Christy NULL Zhu 2/15/1972 34 11004 Elizabeth NULL Johnson 8/8/1972 35 11004 Elizabeth NULL Johnson 8/8/1972 36 11004 Elizabeth NULL Johnson 8/8/1972 37 11004 Elizabeth NULL Johnson 8/8/1972 38 11004 Elizabeth NULL Johnson 8/8/1972 39 11004 Elizabeth NULL Johnson 8/8/1972 40 11005 Julio NULL Ruiz 8/5/1969 41 11005 Julio NULL Ruiz 8/5/1969 42 11005 Julio NULL Ruiz 8/5/1969 43 11005 Julio NULL Ruiz 8/5/1969 44 11005 Julio NULL Ruiz 8/5/1969 45 11005 Julio NULL Ruiz 8/5/1969 46 11006 Janet G Alvarez 12/6/1969 47 11006 Janet G Alvarez 12/6/1969 48 11006 Janet G Alvarez 12/6/1969 Alvarez 12/6/1969 49 11006 Janet G 50 11006 Janet G Alvarez 12/6/1969 51 11007 Marco NULL Mehta 5/9/1968 52 11007 Marco NULL Mehta 5/9/1968 53 11007 Marco NULL Mehta 5/9/1968 11007 Marco NULL Mehta 5/9/1968 11007 Marco NULL Mehta 5/9/1968 11007 Marco NULL Mehta 5/9/1968 Business 54 55 56 G H 82 Brickyard St. (500)444-063 SO51315 20070709 82 Brickyard St. (500)444-063 SO57783 20071111 82 Brickyard St. (500)444-06: SO57783 20071111 82 Brickyard St. (500)444-06: SO57783 20071111 82 Brickyard St. (500)444-06 SO57783 20071111 875 N. Harrison Ave. (500)444-064 SO43810 20050726 875 N. Harrison Ave. (500)444-064 SO51595 20070726 875 N. Harrison Ave. (500)444-064 SO51595 20070726 875 N. Harrison Ave. (500)444-064 SO51595 20070726 875 N. Harrison Ave. (500)444-064 SO57293 20071102 875 N. Harrison Ave. (500)444-064 SO57293 20071102 8488 Cemetery Dr. (500)444-065 SO43704 20050702 8488 Cemetery Dr. (500)444-065 SO51612 20070727 8488 Cemetery Dr. (500)444-065 SO51612 20070727 8488 Cemetery Dr. (500)444-065 SO51612 20070727 8488 Cemetery Dr. (500)444-065 SO51612 20070727 8488 Cemetery Dr. (500)444-065 SO57361 20071103 7 Columbia St. (500)444-065 SO43819 20050727 7 Columbia St. (500)444-065 SO51198 20070702 (500)444-065 SO51198 20070702 (500)444-065 SO51198 20070702 (500)444-065 SO58007 20071115 (500)444-06 SO43743 20050712 (500)444-06 SO51581 20070725 (500)444-06 SO51581 20070725 (500)444-06 SO51581 20070725 (500)444-06 SO51581 20070725 (500)444-06 SO51581 20070725 7 Columbia St. 7 Columbia St. 7 Columbia St. 250 Kingston Lane 250 Kingston Lane 250 Kingston Lane 250 Kingston Lane 250 Kingston Lane 250 Kingston Lane J 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 K AWC-LC T1000-Y60 TT0001 TT001-T Patch8 M100-S42 M200-S42 FSM SPH100-R T1000-Y50 SPH100-B M100-848 M200-S42 HLMTire MTT Patch8 T1000-Y50 M100-$44 M200-$46 MBC WB-30 T1000-Y50 M100-$48 M200-842 MTT HLMTire FSM SPH100-BL M 8.99 N 8.99 AWC Logo Cap Touring-1000 Yellow, 60 2384.07 2384.07 Touring Tire 28.99 28.99 Touring Tire Tube 4.99 4.99 Patch Kit/8 Patches 2.29 2.29 Mountain-100 Silver, 42 3399.99 3399.99 Mountain-200 Silver, 42 2319.99 2319.99 Fender Set-Mountain 21.98 21.98 Sport-100 Helmet, Red 34.99 34.99 Touring-1000 Yellow, 50 2384.07 2384.07 Sport-100 Helmet, Black 34.99 34.99 Mountain-100 Black, 48 3374.99 3374.99 i Mountain-200 Silver, 42 2319.99 2319.99 HL Mountain Tire 35 35 Mountain Tire Tube 4.99 4.99 Patch Kit/8 Patches 2.29 2.29 Touring-1000 Yellow, 50 2384.07 2384.07 Mountain-100 Silver, 44 3399.99 3399.99 Mountain-200 Silver, 46 2319.99 2319.99 Mountain Bottle Cage 9.99 9.99 I Water Bottle - 30 oz. 4.99 4.99 Touring-1000 Yellow, 50 2384.07 2384.07 Mountain-100 Silver, 48 3399.99 3399.99 Mountain-200 Black, 42 2294.99 2294.99 Mountain Tire Tube 4.99 4.99 HL Mountain Tire 35 35 Fender Set-Mountain 21.98 21.98 Sport-100 Helmet, Blue 34.99 34.99 0 19 3 37 37 37 1 1 30 31 3 31 1 1 37 37 37 3 1 1 28 28 3 1 1 37 37 30 31 P Q R ST 6.9223 Multi 8.99 NULL NULL 1481.938 Yellow 2384 60 25.9 10.8423 28.99 NULL NULL 1.8663 4.99 NULL NULL 0.8565 2.29 NULL NULL 1912.154 Silver 3400 42 20.8 1265.62 Silver 2320 42 23.8 8.2205 21.98 NULL NULL 13.0863 Red 34.99 NULL NULL 1481.938 Yellow 2384 50 25.4 13.0863 Black 34.99 NULL NULL 1898.094 | Black 3375 48 21.4 1265.62 Silver 2320 42 23.8 13.09 NA 35 NULL NULL 1.8663 4.99 NULL NULL 0.8565 NA 2.29 NULL NULL 1481.938 Yellow 2384 50 25.4 1912.154 Silver 3400 44 21.1 1265.62 Silver 2320 46 24.1 3.7363 9.99 NULL NULL 1.8663 4.99 NULL NULL 1481.938 Yellow 2384 50 25.4 1912.154 Silver 3400 48 21.4 1251.981 Black 2295 42 23.8 1.8663 NA 4.99 NULL NULL 13.09 35 NULL NULL 8.2205 21.98 NULL NULL 13.0863 Blue 34.99 NULL NULL U S T T T S M M M S T S M M M M S T M M M S T M M M M M S V V82 Xx 4 fx A B D E G H I 20070725 20070920 56 11007 Marco NULL Mehta 57 11007 Marco 58 11007 Marco 59 11008 Rob 60 11008 Rob Rob 61 11008 62 11008 Rob 63 11008 Rob 64 11008 Rob 65 11008 Rob 66 11009 Shannon 67 11009 Shannon 68 69 5/9/1968 250 Kingston Lane (500)444-06 SO51581 NULL Mehta 5/9/1968 250 Kingston Lane (500)444-06 SO54705 NULL Mehta 5/9/1968 250 Kingston Lane (500)444-06 SO54705 20070920 NULL Verhoff 7/7/1968 8644 Harvey Ave. (500)444-06 SO43826 20050728 NULL Verhoff 7/7/1968 8644 Harvey Ave. (500)444-06 SO51282 20070707 NULL Verhoff 7/7/1968 8644 Harvey Ave. (500)444-066 SO51282 20070707 NULL Verhoff 7/7/1968 8644 Harvey Ave. (500)444-066 SO51282 20070707 NULL Verhoff 7/7/1968 8644 Harvey Ave. 1500)444-066 SO51282 20070707 NULL Verhoff 7/7/1968 8644 Harvey Ave. (500)444-06 SO53765 20070903 NULL Verhoff 7/7/1968 8644 Harvey Ave. (500)444-066 SO53765 20070903 C Carlson 4/1/1968 21 Alderwood Ave. (500)444-067 SO43837 20050730 Carlson 4/1/1968 21 Alderwood Ave. (500)444-067 SO51562 20070724 11009 Shannon Carlson 4/1/1968 21 Alderwood Ave. (500)444-067 SO51562 20070724 Carlson 4/1/1968 21 Alderwood Ave. (500)444-067 SO57736 20071110 Carlson 4/1/1968 21 Alderwood Ave. (500)444-067 SO57736 20071110 Suarez 2/6/1968 886 Highland Circle (500)444-068 SO43765 20050717 Suarez 2/6/1968 886 Highland Circle (500)444-068 SO51421 20070715 Suarez 2/6/1968 886 Highland Circle (500)444-068 SO58533 20071124 Suarez 2/6/1968 886 Highland Circle (500)444-068 SO58533 20071124 Lu 11/4/1967 2 Magnolia Street (500)444-068 SO43705 20050702 Lu 11/4/1967 2 Magnolia Street (500)444-068 SO51650 20070729 Lu 11/4/1967 2 Magnolia Street (500)444-068 SO54706 20070920 Lu 11/4/1967 2 Magnolia Street (500)444-068 SO54706 20070920 Walker 1/18/1972 12 NW. Bay Meadows Av(500)444-068 SO54508 20070917 Walker 1/18/1972 12 NW. Bay Meadows Av(500)444-068 SO54508 20070917 Walker 1/18/1972 12 NW. Bay Meadows Av(500)444-068 SO54508 20070917 Walker 1/18/1972 12 NW. Bay Meadows Av (500)444-068 SO68413 20080417 Walli 1/20/1075 11009 Shannon C 70 11009 Shannon 71 11010 lacquelyr 72 11010 lacquelyr 74 11010 Jacquelyr 73 11010 Jacquelyr 75 11011 Curtis NULL 76 11011 Curtis NULL 77 11011 Curtis NULL 78 11011 Curtis NULL 79 11012 Lauren M 80 11012 Lauren M 81 11012 Lauren M 82 11012 Lauren M 4/40/4070 in Mer notandawa sulcool.or 20000417 Business Ready Accessibility: Good to go + COCO443 J 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 M N SPH100-BL Sport-100 Helmet, Blue 34.99 34.99 T1000-Y60 Touring-1000 Yellow, 60 2384.07 2384.07 SPH100-R Sport-100 Helmet, Red 34.99 34.99 M100-838 Mountain-100 Black, 38 3374.99 3374.99 M200-842 Mountain-200 Black, 42 2294.99 2294.99 WB-30 Water Bottle - 30 oz. 4.99 4.99 MBC Mountain Bottle Cage 9.99 9.99 Patch8 Patch Kit/8 Patches 2.29 2.29 T1000-Y46 Touring-1000 Yellow, 46 2384.07 2384.07 SPH100-R Sport-100 Helmet, Red 34.99 34.99 M100-B44 Mountain-100 Black, 44 3374.99 3374.99 M200-838 Mountain-200 Black, 38 2294.99 2294.99 Patch8 Patch Kit/8 Patches 2.29 2.29 T1000-854 Touring-1000 Blue, 54 2384.07 2384.07 Sport-100 Sport-100 Helmet, Black 34.99 34.99 Mountain-100 Mountain-100 Silver, 44 3399.99 3399.99 Mountain-200 Mountain-200 Black, 42 2294.99 2294.99 Touring-1000 Touring-1000 Blue, 54 2384.07 2384.07 Cycling Cap AWC Logo Cap 8.99 8.99 Mountain-100 Mountain-100 Silver, 38 3399.99 3399.99 Mountain-200 Mountain-200 Black, 42 2294.99 2294.99 Touring-1000 Touring-1000 Blue, 50 2384.07 2384.07 ort-Sleeve Classic Jers/ort-Sleeve Classic Jersey, 53.99 53.99 HL Mountain Tire 35 Mountain Tire Tube 4.99 Sport-100 Helmet, Black 34.99 Road Tire Tube 3.99 ----- . - ------- HL Mountain Tire! Mountain Tire Tube Sport-100 35 4.99 34.99 3.99 Road Tire Tube 0 31 3 31 1 1 28 28 37 3 31 1 1 37 3 31 1 1 3 19 1 1 3 21 37 37 31 37 37 P Q R 13.0863 Blue 34.99 NULL NULL 1481.938 Yellow 2384 60 25.9 13.0863 Red 34.99 NULL NULL 1898.094 Black 3375 38 20.4 1251.981 Black 2295 42 23.8 1.8663 NA 4.99 NULL NULL 3.7363 NA 9.99 NULL NULL 0.8565 2.29 NULL NULL 1481.938 Yellow 2384 46 25.1 13.0863 Red Red 34.99 NULL NULL 1898.094 Black 3375 44 21.1 1251.981 Black 2295 38 23.4 0.8565 NA 2.29 NULL NULL 1481.938 Blue 2384 54 25.7 13.0863 iBlack 34.99 NULL NULL 1912.154 Silver 3400 44 21.1 1251.981 Black 2295 42 23.8 1481.938 Blue 2384 54 25.7 6.9223 Multi 8.99 NULL NULL 1912.154 Silver 3400 38 20.4 1251.981 Black 2295 42 23.8 1481.938 Blue 2384 50 25.4 41.5723 Yellow 53.99 M NULL 13.09 35 NULL NULL 1.8663 NA 4.99 NULL NULL 13.0863 Black 34.99 NULL NULL 1.4923 NA 3.99 NULL NULL Locer 13.30 KULL MOLL MA ST B + U S T S M M S M S T S M M S T S M M T S 2 M M T S M M S R V + 60% V82 A B D E F G H 74 11010 lacquelyr 886 Highland Circle (500)444-068 5058533 200/1124 11011 Curtis NULL 75 76 11011 Curtis NULL 77 11011 Curtis NULL 80 11012 Lauren 78 11011 Curtis NULL 79 11012 Lauren M M M M M M M M M 81 11012 Lauren 11012 82 Lauren 83 11012 Lauren 84 11013 lan 85 11013 lan 86 11013 lan 87 11013 lan Suarez 2/6/1968 Lu 11/4/1967 2 Magnolia Street (500)444-068 SO43705 20050702 Lu 11/4/1967 2 Magnolia Street (500)444-068 SO51650 20070729 Lu 11/4/1967 2 Magnolia Street (500)444-068 SO54706 20070920 Lu 11/4/1967 2 Magnolia Street (500)444-068 SO54706 20070920 Walker 1/18/1972 12 NW. Bay Meadows Av (500)444-068 SO54508 20070917 Walker 1/18/1972 12 NW. Bay Meadows Av(500)444-068 SO54508 20070917 Walker 1/18/1972 12 NW. Bay Meadows Av (500)444-068 SO54508 20070917 SO68413 Walker 1/18/1972 12 NW. Bay Meadows Av(500)444-068 20080417 Walker 1/18/1972 12 NW. Bay Meadows Av(500)444-068 SO68413 20080417 Jenkins 8/6/1972 929 S. Amerige St. (500)444-065 SO56137 20071015 Jenkins 8/6/1972 929 S. Amerige St. (500)444-065 SO56137 20071015 Jenkins 8/6/1972 (500)444-065 SO74908 20080724 Jenkins 8/6/1972 (500)444-065 SO74908 20080724 Jenkins 8/6/1972 (500)444-069 SO74908 20080724 Bennett 5/9/1972 (500)444-065 SO54898 20070924 Bennett 5/9/1972 (500)444-065 SO54898 20070924 Bennett 5/9/1972 (500)444-065 SO57222 20071101 Bennett 5/9/1972 (500)444-065 SO57222 20071101 Bennett 5/9/1972 (500)444-069 SO57222 20071101 Bennett 5/9/1972 (500)444-065 SO57222 20071101 Young 2/27/1983 (500)444-070 SO51520 20070722 Young 2/27/1983 (500)444-070 SO51520 20070722 Young 2/27/1983 (500)444-070 SO51520 20070722 Hill 4/28/1983 (500)444-070 SO52512 20070813 Hill 4/28/1983 (500)444-070 SO52512 20070813 Hill 4/28/1983 (500)444-070 SO52512 20070813 11017 Shannon NULL Wang 6/26/1948 (500)444-071 SO43757 20050715 lan M 88 11013 89 11014 Sydney NULL 90 11014 Sydney NULL 91 11014 Sydney NULL 92 11014 Sydney NULL 93 11014 Sydney NULL NULL NULL NULL NULL L 929 S. Amerige St. 929 S. Amerige St. 929 S. Amerige St. 7087 Thatcher Rd. 7087 Thatcher Rd. 7087 Thatcher Rd. 7087 Thatcher Rd. 7087 Thatcher Rd. 7087 Thatcher Rd. 911 Sheffield Drive 911 Sheffield Drive 911 Sheffield Drive 8644 Harvey Ave. 8644 Harvey Ave. 8644 Harvey Ave. 21 West Lane 94 11014 Sydney 11015 Chloe 11015 Chloe 95 96 97 11015 Chloe 98 11016 Wyatt 99 11016 Wyatt L 11016 Wyatt L 100 101 Business + Accessibility: Good to go Ready x fxx J 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 N M Cycling Cap AWC Logo Cap 8.99 8.99 Mountain-100 Mountain-100 Silver, 38 3399.99 3399.99 Mountain-200 Mountain-200 Black, 42 2294.99 2294.99 Touring-1000 Touring-1000 Blue, 50 2384.07 2384.07 ort-Sleeve Classic Jers/ort-Sleeve Classic Jersey, 53.99 53.99 HL Mountain Tire 35 35 Mountain Tire Tube 4.99 4.99 Sport-100 Helmet, Black 34.99 34.99 Road Tire Tube 3.99 3.99 Patch Kit/8 Patches 2.29 2.29 Road Tire Tube 3.99 3.99 Sport-100 Helmet, Black 34.99 34.99 HL Mountain Tire 35 35 Mountain Tire Tube 4.99 4.99 Sport-100 Helmet, Blue 34.99 34.99 Road Tire Tube 3.99 3.99 Sport-100 Helmet, Black 34.99 34.99 HL Mountain Tire HL Mountain Tire 35 35 Mountain Tire Tube Mountain Tire Tube 4.99 4.99 Sport-100 Sport-100 Helmet, Black 34.99 34.99 Half-Finger Gloves Half-Finger Gloves, M 24.49 24.49 Mountain-200 Mountain-200 Silver, 38 2319.99 2319.99 Fender Set - Mountain Fender Set - Mountain 21.98 21.98 All-Purpose Bike Standi All-Purpose Bike Stand 159 159 Mountain-200 Mountain-200 Black, 46 2294.99 2294.99 HL Mountain Tire HL Mountain Tire 35 35 Patch kit Patch Kit/8 Patches 2.29 2.29 Mountain-100 Mountain-100 Black, 44 3374.99 3374.99 HL Mountain Tire Mountain Tire Tube Sport-100 Road Tire Tube Patch kit Road Tire Tube Sport-100 HL Mountain Tire Mountain Tire Tube Sport-100 Road Tire Tube Sport-100 0 19 1 1 3 21 37 37 31 37 37 37 31 37 37 31 37 31 37 37 31 20 1 30 27 1 37 37 1 P Q R T 6.9223 Multi 8.99 NULL NULL 1912.154 Silver 3400 38 20.4 1251.981 Black 2295 42 23.8 1481.938 Blue 2384 50 25.4 41.5723 Yellow 53.99 M NULL 13.09 35 NULL NULL 1.8663 NA 4.99 NULL NULL 13.0863 Black 34.99 NULL NULL 1.4923 3.99 NULL NULL 0.8565 NA 2.29 NULL NULL 1.4923 3.99 NULL NULL 13.0863 Black 34.99 NULL NULL 13.09 35 NULL NULL 1.8663 NA 4.99 NULL NULL 13.0863 Blue 34.99 NULL NULL 1.4923 3.99 NULL NULL 13.0863 Black 34.99 NULL NULL 13.09 35 NULL NULL 1.8663 4.99 NULL NULL 13.0863 Black 34.99 NULL NULL 9.1593 Black 24.49 M NULL 1265.62 Silver 2320 38 23.4 8.2205 NA 21.98 NULL NULL 59.466 159 NULL NULL 1251.981 Black 2295 46 24.1 13.09 35 NULL NULL 0.8565 2.29 NULL NULL 1898.094 Black 3375 44 21.1 B | U S M M T S M M S R S R S M M S R S M M S S M M M M M S M V ------ + 60% "Your Business" is a spreadsheet from a poorly organized database/business. (See Excel File) You are a database consultant hired to review their data and create a new database. Write your answer in the provided space for each question and save it as a PDF file. Then submit one PDF file only. 1. Find all the dependencies: Solution: 2. Normalize to 2NF. Give each table a name and list the attributes in each table. Provide structural answers only in DBDL showing functionalities and tables. Solution: 3. Specify primary and foreign keys for each table (Tables that are in 3NF). Provide structural answers only in DBDL showing functionalities and tables. Solution: 4. Write a set of business rules to go along with your normalized tables Solution: Do not include the data. The data is provided for your reference. You may have to reuse attributes, but do not create any additional fields. V82 C D 1 Customerll'irstNam MiddleNam astNam 2 11000 V 3 11000 V V A B Jon Jon 4 11000 Jon 5 11000 Jon 6 11000 Jon 7 11000 Jon 8 11000 Jon 11000 Jon 10 11001 Eugene 9 11 11001 Eugene 21 22 23 V V V V V I L L 12 11001 Eugene 13 11001 Eugene 14 11001 Eugene 15 11001 Eugene L 16 11001 Eugene L 11001 Eugene 18 11001 Eugene 17 L L 11001 Eugene L 20 11001 Eugene L 19 11002 Ruben NULL 11002 Ruben NULL 11002 Ruben NULL 24 11002 Ruben NULL 25 11003 Christy NULL 11003 Christy NULL 11003 Christy NULL 11003 Christy NULL 26 27 28 L L fxx E BirthDate Address Phone alesOrderNumb OrderDate)rderQuantit Yang 4/8/1970 2 NW. Bay Meadows Av (500)444-061 SO43793 20050722 Yang 4/8/1970 2 NW. Bay Meadows Av(500)444-061 SO51522 20070722 Yang 4/8/1970 2 NW. Bay Meadows Av (500)444-061 SO51522 20070722 Yang 4/8/1970 2 NW. Bay Meadows Av/500)444-061 SO57418 20071104 Yang 4/8/1970 2 NW. Bay Meadows Av(500)444-061 SO57418 20071104 Yang 4/8/1970 12 NW. Bay Meadows Av(500)444-061 SO57418 20071104 Yang 4/8/1970 12 NW. Bay Meadows Av(500)444-061 SO57418 20071104 Yang 4/8/1970 2 NW. Bay Meadows Av(500)444-061 SO57418 20071104 Huang 5/14/1969 805 Court Court (500)444-062 SO43767 20050718 Huang 5/14/1969 805 Court Court (500)444-062 SO51493 20070720 Huang 5/14/1969 805 Court Court (500)444-062 SO51493 20070720 Huang 5/14/1969 805 Court Court (500)444-062 SO51493 20070720 Huang 5/14/1969 805 Court Court (500)444-062 SO51493 20070720 Huang 5/14/1969 805 Court Court (500)444-062 SO51493 20070720 Huang 5/14/1969 805 Court Court (500)444-062 SO51493 20070720 Huang 5/14/1969 805 Court Court (500)444-062 SO72773 20080612 Huang 5/14/1969 805 Court Court (500)444-062 SO72773 20080612 Huang 5/14/1969 805 Court Court (500)444-062 SO72773 20080612 Huang 5/14/1969 805 Court Court (500)444-062 SO72773 20080612 Torres 8/12/1969 297 S. Lafayette Dr. (500)444-062 SO43736 20050710 Torres 8/12/1969 297 S. Lafayette Dr. (500)444-062 SO51238 20070704 Torres 8/12/1969 297 S. Lafayette Dr. (500)444-062 SO53237 20070827 Torres 8/12/1969 297 S. Lafayette Dr. (500)444-062 SO53237 20070827 Zhu 2/15/1972 82 Brickyard St. (500)444-06: SO43701 20050701 Zhu 2/15/1972 82 Brickyard St. (500)444-06: SO51315 20070709 Zhu 2/15/1972 82 Brickyard St. (500)444-06: SO51315 20070709 Zhu 2/15/1972 82 Brickyard St. (500)444-063 SO51315 20070709 I J 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 K ProductNum M100-$38 M200-$38 FSM T1000-846 TTO01 TT001-T SPH100-R SSClassic-S M100-844 M200-$38 FSM WB-30 MBC Ssclassic-XL AWC-LC R750-844 WB-30 RBC SPH100-B M100-$44 M200-838 T1000-Y46 SPH100-BL M100-$44 M200-842 MBC WB-30 M 0 ProductName UnitPrice alesAmouroductSubcategoryktandardCo ColoristPric Size VeightroductLine Mountain-100 Silver, 38 3399.99 3399.99 1912.154 Silver 3400 38 20.4 Mountain-200 Silver, 38 2319.99 2319.99 1265.62 Silver 2320 38 23.4 Fender Set - Mountain 21.98 21.98 8.2205 NA 21.98 NULL NULL Touring-1000 Blue, 46 2384.07 2384.07 1481.938 Blue 2384 46 25.1 Touring Tire 28.99 28.99 10.8423 NA 28.99 NULL NULL Touring Tire Tube 4.99 4.99 1.8663 4.99 NULL NULL !Sport-100 Helmet, Red 34.99 34.99 13.0863 Red 34.99 NULL NULL nort-Sleeve Classic Jersey 53.99 53.99 41.5723 Yellow 53.99 S NULL Mountain-100 Black, 44 3374.99 3374.99 1898.094 Black 3375 44 21.1 Mountain-200 Silver, 38 2319.99 2319.99 1265.62 Silver 2320 38 23.4 Fender Set - Mountain 21.98 21.98 8.2205 I NA 21.98 NULL NULL Water Bottle - 30 oz. 4.99 4.99 1.8663 4.99 NULL NULL Mountain Bottle Cage 9.99 9.99 3.7363 9.99 NULL NULL ort-Sleeve Classic Jersey, 53.99 53.99 41.5723 Yellow 53.99 XL NULL AWC Logo Cap 8.99 8.99 6.9223 Multi 8.99 NULL NULL Road-750 Black, 44 539.99 539.99 343.6496 Black 540 44 19.8 Water Bottle - 30 oz. 4.99 4.99 1.8663 4.99 NULL NULL Road Bottle Cage 8.99 8.99 3.3623 8.99 NULL NULL Sport-100 Helmet, Black 34.99 34.99 13.0863 Black 34.99 NULL NULL Mountain-100 Silver, 44 3399.99 3399.99 1912.154 Silver 3400 44 21.1 Mountain-200 Black, 38 2294.99 2294.99 1251.981 Black 2295 38 23.4 Touring-1000 Yellow, 46 2384.07 2384.07 1481.938 Yellow 2384 46 25.1 Sport-100 Helmet, Blue 34.99 34.99 13.0863 Blue 34.99 NULL NULL Mountain-100 Silver, 44 3399.99 3399.99 1912.154 Silver 3400 44 21.1 Mountain-200 Black, 42 2294.99 2294.99 1251.981 Black 2295 42 23.8 Mountain Bottle Cage 9.99 9.99 9.99 NULL NULL Water Bottle - 30 oz. 4.99 4.99 4.99 NULL NULL 1 1 30 3 37 37 31 21 1 1 30 28 28 21 19 2 28 28 31 1 1 3 31 1 1 28 28 3.7363 NA 1.8663 N P T U M M M T T T S S M M M S M S S R S R S M M T S M M M S V V82 : 4 x fix B c D E 29 11003 Christy NULL Zhu 2/15/1972 30 11003 Christy NULL Zhu 2/15/1972 31 11003 Christy NULL Zhu 2/15/1972 32 11003 Christy NULL Zhu 2/15/1972 33 11003 Christy NULL Zhu 2/15/1972 34 11004 Elizabeth NULL Johnson 8/8/1972 35 11004 Elizabeth NULL Johnson 8/8/1972 36 11004 Elizabeth NULL Johnson 8/8/1972 37 11004 Elizabeth NULL Johnson 8/8/1972 38 11004 Elizabeth NULL Johnson 8/8/1972 39 11004 Elizabeth NULL Johnson 8/8/1972 40 11005 Julio NULL Ruiz 8/5/1969 41 11005 Julio NULL Ruiz 8/5/1969 42 11005 Julio NULL Ruiz 8/5/1969 43 11005 Julio NULL Ruiz 8/5/1969 44 11005 Julio NULL Ruiz 8/5/1969 45 11005 Julio NULL Ruiz 8/5/1969 46 11006 Janet G Alvarez 12/6/1969 47 11006 Janet G Alvarez 12/6/1969 48 11006 Janet G Alvarez 12/6/1969 Alvarez 12/6/1969 49 11006 Janet G 50 11006 Janet G Alvarez 12/6/1969 51 11007 Marco NULL Mehta 5/9/1968 52 11007 Marco NULL Mehta 5/9/1968 53 11007 Marco NULL Mehta 5/9/1968 11007 Marco NULL Mehta 5/9/1968 11007 Marco NULL Mehta 5/9/1968 11007 Marco NULL Mehta 5/9/1968 Business 54 55 56 G H 82 Brickyard St. (500)444-063 SO51315 20070709 82 Brickyard St. (500)444-063 SO57783 20071111 82 Brickyard St. (500)444-06: SO57783 20071111 82 Brickyard St. (500)444-06: SO57783 20071111 82 Brickyard St. (500)444-06 SO57783 20071111 875 N. Harrison Ave. (500)444-064 SO43810 20050726 875 N. Harrison Ave. (500)444-064 SO51595 20070726 875 N. Harrison Ave. (500)444-064 SO51595 20070726 875 N. Harrison Ave. (500)444-064 SO51595 20070726 875 N. Harrison Ave. (500)444-064 SO57293 20071102 875 N. Harrison Ave. (500)444-064 SO57293 20071102 8488 Cemetery Dr. (500)444-065 SO43704 20050702 8488 Cemetery Dr. (500)444-065 SO51612 20070727 8488 Cemetery Dr. (500)444-065 SO51612 20070727 8488 Cemetery Dr. (500)444-065 SO51612 20070727 8488 Cemetery Dr. (500)444-065 SO51612 20070727 8488 Cemetery Dr. (500)444-065 SO57361 20071103 7 Columbia St. (500)444-065 SO43819 20050727 7 Columbia St. (500)444-065 SO51198 20070702 (500)444-065 SO51198 20070702 (500)444-065 SO51198 20070702 (500)444-065 SO58007 20071115 (500)444-06 SO43743 20050712 (500)444-06 SO51581 20070725 (500)444-06 SO51581 20070725 (500)444-06 SO51581 20070725 (500)444-06 SO51581 20070725 (500)444-06 SO51581 20070725 7 Columbia St. 7 Columbia St. 7 Columbia St. 250 Kingston Lane 250 Kingston Lane 250 Kingston Lane 250 Kingston Lane 250 Kingston Lane 250 Kingston Lane J 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 K AWC-LC T1000-Y60 TT0001 TT001-T Patch8 M100-S42 M200-S42 FSM SPH100-R T1000-Y50 SPH100-B M100-848 M200-S42 HLMTire MTT Patch8 T1000-Y50 M100-$44 M200-$46 MBC WB-30 T1000-Y50 M100-$48 M200-842 MTT HLMTire FSM SPH100-BL M 8.99 N 8.99 AWC Logo Cap Touring-1000 Yellow, 60 2384.07 2384.07 Touring Tire 28.99 28.99 Touring Tire Tube 4.99 4.99 Patch Kit/8 Patches 2.29 2.29 Mountain-100 Silver, 42 3399.99 3399.99 Mountain-200 Silver, 42 2319.99 2319.99 Fender Set-Mountain 21.98 21.98 Sport-100 Helmet, Red 34.99 34.99 Touring-1000 Yellow, 50 2384.07 2384.07 Sport-100 Helmet, Black 34.99 34.99 Mountain-100 Black, 48 3374.99 3374.99 i Mountain-200 Silver, 42 2319.99 2319.99 HL Mountain Tire 35 35 Mountain Tire Tube 4.99 4.99 Patch Kit/8 Patches 2.29 2.29 Touring-1000 Yellow, 50 2384.07 2384.07 Mountain-100 Silver, 44 3399.99 3399.99 Mountain-200 Silver, 46 2319.99 2319.99 Mountain Bottle Cage 9.99 9.99 I Water Bottle - 30 oz. 4.99 4.99 Touring-1000 Yellow, 50 2384.07 2384.07 Mountain-100 Silver, 48 3399.99 3399.99 Mountain-200 Black, 42 2294.99 2294.99 Mountain Tire Tube 4.99 4.99 HL Mountain Tire 35 35 Fender Set-Mountain 21.98 21.98 Sport-100 Helmet, Blue 34.99 34.99 0 19 3 37 37 37 1 1 30 31 3 31 1 1 37 37 37 3 1 1 28 28 3 1 1 37 37 30 31 P Q R ST 6.9223 Multi 8.99 NULL NULL 1481.938 Yellow 2384 60 25.9 10.8423 28.99 NULL NULL 1.8663 4.99 NULL NULL 0.8565 2.29 NULL NULL 1912.154 Silver 3400 42 20.8 1265.62 Silver 2320 42 23.8 8.2205 21.98 NULL NULL 13.0863 Red 34.99 NULL NULL 1481.938 Yellow 2384 50 25.4 13.0863 Black 34.99 NULL NULL 1898.094 | Black 3375 48 21.4 1265.62 Silver 2320 42 23.8 13.09 NA 35 NULL NULL 1.8663 4.99 NULL NULL 0.8565 NA 2.29 NULL NULL 1481.938 Yellow 2384 50 25.4 1912.154 Silver 3400 44 21.1 1265.62 Silver 2320 46 24.1 3.7363 9.99 NULL NULL 1.8663 4.99 NULL NULL 1481.938 Yellow 2384 50 25.4 1912.154 Silver 3400 48 21.4 1251.981 Black 2295 42 23.8 1.8663 NA 4.99 NULL NULL 13.09 35 NULL NULL 8.2205 21.98 NULL NULL 13.0863 Blue 34.99 NULL NULL U S T T T S M M M S T S M M M M S T M M M S T M M M M M S V V82 Xx 4 fx A B D E G H I 20070725 20070920 56 11007 Marco NULL Mehta 57 11007 Marco 58 11007 Marco 59 11008 Rob 60 11008 Rob Rob 61 11008 62 11008 Rob 63 11008 Rob 64 11008 Rob 65 11008 Rob 66 11009 Shannon 67 11009 Shannon 68 69 5/9/1968 250 Kingston Lane (500)444-06 SO51581 NULL Mehta 5/9/1968 250 Kingston Lane (500)444-06 SO54705 NULL Mehta 5/9/1968 250 Kingston Lane (500)444-06 SO54705 20070920 NULL Verhoff 7/7/1968 8644 Harvey Ave. (500)444-06 SO43826 20050728 NULL Verhoff 7/7/1968 8644 Harvey Ave. (500)444-06 SO51282 20070707 NULL Verhoff 7/7/1968 8644 Harvey Ave. (500)444-066 SO51282 20070707 NULL Verhoff 7/7/1968 8644 Harvey Ave. (500)444-066 SO51282 20070707 NULL Verhoff 7/7/1968 8644 Harvey Ave. 1500)444-066 SO51282 20070707 NULL Verhoff 7/7/1968 8644 Harvey Ave. (500)444-06 SO53765 20070903 NULL Verhoff 7/7/1968 8644 Harvey Ave. (500)444-066 SO53765 20070903 C Carlson 4/1/1968 21 Alderwood Ave. (500)444-067 SO43837 20050730 Carlson 4/1/1968 21 Alderwood Ave. (500)444-067 SO51562 20070724 11009 Shannon Carlson 4/1/1968 21 Alderwood Ave. (500)444-067 SO51562 20070724 Carlson 4/1/1968 21 Alderwood Ave. (500)444-067 SO57736 20071110 Carlson 4/1/1968 21 Alderwood Ave. (500)444-067 SO57736 20071110 Suarez 2/6/1968 886 Highland Circle (500)444-068 SO43765 20050717 Suarez 2/6/1968 886 Highland Circle (500)444-068 SO51421 20070715 Suarez 2/6/1968 886 Highland Circle (500)444-068 SO58533 20071124 Suarez 2/6/1968 886 Highland Circle (500)444-068 SO58533 20071124 Lu 11/4/1967 2 Magnolia Street (500)444-068 SO43705 20050702 Lu 11/4/1967 2 Magnolia Street (500)444-068 SO51650 20070729 Lu 11/4/1967 2 Magnolia Street (500)444-068 SO54706 20070920 Lu 11/4/1967 2 Magnolia Street (500)444-068 SO54706 20070920 Walker 1/18/1972 12 NW. Bay Meadows Av(500)444-068 SO54508 20070917 Walker 1/18/1972 12 NW. Bay Meadows Av(500)444-068 SO54508 20070917 Walker 1/18/1972 12 NW. Bay Meadows Av(500)444-068 SO54508 20070917 Walker 1/18/1972 12 NW. Bay Meadows Av (500)444-068 SO68413 20080417 Walli 1/20/1075 11009 Shannon C 70 11009 Shannon 71 11010 lacquelyr 72 11010 lacquelyr 74 11010 Jacquelyr 73 11010 Jacquelyr 75 11011 Curtis NULL 76 11011 Curtis NULL 77 11011 Curtis NULL 78 11011 Curtis NULL 79 11012 Lauren M 80 11012 Lauren M 81 11012 Lauren M 82 11012 Lauren M 4/40/4070 in Mer notandawa sulcool.or 20000417 Business Ready Accessibility: Good to go + COCO443 J 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 M N SPH100-BL Sport-100 Helmet, Blue 34.99 34.99 T1000-Y60 Touring-1000 Yellow, 60 2384.07 2384.07 SPH100-R Sport-100 Helmet, Red 34.99 34.99 M100-838 Mountain-100 Black, 38 3374.99 3374.99 M200-842 Mountain-200 Black, 42 2294.99 2294.99 WB-30 Water Bottle - 30 oz. 4.99 4.99 MBC Mountain Bottle Cage 9.99 9.99 Patch8 Patch Kit/8 Patches 2.29 2.29 T1000-Y46 Touring-1000 Yellow, 46 2384.07 2384.07 SPH100-R Sport-100 Helmet, Red 34.99 34.99 M100-B44 Mountain-100 Black, 44 3374.99 3374.99 M200-838 Mountain-200 Black, 38 2294.99 2294.99 Patch8 Patch Kit/8 Patches 2.29 2.29 T1000-854 Touring-1000 Blue, 54 2384.07 2384.07 Sport-100 Sport-100 Helmet, Black 34.99 34.99 Mountain-100 Mountain-100 Silver, 44 3399.99 3399.99 Mountain-200 Mountain-200 Black, 42 2294.99 2294.99 Touring-1000 Touring-1000 Blue, 54 2384.07 2384.07 Cycling Cap AWC Logo Cap 8.99 8.99 Mountain-100 Mountain-100 Silver, 38 3399.99 3399.99 Mountain-200 Mountain-200 Black, 42 2294.99 2294.99 Touring-1000 Touring-1000 Blue, 50 2384.07 2384.07 ort-Sleeve Classic Jers/ort-Sleeve Classic Jersey, 53.99 53.99 HL Mountain Tire 35 Mountain Tire Tube 4.99 Sport-100 Helmet, Black 34.99 Road Tire Tube 3.99 ----- . - ------- HL Mountain Tire! Mountain Tire Tube Sport-100 35 4.99 34.99 3.99 Road Tire Tube 0 31 3 31 1 1 28 28 37 3 31 1 1 37 3 31 1 1 3 19 1 1 3 21 37 37 31 37 37 P Q R 13.0863 Blue 34.99 NULL NULL 1481.938 Yellow 2384 60 25.9 13.0863 Red 34.99 NULL NULL 1898.094 Black 3375 38 20.4 1251.981 Black 2295 42 23.8 1.8663 NA 4.99 NULL NULL 3.7363 NA 9.99 NULL NULL 0.8565 2.29 NULL NULL 1481.938 Yellow 2384 46 25.1 13.0863 Red Red 34.99 NULL NULL 1898.094 Black 3375 44 21.1 1251.981 Black 2295 38 23.4 0.8565 NA 2.29 NULL NULL 1481.938 Blue 2384 54 25.7 13.0863 iBlack 34.99 NULL NULL 1912.154 Silver 3400 44 21.1 1251.981 Black 2295 42 23.8 1481.938 Blue 2384 54 25.7 6.9223 Multi 8.99 NULL NULL 1912.154 Silver 3400 38 20.4 1251.981 Black 2295 42 23.8 1481.938 Blue 2384 50 25.4 41.5723 Yellow 53.99 M NULL 13.09 35 NULL NULL 1.8663 NA 4.99 NULL NULL 13.0863 Black 34.99 NULL NULL 1.4923 NA 3.99 NULL NULL Locer 13.30 KULL MOLL MA ST B + U S T S M M S M S T S M M S T S M M T S 2 M M T S M M S R V + 60% V82 A B D E F G H 74 11010 lacquelyr 886 Highland Circle (500)444-068 5058533 200/1124 11011 Curtis NULL 75 76 11011 Curtis NULL 77 11011 Curtis NULL 80 11012 Lauren 78 11011 Curtis NULL 79 11012 Lauren M M M M M M M M M 81 11012 Lauren 11012 82 Lauren 83 11012 Lauren 84 11013 lan 85 11013 lan 86 11013 lan 87 11013 lan Suarez 2/6/1968 Lu 11/4/1967 2 Magnolia Street (500)444-068 SO43705 20050702 Lu 11/4/1967 2 Magnolia Street (500)444-068 SO51650 20070729 Lu 11/4/1967 2 Magnolia Street (500)444-068 SO54706 20070920 Lu 11/4/1967 2 Magnolia Street (500)444-068 SO54706 20070920 Walker 1/18/1972 12 NW. Bay Meadows Av (500)444-068 SO54508 20070917 Walker 1/18/1972 12 NW. Bay Meadows Av(500)444-068 SO54508 20070917 Walker 1/18/1972 12 NW. Bay Meadows Av (500)444-068 SO54508 20070917 SO68413 Walker 1/18/1972 12 NW. Bay Meadows Av(500)444-068 20080417 Walker 1/18/1972 12 NW. Bay Meadows Av(500)444-068 SO68413 20080417 Jenkins 8/6/1972 929 S. Amerige St. (500)444-065 SO56137 20071015 Jenkins 8/6/1972 929 S. Amerige St. (500)444-065 SO56137 20071015 Jenkins 8/6/1972 (500)444-065 SO74908 20080724 Jenkins 8/6/1972 (500)444-065 SO74908 20080724 Jenkins 8/6/1972 (500)444-069 SO74908 20080724 Bennett 5/9/1972 (500)444-065 SO54898 20070924 Bennett 5/9/1972 (500)444-065 SO54898 20070924 Bennett 5/9/1972 (500)444-065 SO57222 20071101 Bennett 5/9/1972 (500)444-065 SO57222 20071101 Bennett 5/9/1972 (500)444-069 SO57222 20071101 Bennett 5/9/1972 (500)444-065 SO57222 20071101 Young 2/27/1983 (500)444-070 SO51520 20070722 Young 2/27/1983 (500)444-070 SO51520 20070722 Young 2/27/1983 (500)444-070 SO51520 20070722 Hill 4/28/1983 (500)444-070 SO52512 20070813 Hill 4/28/1983 (500)444-070 SO52512 20070813 Hill 4/28/1983 (500)444-070 SO52512 20070813 11017 Shannon NULL Wang 6/26/1948 (500)444-071 SO43757 20050715 lan M 88 11013 89 11014 Sydney NULL 90 11014 Sydney NULL 91 11014 Sydney NULL 92 11014 Sydney NULL 93 11014 Sydney NULL NULL NULL NULL NULL L 929 S. Amerige St. 929 S. Amerige St. 929 S. Amerige St. 7087 Thatcher Rd. 7087 Thatcher Rd. 7087 Thatcher Rd. 7087 Thatcher Rd. 7087 Thatcher Rd. 7087 Thatcher Rd. 911 Sheffield Drive 911 Sheffield Drive 911 Sheffield Drive 8644 Harvey Ave. 8644 Harvey Ave. 8644 Harvey Ave. 21 West Lane 94 11014 Sydney 11015 Chloe 11015 Chloe 95 96 97 11015 Chloe 98 11016 Wyatt 99 11016 Wyatt L 11016 Wyatt L 100 101 Business + Accessibility: Good to go Ready x fxx J 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 N M Cycling Cap AWC Logo Cap 8.99 8.99 Mountain-100 Mountain-100 Silver, 38 3399.99 3399.99 Mountain-200 Mountain-200 Black, 42 2294.99 2294.99 Touring-1000 Touring-1000 Blue, 50 2384.07 2384.07 ort-Sleeve Classic Jers/ort-Sleeve Classic Jersey, 53.99 53.99 HL Mountain Tire 35 35 Mountain Tire Tube 4.99 4.99 Sport-100 Helmet, Black 34.99 34.99 Road Tire Tube 3.99 3.99 Patch Kit/8 Patches 2.29 2.29 Road Tire Tube 3.99 3.99 Sport-100 Helmet, Black 34.99 34.99 HL Mountain Tire 35 35 Mountain Tire Tube 4.99 4.99 Sport-100 Helmet, Blue 34.99 34.99 Road Tire Tube 3.99 3.99 Sport-100 Helmet, Black 34.99 34.99 HL Mountain Tire HL Mountain Tire 35 35 Mountain Tire Tube Mountain Tire Tube 4.99 4.99 Sport-100 Sport-100 Helmet, Black 34.99 34.99 Half-Finger Gloves Half-Finger Gloves, M 24.49 24.49 Mountain-200 Mountain-200 Silver, 38 2319.99 2319.99 Fender Set - Mountain Fender Set - Mountain 21.98 21.98 All-Purpose Bike Standi All-Purpose Bike Stand 159 159 Mountain-200 Mountain-200 Black, 46 2294.99 2294.99 HL Mountain Tire HL Mountain Tire 35 35 Patch kit Patch Kit/8 Patches 2.29 2.29 Mountain-100 Mountain-100 Black, 44 3374.99 3374.99 HL Mountain Tire Mountain Tire Tube Sport-100 Road Tire Tube Patch kit Road Tire Tube Sport-100 HL Mountain Tire Mountain Tire Tube Sport-100 Road Tire Tube Sport-100 0 19 1 1 3 21 37 37 31 37 37 37 31 37 37 31 37 31 37 37 31 20 1 30 27 1 37 37 1 P Q R T 6.9223 Multi 8.99 NULL NULL 1912.154 Silver 3400 38 20.4 1251.981 Black 2295 42 23.8 1481.938 Blue 2384 50 25.4 41.5723 Yellow 53.99 M NULL 13.09 35 NULL NULL 1.8663 NA 4.99 NULL NULL 13.0863 Black 34.99 NULL NULL 1.4923 3.99 NULL NULL 0.8565 NA 2.29 NULL NULL 1.4923 3.99 NULL NULL 13.0863 Black 34.99 NULL NULL 13.09 35 NULL NULL 1.8663 NA 4.99 NULL NULL 13.0863 Blue 34.99 NULL NULL 1.4923 3.99 NULL NULL 13.0863 Black 34.99 NULL NULL 13.09 35 NULL NULL 1.8663 4.99 NULL NULL 13.0863 Black 34.99 NULL NULL 9.1593 Black 24.49 M NULL 1265.62 Silver 2320 38 23.4 8.2205 NA 21.98 NULL NULL 59.466 159 NULL NULL 1251.981 Black 2295 46 24.1 13.09 35 NULL NULL 0.8565 2.29 NULL NULL 1898.094 Black 3375 44 21.1 B | U S M M T S M M S R S R S M M S R S M M S S M M M M M S M V ------ + 60%
Expert Answer:
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these computer network questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Design a Java class that represents a cache with a fixed size. It should support operations like add, retrieve, and remove, and it should evict the least recently used item when it reaches capacity.
-
Deuterium ( ) is an attractive fuel for fusion reactions because it is abundant in the oceans, where about 0.015% of the hydrogen atoms in the water (H 2 O) are deuterium atoms. (a) How many...
-
Suppose at a price of $10 quantity demanded is 100 and when price is $11 quantity demanded is 85. What is the price elasticity of demand? Show all your work. Interpret this number completely.
-
A big olive (m = 0.50 kg) lies at the origin of an xy coordinate system, and a big Brazil nut (M = 1.5 kg) lies at the point (1.0, 2.0) m. At t = 0, a force Fo = (2.0i + 3.0j) N begins to act on the...
-
For combustion is necessary: (a) Air (b) Water (c) Paper (d) Fuel
-
(a) Johnson tells Davis that he paid $150,000 for his farm in 2007, and that he believes it is worth twice that at the present time. Relying upon these statements, Davis buys the farm from Johnson...
-
A 20N force acts perpendicular to the door 0.8m wide at its edge. Find moment at hinges. Also find moment at hinges if 20N force acts at 60 with the plane of door. i) 20N force acting perpendicular...
-
2) 1 lim (cos(x) + cos(x) |
-
Use If to define a function that, given a list of numbers, doubles all the positive numbers but leaves the negative numbers unchanged. Rewrite abs to include a specific rule for the case where its...
-
15. Explain the following trends: (i) (ii) toiwo loke Why does fluorine have a smaller atomic radius than beryllium? essa sniwollat pd to doesnt ES Why does fluorine have a smaller atomic radius than...
-
The steel SS1370 with composition must first be carburized and then hardened. It is desired to obtain a hardness HV of 550 at a depth of 2.5 mm below the surface. The carburization takes place in...
-
If it takes 4 seconds to mentally scan the distance between two locations 6 inches apart on a map, how long should it take to mentally scan locations that are 3 inches apart?
-
a) The value of your country's currency has been experiencing a drastic downward decrease in value relative to other major world currencies. In relation to the above statement, discuss four...
-
[20 marks] Below figure shows a part of the production line of carrot milk in the F&B company. Initially, the production begins with the blending of carrot, water, and condensed milk to form the raw...
-
Test your confidence in the following Project Decisions: SI. # Question 01 02 03 04 05 06 07 08 09 10 How many years did it take to construct the largest Egyptian Pyramid- Pyramid of Cheops? When was...
-
Answer each of the following questions using the Solmaris Condominium Group data shown in Figures 1-21 through 1-25. No computer work is required. 1. List the owner number, last name, and first name...
-
Using your knowledge of the college environment, identify three transactions that might be handled by online transaction processing (OLTP) systems.
-
What is meant by a local site? by a remote site?
-
Explain the error in this interpretation of inflation data: In the 12-month period ending in December of 1980, consumer prices rose by 12.4 percentafter a 13.3 percent increase the year before....
-
Answer this letter to Ann Landers: Ive read your column for ages and almost always agree with you. One subject on which we do not see eye-to-eye, however, is senior citizens driving. According to the...
-
Identify the error in Table 3.10, showing consumer prices and the change in prices based on a price index equal to 100 in 2000. Table 3.10 Year Price Index Change from Previous Year Change from 2000...
Study smarter with the SolutionInn App