ERD diagram and MS ACCESS file

profileRnieves0411
Book1.xlsx
Home>Business & Finance homework help>Management homework help>ERD diagram and MS ACCESS file

items

Itme Description price stock ID NAME LAST NAME ADDRESS
K-CP019928 Holly-Burgundy (Ruby) Faux Silk 57x90 Panel 14.00 140 001 ROBERTO CRUZ 217 N Hogan St, Jacksonville
K-CP019966 Holly-Cinnamon Faux Silk 57x90 Panel PRICE 14.00 325 002 JUAN CARLOS GOMEZ 4836 Leonard Street, Cape Coral
K-CP019973 Holly-Fuschia Faux Silk 57x90 Panel PRICE 14.00 458 003 JAVIER MORALES 12425 Collier Boulevard, Naples
K-CP019997 Holly-Blue Faux Silk 57x90 Panel PRICE 14.00 368 004 JOSE VAZQUEZ 1900 Tamiami Travel North, Naples
K-CP023055 Holly- Cream Faux Silk Curtain 57 x 90 Panel 10.00 1203 005 FERNANDO JIMENEZ 572 9th Street North, Naples
K-CP023062 Holly- Navy Faux Silk Curtain 57 x 90 Panel 10.00 252 006 FRANCISCO JAVIER REYES 494 5th Avenue South, Naples
K-CP023079 Holly Plum Faux Silk Curtain 57x90 Panel 10.00 212 007 ARTURO DIAZ 13750 Fiddlesticks Boulevard, Fort Myers
K-CP062238 2pk Memory Foam Chair Pad - Grey PRICE 9.50 542 008 MANUEL TORRES 2246 Oxford Ridge Circle, Lehigh Acres
K-CP062245 2pk Memory Foam Chair Pad - Beige PRICE 9.50 254 009 RAUL GUTIERREZ 12140 Metro Parkway # A, Fort Myers
K-CP062252 2pk Memory Foam Chair Pad - Green PRICE 9.50 552 010 RICARDO RUIZ 2549 Drive Martin Luther King Bl, Fort Myers
K-CP062269 2pk Memory Foam Chair Pad - Burgundy 9.50 662 011 RAFAEL AGUILAR 415 9th Southtreet South, Naples
K-CP062276 2pk Memory Foam Chair Pad - Chocolate 9.50 285 012 MARTIN MENDOZA 1100 6th Avenue South # 9, Naples
K-CP062283 2pk Memory Foam Chair Pad - Black PRICE 9.50 252 013 MARCO ANTONIO CASTILLO 3600 Prospect Avenue, Naples
K-CP082236 Mercedes 55x90 Lightweight Knit Curtain with 12.00 66 014 MIGUEL ORTIZ 2614 Tamiami Travel North, Naples
K-CP082243 Mercedes 55x90 Lightweight Knit Curtain with 12.00 45 015 SERGIO MORENO 2795 Davis Boulevard # A, Naples
K-CP082250 Mercedes 55x90 Lightweight Knit Curtain with 12.00 120 016 ARMANDO RIVERA 1900 Tamiami Travel North, Naples
K-CP082251 WIPER BLADE - CURVED 14" - CN 3.75 152 017 EDUARDO RAMOS 990 26th Avenue North, Naples
K-CP082252 WIPER BLADE - CURVED 20" - CN 3.75 854 018 JOSE ANTONIO ROMERO 870 6th Avenue South, Naples
K-CP082253 WIPER BLADE - CURVED 24" - CN 3.75 365 019 GERARDO JUAREZ 4344 Corporate Sq # 2, Naples
K-CP082254 WIPER BLADE - CURVED 26" - CN 3.75 282 020 ENRIQUE ALVAREZ 300 5th Avenue South, Naples
K-CP082255 RUBBER F/M EKO - 4 PCS BLACK - CN 12.00 141 021 VICTOR MANUEL MENDEZ 415 9th Southtreet South, Naples
K-CP082256 RUBBER F/M EKO - 4 PCS GRAY - CN 12.00 252 022 ALFREDO CHAVEZ 3551 Westview Drive, Naples
K-CP082257 RUBBER F/MAT - WEATHER RITE - 4PCS GRAY - CN 12.00 25 023 JUAN MANUEL HERRERA 371 Commercial Boulevard, Naples
K-CP082258 PVC F/MAT - CONTINENTAL - 3 PCS CLEAR - CN 11.00 45 024 MARIO MEDINA 2371 Francis Avenue, Naples
K-CP082259 FREEDOM - MAT - 4 PCS - PVC - CN 14.00 660 025 ALBERTO DOMINGUEZ 4202 Gulf Shore Boulevard North, Naples
K-CP082260 LEGACY DEEP TRAY - 5 PCS RUBBER - BLACK - CN 16.00 14 026 DANIEL CASTRO 1900 9th Street North, Naples
K-CP082261 SWC POWER GRIP - BLACK PURPLE - CN 5.00 524 027 OSCAR GUZMAN 9102 Bonita Beach Road, Naples
K-CP082262 SWC LEATHERETTE BLACK WITH TRIM - CN 5.00 85 028 JAIME VARGAS 4075 Pine Ridge Road Extension, Naples
K-CP082263 SWC LEATHERETTE GRAY WITH TRIM 5.00 413 029 DAVID VELAZQUEZ 2900 14th Street North, Naples
K-CP082264 SWC SPORT TRIM - BLACK PINK - CN 5.00 641 030 RUBEN SALAZAR 681 8th Street North East, Naples
K-CP082265 S.W.C. BURB GRAY 5.00 212
K-CP082266 S.W.C. BLING - BLACK/ WHITE DIAMONDS 5.00 542
K-CP082267 S.W.C - GRAY WITH WHITE DIAMOND 5.00 254
K-CP082268 14 PCS MICROFIBER CLEANING CLOTHS - CN 3.50 552
K-CP082269 MICROFIBER SPONGE WITH SCRUBBER - CN 2.50 662
K-CP082270 TIRE SHINE APPLICATOR PADS -2 PCS - CN 1.70 285
K-CP082271 SYNTHETIC CHAMOIS - SMALL - CN 1.50 252
K-CP082272 SYNTHETIC CHAMOIS - LARGE - CN 2.00 45
K-CP082273 WASH & WAX CONCENTRATE - 1 GALLON 4 PER 1.40 120
K-CP082274 BOOSTER CABLE - 300 AMP - 10 FT W/GLOVES - 14.00 152

customer

ID NAME LAST NAME ADDRESS
001 ROBERTO CRUZ 217 N Hogan St, Jacksonville
002 JUAN CARLOS GOMEZ 4836 Leonard Street, Cape Coral
003 JAVIER MORALES 12425 Collier Boulevard, Naples
004 JOSE VAZQUEZ 1900 Tamiami Travel North, Naples
005 FERNANDO JIMENEZ 572 9th Street North, Naples
006 FRANCISCO JAVIER REYES 494 5th Avenue South, Naples
007 ARTURO DIAZ 13750 Fiddlesticks Boulevard, Fort Myers
008 MANUEL TORRES 2246 Oxford Ridge Circle, Lehigh Acres
009 RAUL GUTIERREZ 12140 Metro Parkway # A, Fort Myers
010 RICARDO RUIZ 2549 Drive Martin Luther King Bl, Fort Myers
011 RAFAEL AGUILAR 415 9th Southtreet South, Naples
012 MARTIN MENDOZA 1100 6th Avenue South # 9, Naples
013 MARCO ANTONIO CASTILLO 3600 Prospect Avenue, Naples
014 MIGUEL ORTIZ 2614 Tamiami Travel North, Naples
015 SERGIO MORENO 2795 Davis Boulevard # A, Naples
016 ARMANDO RIVERA 1900 Tamiami Travel North, Naples
017 EDUARDO RAMOS 990 26th Avenue North, Naples
018 JOSE ANTONIO ROMERO 870 6th Avenue South, Naples
019 GERARDO JUAREZ 4344 Corporate Sq # 2, Naples
020 ENRIQUE ALVAREZ 300 5th Avenue South, Naples
021 VICTOR MANUEL MENDEZ 415 9th Southtreet South, Naples
022 ALFREDO CHAVEZ 3551 Westview Drive, Naples
023 JUAN MANUEL HERRERA 371 Commercial Boulevard, Naples
024 MARIO MEDINA 2371 Francis Avenue, Naples
025 ALBERTO DOMINGUEZ 4202 Gulf Shore Boulevard North, Naples
026 DANIEL CASTRO 1900 9th Street North, Naples
027 OSCAR GUZMAN 9102 Bonita Beach Road, Naples
028 JAIME VARGAS 4075 Pine Ridge Road Extension, Naples
029 DAVID VELAZQUEZ 2900 14th Street North, Naples
030 RUBEN SALAZAR 681 8th Street North East, Naples