Question
ASSIGNMENT DESCRIPTION: A company named Pretty Prints is in the business of selling lithograph prints created by local artists. When an artist creates a lithograph,
ASSIGNMENT DESCRIPTION: A company named Pretty Prints is in the business of selling lithograph prints created by local artists. When an artist creates a lithograph, s(he) creates several hundred prints from it. The company needs a database to manage orders. You are to create a database for this purpose and enter the existing data. The database should be named prints and is composed of the tables below. You are asked to do the following: Download the MySQL database management system along with the MySQL workbench. Also download connector/J. After the download you are to use SQL to create a database named prints which is composed of these tables.
TABLES:
customers
customer_id | customer_name | customer-add | customer_city | customer_state | customer_zip | customer_phone |
1000 | Cora Blanca | 1555 Seminole Ct. | Charlotte | NC | 28210 | 704/552.1810 |
1100 | Yash Reed | 878 Madison Ave. | Greensboro | NC | 27407 | 336/316-5434 |
1200 | John Mills | 4200 Olive Ave. | Columbia | SC | 29206 | 803/432.6225 |
1300 | David Cox | 608 Old Post Rd. | Decatur | GA | 30030 | 404/243.7379 |
1400 | Tina Evans | 235 Easton Ave. | Jacksonville | FL | 32221 | 904/992-7234 |
1500 | Will Allen | 2508 W. Shaw Rd. | Raleigh | NC | 27542 | 919/809.2545 |
1600 | James Boyd | 200 Pembury Ln. | Columbia | SC | 29206 | 803/432-7600 |
1700 | Will Parsons | 4990 S. Pine St. | Raleigh | NC | 27545 | 919/355/0034 |
1800 | Walter Kelly | 1200 Little St. | Columbia | SC | 29206 | 803/432-1987 |
1900 | Ann Damian | 7822 N. Ridge Rd. | Jacksonville | FL | 32216 | 904/725-4672 |
2000 | Grace Hull | 4090Caldweld St. | Charlotte | NC | 28205 | 704/365.7655 |
2100 | Jane Brown | 3320 W. Main St. | Charlotte | NC | 28210 | 704/372/9000 |
2200 | Betty Draper | 1600 Sardis Rd. | Sarasota | FL | 32441 | 918/941-9121 |
Items
item_id | title | artist | unit_price | on_hand |
100 | Under the Sun | Donald Arley | 46.80 | 340 |
200 | Dark Lady | Keith Morris | 120.99 | 250 |
300 | Happy Days | Andrea Reid | 78.00 | 210 |
350 | Top of the Mountain | Janice Jones | 110.00 | 290 |
400 | Streets from Old | Sharon Brune | 123.00 | 320 |
450 | The Hunt | Walter Alford | 39.99 | 390 |
600 | Rainbow Row | Judy Ford | 46.00 | 350 |
700 | Skies Above | Alexander Wilson | 98.00 | 275 |
800 | The Seas and Moon | Susan Beeler | 67.81 | 235 |
850 | Greek Isles | Benjamin Caudle | 76.00 | 300 |
orders
order_id | customer_id | order_date | ship_date |
1 | 1200 | 2013-10-23 | 2013-10-28 |
2 | 1500 | 2013-10-30 | 2013-11-03 |
3 | 1500 | 2013-11-09 | 2013-11-14 |
4 | 2100 | 2013-11-15 | 2013-11-20 |
5 | 1600 | 2013-11-15 | 2013-11-20 |
6 | 1900 | 2013-12-15 | 2013-12-19 |
7 | 2200 | 2013-12-18 | 2013-12-22 |
8 | 1600 | 2013-12-20 | 2013-12-22 |
9 | 1000 | 2014-01-18 | 2014-01-23 |
10 | 2200 | 2014-01-31 | 2014-02-04 |
11 | 1500 | 2014-02-01 | 2014-02-06 |
12 | 1400 | 2014-02-27 | 2014-03-02 |
13 | 1100 | 2014-03-10 | 2014-03-15 |
14 | 1400 | 2014-03-14 | 2014-03-15 |
Orderline
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started