My SQL project
rac965
globes.accdb| cust_name | cust_address | cust_city | cust_state | cust_zip | cust_country | cust_contact | cust_email | cust_id |
|---|---|---|---|---|---|---|---|---|
| Fun N Games | 85 Welkin Way | Port Chester | NY | 10573 | USA | Nancy Smith | [email protected] | 1001 |
| Seven Seas University | 1 Sea Place | Woods Hole | MA | 02543 | USA | 1002 | ||
| You Need This Gifts | 18 Fifth | Montreal | H3C 2W3 | Canada | Clancy O'Rorke | [email protected] | 1003 | |
| East West School System | 431 Grand Prairie Blvd. | Topeka | KS | 66603 | USA | 1005 | ||
| Lots To Learn | 555 Elm Street | Quincy | FL | 32351 | USA | [email protected] | 1006 | |
| More Toys More Fun | 52 County Road 7 | Boise | ID | 83720 | USA | 1008 | ||
| Have The Most Toys | 993 Main Street West | Sacramento | CA | 95814 | USA | Fred Brown | [email protected] | 1009 |
| Play Toys | 40 Westbridge Rd. | Perth | WA | 6000 | Australia | 1010 |
| order_num | order_row | prod_id | quantity | item_price |
|---|---|---|---|---|
| 5005 | 2 | GPT1 | 50 | ¤ 15.00 |
| 5005 | 3 | GSC1 | 50 | ¤ 11.25 |
| 5006 | 1 | GT1 | 10 | ¤ 102.50 |
| 5006 | 2 | GCDL1 | 10 | ¤ 32.50 |
| 5006 | 3 | GA1 | 10 | ¤ 120.00 |
| 5001 | 1 | GS2 | 5 | ¤ 17.95 |
| 5001 | 2 | GSC1 | 12 | ¤ 15.00 |
| 5001 | 3 | GPT1 | 50 | ¤ 19.95 |
| 5002 | 1 | SCG1 | 200 | ¤ 21.00 |
| 5003 | 1 | GF1 | 50 | ¤ 44.50 |
| 5003 | 2 | GC1 | 100 | ¤ 6.25 |
| 5003 | 3 | GS3 | 20 | ¤ 14.00 |
| 5003 | 4 | GBUB1 | 50 | ¤ 23.80 |
| 5003 | 5 | GS2 | 100 | ¤ 13.00 |
| 5004 | 1 | GH1 | 5 | ¤ 249.95 |
| 5004 | 2 | GA1 | 5 | ¤ 29.95 |
| 5005 | 1 | GA1 | 25 | ¤ 102.50 |
| order_num | order_date | cust_id |
|---|---|---|
| 5001 | 4/20/11 | 1006 |
| 5002 | 5/26/11 | 1002 |
| 5003 | 6/1/11 | 1010 |
| 5004 | 6/1/11 | 1003 |
| 5005 | 6/1/11 | 1002 |
| 5006 | 7/1/11 | 1009 |
| prod_id | vend_id | prod_name | prod_price | prod_desc |
|---|---|---|---|---|
| GRS1 | IG1 | Raised Surface Globe | ¤ 30.00 | relief globe (15 inches) |
| GS3 | SSS1 | Star Globe | ¤ 14.95 | 15 inch celestial globe |
| GCDL1 | IG1 | Celestial Double Layer Globe | ¤ 35.00 | 21 inch surface globe with second outer celestial layer |
| GSC1 | GG2 | Sea Current Globe | ¤ 15.65 | 15 inch ocean current globe |
| GPT1 | SSS1 | Plate Techtonics Globe | ¤ 21.50 | 15 inch plate techtonics globe |
| GF1 | GYG1 | Fish Globe | ¤ 49.95 | 25 inch spherical aquarium with printed globe |
| GA1 | IG1 | Animated Globe | ¤ 129.95 | Animated globe |
| MSS1 | SSS1 | Solar System Model | ¤ 30.00 | Hanging model of the solar system |
| GT1 | GYG1 | Tactile Globe | ¤ 109.50 | 36 inch tactile globe |
| SCG1 | GG2 | Computer Globe Software | ¤ 30.00 | Computer program of globe |
| GH1 | WHY1 | Holographic Globe | ¤ 249.95 | Holographic globe |
| GC1 | SSS1 | Compact Globe | ¤ 7.95 | 6 inch miniature globe |
| GS1 | SSS1 | Student Globe | ¤ 11.90 | 15 inch desktop globe |
| GBUB1 | GYG1 | Blow Up Beach Globe | ¤ 27.50 | 60 inch inflatible globe |
| GS2 | GG2 | Seabed Globe | ¤ 17.95 | 15 inch globe showing ocean floor |
| vend_name | vend_address | vend_city | vend_state | vend_zip | vend_country | vend_id |
|---|---|---|---|---|---|---|
| Global Globes | 42 Maple Avenue | Omaha | NE | 68114 | USA | GG2 |
| Got Your Globe | 11295 Global Terrace | Margate | FL | 33068 | USA | GYG1 |
| Gobs of Globes | Eisenhower Blvd. | Athens | GA | 30601 | USA | GOG1 |
| Interactive Globes | Rue de Rivoli | Paris | 75001 | France | IG1 | |
| Standard School Supplies | Broadview | IL | 60155 | USA | SSS1 | |
| World Holographic Year | 1 Marble Rd. | London | WF1 5QW | United Kingdom | WHY1 |
