Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In MySQL, please help Pretty Prints ASSIGNMENT DESCRIPTION: A company named Pretty Prints is in the business of selling lithograph prints created by local artists

In MySQL, please help

image text in transcribedimage text in transcribedimage text in transcribed

Pretty Prints 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 Submit either a screenshot of the SQL commands or a script file containing the SQL into Moodle2 for grading TABLES customers customer id customer name customer-add customer state customer zip customer phone 28210 27407 29206 30030 32221 27542 29206 27545 29206 32216 28205 28210 32441 customer cI 704/552.1810 336/316-5434 803/432.6225 404/243.7379 904/992-7234 919/809.2545 803/432-7600 919/355/0034 803/432-1987 904/725-4672 704/365.7655 704/372/9000 918/941-9121 Cora Blanca Yash Reed John Mills David Cox Tina Evans Will Allen 1000 1100 1200 1300 1400 1500 1600 James Boyd 1700 1800Walter Kelly 1900 2000 2100 2200 Betty Draper 1555 Seminole Ct. Charlotte 878 Madison Ave Greensboro 4200 Olive Ave 608 Old Post Rd. Decatur 235 Easton Ave 2508 W. Shaw Rd. Raleigh 200 Pembury Ln.Columbia 4990 S. Pine St. 200 Little St. 7822 N. Ridge Rd.Jacksonville 4090Caldweld St. Charlotte 3320 W. Main St. Charlotte 1600 Sardis Rd NC NC SC GA FL NC SC NC SC FL NC NC FL Columbia Jacksonville Will Parsons Raleigh Columbia Ann Damian Grace Hull Jane Brown Sarasota

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Online Market Research Cost Effective Searching Of The Internet And Online Databases

Authors: John F. Lescher

1st Edition

0201489295, 978-0201489293

More Books

Students also viewed these Databases questions

Question

a. How will the leader be selected?

Answered: 1 week ago