In MySQL, please help Pretty Prints ASSIGNMENT DESCRIPTION: A company named Pret

Question

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 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

Explanation / Answer

Steps:

Step 1. Download MySQL DBMS along with work bench.

Step 2. Create a Database named prints.

//Note:- You can use mysql work bench or mysql commandline as per your convenience.

//Sql Command to create the database:

  

create database prints;

Step 3 : Use prints to create tables now(If you are using commandprompt, your sql query will be :' use prints; ' to select databse).

Step 4 : Create tables

Query:

Create table customers(customer_id integer,customer_name varchar(25),customer_add varchar(75),customer_city varchar(20),customer_state varchar(20),customer_zip integer,customer_phone varchar(20));

Create table items(item_id integer,Title varchar(50),artist varchar(50),unit_price float,on_hand integer);

Create table orders(order_id integer,customer_id integer,order_date date,ship_date date);

Create table orderline(order_id integer,item_id integer,order_qty integer);

Step 5 : Insert values to tables:

//Note:- Due to lack of time I am inserting only few rows for your reference. I am trying to answer all parts of your question.

customers:

insert into customers values('John Mills','4200 Olive Ave','Columbia','SC',29206,'803/432-6225');

  

insert into customers values('Will Allen','2508 W.Shaw Rd.','Ralleigh','NC',27542,'919/809-2545');

items:

insert into items values(100,'Under the sun','Donald Artey',46.80,340);

insert into items values(200,'Dark Lady','Keith Morris',120.99,250);

orders:

insert into orders values(1,1200,'2013-10-23','2013-10-28');

insert into orders values(2,1500,'2013-10-30','2013-11-03');

insert into orders values(3,1500,'2013-11-09','2013-11-14');

orderline:

Insert into orderline values(1,800,2);

Insert into orderline values(1,600,1);

Insert into orderline values(2,700,3);

Step 6 : Display tables using select query:

select * from customers;

select * from items;

select * from orders;

select * from orderline;

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.