Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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)

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_2

Step: 3

blur-text-image_3

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

Fundamentals Of Database Management Systems

Authors: Mark L. Gillenson

2nd Edition

0470624701, 978-0470624708

More Books

Students also viewed these Databases questions