Assignment 3- INSS 380
In this assignment, you will be inserting data in the following tables:
CUSTOMER, ORDERS, PART, AND ORDER_LINE
You need to show me the screenshot of your query that was executed successfully, and of the data that was inserted in each table as explained in class.
1) The CUSTOMER Table (5 points)

Below is the table CUSTOMER containing some empty cells (these cells are left empty intentionally to ease your task on this problem?)

CUSTOMER_NUM CUSTOMER_NAME STREET CITY STATE ZIP BALANCE CREDIT_LIMIT REP_NUM
148 20
282 35
356 65
408 35
462 65
524 20
608 65
687 35
725 35
842 20

The following data has been retrieved from the CUSTOMER table above. The data is organized in the same order as the attributes in the CUSTOMER table, that is for each record, the first data point belongs to CUSTOMER_NUM, the second belongs to CUSTOMER_NAME, the third one to STREET, ….., and so on until the last one which belongs to REP_NUM.

(148,’Al”s Appliance and Sport, 2837 Greenway, Fillmore, FL, 33336, 6550.00, 7500.00, 20);
(‘282′,’Brookings Direct’,’3827 Devon’,’Grove’,’FL’,’33321′,431.50,10000.00,’35’);
(‘356′,’Ferguson”s’,’382 Wildwood’,’Northfield’,’FL’,’33146′, 5785.00, 7500.00,’65’);
(408, The Everything Shop, 1828 Raven, Crystal’,’FL’,’33503′, 5285.25, 5000.00,’35’);
(‘462′,’Bargains Galore’,’3829 Central’,’Grove’,’FL’,’33321′,3412.00,10000.00,’65’);
(‘524′,’Kline”s’,’838 Ridgeland’, Fillmore, ‘FL’, 33336, 12762.00, 15000.00, 20);
(608, ‘Johnson’s Department Store’,’372 Oxford’,’Sheldon’,’FL’,’33553′,2106.00,10000.00,’65’);
(‘687′,’Lee”s Sport and Appliance’,’282Evergreen’,’Altonville’,’FL’,’32543′, 2851.00, 5000.00,’35’);
(‘725′,’Deerfield”s Four Seasons’, 282 Columbia, ‘Sheldon’, ‘FL’, 33553,248.00,7500.00,’35’);
(‘842′,’All Season’,’28 Lakeview’,’Grove’,’FL’,’33321′,8221.00,7500.00,’20’);

Using SQL, write a query to insert the data above in the CUSTOMER table (see the video on the class example)

2) The ORDERS Table (15 points)

ORDER_NUM ORDER_DATE CUSTOMER_NUM
21608 2007-10-20 148
21610 2007-10-20 356
21613 2007-10-21 408
21614 2007-10-21 282
21617 2007-10-23 608
Using SQL, write a query to insert this data in the ORDERS table

3) The PART Table (15 points)

PART_NUM DESCRIPTION CLASS WAREHOUSE ON_HAND PRICE
AT94 Iron 50 HW 3 24.95
BV06 Home Gym 45 SG 2 794.95
CD52 Microwave Oven 32 AP 1 165.00
DL71 Cordless Drill 21 HW 3 129.95
DR93 Gas Range 8 AP 2 495.00
DW11 Washer 12 AP 3 399.99
FD21 Stand Mixer 22 HW 3 159.95
KL62 Dryer 12 AP 1 349.45
KT03 Dishwasher 8 AP 3 595.00
KV29 Treadmill 9 SG 2 1390.00

Using SQL, write a query to insert this data in the PART table

4) The ORDER_LINE Table (15 points)

ORDER_NUM PART_NUM NUM_ORDERED QUOTED_PRICE
21608 AT94 11 21.95
21610 DR93 1 495.00
21610 DW11 1 399.99
21613 KL62 4 329.95
21614 KT03 2 595.00
21617 BV06 2 794.95
21617 CD52 4 150.00

Using SQL, write a query to insert this data in the ORDER_LINE table