Use the following SQL Oracle code to answer the following 2 questions 1 ) Add the following row to the REP table rep ID 3 5 , first name Fred last name Kiser address 4 2 7 Billings Dr city Cody state WY postal 8 2 4 1 4 cell phone 3 0 7 5 5 5 6 3 0 9 commission 0 0 0 and rate 0 0 5 Display the contents of the REP table 2 ) Run the script file for the KimTay Pet Supplies database to create the five tables and add records to the tables Be sure to select the script file for the particular DBMS that you are using ( MySQL , Oracle, or SQL Server ) SQL code Create the CUSTOMER INFO table CREATE TABLE CUSTOMER INFO ( ID NUMBER PRIMARY KEY, NAME FIRST VARCHAR 2 ( 2 0 ) , NAME LAST VARCHAR 2 ( 2 0 ) , ADDRESS VARCHAR 2 ( 2 0 ) , CITY VARCHAR 2 ( 1 5 ) , STATE POSTAL VARCHAR 2 ( 2 ) , EMAIL VARCHAR 2 ( 1 0 0 ) , BALANCE NUMBER ( 1 0 , 2 ) , CREDIT REP LIMIT NUMBER ( 1 0 , 2 ) ) Insert data into CUSTOMER INFO table INSERT INTO CUSTOMER INFO ( ID , NAME FIRST, NAME LAST, ADDRESS, CITY, STATE POSTAL, EMAIL, BALANCE, CREDIT REP LIMIT ) VALUES ( 1 2 6 , 'Joey', 'Smith', ' 1 7 Fourth', 'Cody', ' WY ' , 'jsmith 1 7 0 example com', 8 0 6 8 , 5 0 0 0 0 ) INSERT INTO CUSTOMER INFO ( ID , NAME FIRST, NAME LAST, ADDRESS, CITY, STATE POSTAL, EMAIL, BALANCE, CREDIT REP LIMIT ) VALUES ( 1 8 2 , 'Rafion', 'Billyruffe', ' 2 1 Simple Cir', 'Garland', ' WY ' , 'billyruffe example com', 4 3 1 3 , 7 5 0 0 0 ) INSERT INTO CUSTOMER INFO ( ID , NAME FIRST, NAME LAST, ADDRESS, CITY, STATE POSTAL, EMAIL, BALANCE, CREDIT REP LIMIT ) VALUES ( 2 2 7 , 'Sandra', 'Pincher', ' 5 3 Vende Ln ' , 'Powell', ' WY ' , 'spinch 2 0 example com', 1 5 6 3 8 , 5 0 0 0 0 ) INSERT INTO CUSTOMER INFO ( ID , NAME FIRST, NAME LAST, ADDRESS, CITY, STATE POSTAL, EMAIL, BALANCE, CREDIT REP LIMIT ) VALUES ( 2 9 4 , 'Samantha', 'Smith', ' 1 4 Rock La ' , 'Ralston', ' WY ' , 'smiths example com', 5 8 6 0 , 5 0 0 0 0 ) INSERT INTO CUSTOMER INFO ( ID , NAME FIRST, NAME LAST, ADDRESS, CITY, STATE POSTAL, EMAIL, BALANCE, CREDIT REP LIMIT ) VALUES ( 3 1 4 , 'Tom', 'Rascal', ' 1 Rascal Farm Rd ' , 'Cody', ' WY ' , 'trascal 3 example com', 1 7 2 5 , 2 5 0 0 0 ) INSERT INTO CUSTOMER INFO ( ID , NAME FIRST, NAME LAST, ADDRESS, CITY, STATE POSTAL, EMAIL, BALANCE, CREDIT REP LIMIT ) VALUES ( 3 7 5 , 'Melanie', 'Jackson', ' 4 2 Blackwater Way', 'Elk Butte', ' WY ' , 'mjackson 5 example com', 2 5 2 2 5 , 2 5 0 0 0 ) INSERT INTO CUSTOMER INFO ( ID , NAME FIRST, NAME LAST, ADDRESS, CITY, STATE POSTAL, EMAIL, BALANCE, CREDIT REP LIMIT ) VALUES ( 4 3 5 , 'James', 'Gonzalez', ' 1 6 Rockway Rd ' , 'Wapiti', ' WY ' , 'jgonzol example com', 2 3 0 4 0 , 1 0 0 0 0 0 ) INSERT INTO CUSTOMER INFO ( ID , NAME FIRST, NAME LAST, ADDRESS, CITY, STATE POSTAL, EMAIL, BALANCE, CREDIT REP LIMIT ) VALUES ( 4 9 2 , 'Elmer', 'Jackson', ' 2 2 Jackson Farm Hd ' , 'Garland', ' WY ' , 'ejackoson 4 0 example com', 4 5 2 0 , 5 0 0 0 0 ) INSERT INTO CUSTOMER INFO ( ID , NAME FIRST, NAME LAST, ADDRESS, CITY, STATE POSTAL, EMAIL, BALANCE, CREDIT REP LIMIT ) VALUES ( 5 4 3 , 'Angie', 'Hendricks', ' 2 7 Locklear Ln ' , 'Powell', ' WY ' , 'ahendricks 7 example com', 6 1 5 0 , 5 0 0 0 0 ) INSERT INTO CUSTOMER INFO ( ID , NAME FIRST, NAME LAST, ADDRESS, CITY, STATE POSTAL, EMAIL, BALANCE, CREDIT REP LIMIT ) VALUES ( 6 1 6 , 'Sally', 'Cruz', ' 1 9 9 1 8 th Ave', 'Ralston', ' WY ' , 'scruz 5 example com', 3 1 5 0 0 , 7 5 0 0 0 ) INSERT INTO CUSTOMER INFO ( ID , NAME FIRST, NAME LAST, ADDRESS, CITY, STATE POSTAL, EMAIL, BALANCE, CREDIT REP LIMIT ) VALUES ( 7 2 1 , 'Leslie', 'Smith', ' 1 2 3 Sheepland Ful', 'Elk Butte', ' WY ' , 'lsmith 1 2 0 example com', 1 6 6 6 5 , 1 0 0 0 0 0 ) INSERT INTO CUSTOMER INFO ( ID , NAME FIRST, NAME LAST, ADDRESS, CITY, STATE POSTAL, EMAIL, BALANCE, CREDIT REP LIMIT ) VALUES ( 7 9 5 , 'Randy', 'Blacksmith', ' 7 5 Stream Rd ' , 'Cody', ' WY ' , 'rblacksmith 6 example com', 6 1 5 0 , 5 0 0 0 0 ) Create the INVOICES table CREATE TABLE INVOICES ( INVOICE NUM NUMBER PRIMARY KEY, INVOICE DATE DATE, CUST ID NUMBER, FOREIGN KEY ( CUST ID ) REFERENCES CUSTOMER INFO ( ID ) ) Insert data into INVOICES table INSERT INTO INVOICES ( INVOICE NUM, INVOICE DATE, CUST ID ) VALUES ( 1 4 2 1 6 , TO DATE ( ' 1 1 1 5 2 0 2 1 ' , ' MM DD YYYY ' ) , 1 2 6 ) INSERT INTO INVOICES ( INVOICE NUM, INVOICE DATE, CUST ID ) VALUES ( 1 4 2 1 9 , TO DATE ( ' 1 1 1 5 2 0 2 1 ' , ' MM DD YYYY ' ) , 2 2 7 ) INSERT INTO INVOICES ( INVOICE NUM, INVOICE DATE, CUST ID ) VALUES ( 1 4 2 2 2 , TO DATE ( ' 1 1 1 6 2 0 2 1 ' , ' MM DD YYYY ' ) , 2 9 4 ) INSERT INTO INVOICES ( INVOICE NUM, INVOICE DATE, CUST ID ) VALUES ( 1 4 2 2 4 , TO DATE ( ' 1 1 1 6 2 0 2 1 ' , ' MM DD YYYY ' ) , 1 8 2 ) INSERT INTO INVOICES ( INVOICE NUM, INVOICE DATE, CUST ID ) VALUES ( 1 4 2 2 8 , TO DATE ( ' 1 1 1 8 2 0 2 1 ' , ' MM DD YYYY ' ) , 4 3 5 ) INSERT INTO INVOICES ( INVOICE NUM, INVOICE DATE, CUST ID ) VALUES ( 1 4 2 3 1 , TO DATE ( ' 1 1 1 8 2 0 2 1 ' , ' MM DD YYYY ' ) , 1 2 6 ) INSERT INTO INVOICES ( INVOICE NUM, INVOICE DATE, CUST ID ) VALUES ( 1 4 2 3 3 , TO DATE ( ' 1 1 1 8 2 0 2 1 ' , ' MM DD YYYY ' ) , 4 3 5 ) INSERT INTO INVOICES ( INVOICE NUM, INVOICE DATE, CUST ID ) VALUES ( 1 4 2 3 7 , TO DATE ( ' 1 1 1 9 2 0 2 1 ' , ' MM DD YYYY ' ) , 6 1 6 ) Create the INVOICE LINE table CREATE TABLE INVOICE LINE ( INVOICE NUM NUMBER, ITEM ID VARCHAR 2 ( 5 0 ) ,

The Answer is in the image, click to view ...

Question: Use the following SQL Oracle code to answer the following 2 questions: 1 ) Add the following row to the REP table: rep ID: 3

Use the following SQL Oracle code to answer the following

2

questions:

1)

Add the following row to the REP table: rep ID:

35,

first name: Fred; last name: Kiser;

address:

427

Billings Dr

.

; city: Cody; state: WY; postal:

82414

; cell phone:

307 - 555 - 6309

;

commission:

0.00

; and rate:

0.05 .

Display the contents of the REP table.

2)

Run the script file for the KimTay Pet Supplies database to create the five tables and add

records to the tables. Be sure to select the script file for the particular DBMS that you are

using

(

MySQL

,

Oracle, or SQL Server

) .

SQL code:

- -

Create the CUSTOMER

_

INFO table

CREATE TABLE CUSTOMER

_

INFO

(

ID NUMBER PRIMARY KEY,

NAME

_

FIRST VARCHAR

2 (20),

NAME

_

LAST VARCHAR

2 (20),

ADDRESS VARCHAR

2 (20),

CITY VARCHAR

2 (15),

STATE

_

POSTAL VARCHAR

2 (2),

EMAIL VARCHAR

2 (100),

BALANCE NUMBER

(10, 2),

CREDIT

_

REP

_

LIMIT NUMBER

(10, 2)

)

;

- -

Insert data into CUSTOMER

_

INFO table

INSERT INTO CUSTOMER

_

INFO

(

,

NAME

_

FIRST, NAME

_

LAST, ADDRESS, CITY, STATE

_

POSTAL, EMAIL, BALANCE, CREDIT

_

REP

_

LIMIT

)

VALUES

(126,

'Joey', 'Smith',

' 17

Fourth', 'Cody',

'

',

'jsmith

170

@example.com',

80.68, 500.00)

;

INSERT INTO CUSTOMER

_

INFO

(

,

NAME

_

FIRST, NAME

_

LAST, ADDRESS, CITY, STATE

_

POSTAL, EMAIL, BALANCE, CREDIT

_

REP

_

LIMIT

)

VALUES

(182,

'Rafion', 'Billyruffe',

' 21

Simple Cir', 'Garland',

'

',

'billyruffe@example.com',

43.13, 750.00)

;

INSERT INTO CUSTOMER

_

INFO

(

,

NAME

_

FIRST, NAME

_

LAST, ADDRESS, CITY, STATE

_

POSTAL, EMAIL, BALANCE, CREDIT

_

REP

_

LIMIT

)

VALUES

(227,

'Sandra', 'Pincher',

' 53

Vende Ln

',

'Powell',

'

',

'spinch

20

@example.com',

156.38, 500.00)

;

INSERT INTO CUSTOMER

_

INFO

(

,

NAME

_

FIRST, NAME

_

LAST, ADDRESS, CITY, STATE

_

POSTAL, EMAIL, BALANCE, CREDIT

_

REP

_

LIMIT

)

VALUES

(294,

'Samantha', 'Smith',

' 14

Rock La

',

'Ralston',

'

',

'smiths@example.com',

58.60, 500.00)

;

INSERT INTO CUSTOMER

_

INFO

(

,

NAME

_

FIRST, NAME

_

LAST, ADDRESS, CITY, STATE

_

POSTAL, EMAIL, BALANCE, CREDIT

_

REP

_

LIMIT

)

VALUES

(314,

'Tom', 'Rascal',

' 1

Rascal Farm Rd

',

'Cody',

'

',

'trascal

3

@example.com',

17.25, 250.00)

;

INSERT INTO CUSTOMER

_

INFO

(

,

NAME

_

FIRST, NAME

_

LAST, ADDRESS, CITY, STATE

_

POSTAL, EMAIL, BALANCE, CREDIT

_

REP

_

LIMIT

)

VALUES

(375,

'Melanie', 'Jackson',

' 42

Blackwater Way', 'Elk Butte',

'

',

'mjackson

5

@example.com',

252.25, 250.00)

;

INSERT INTO CUSTOMER

_

INFO

(

,

NAME

_

FIRST, NAME

_

LAST, ADDRESS, CITY, STATE

_

POSTAL, EMAIL, BALANCE, CREDIT

_

REP

_

LIMIT

)

VALUES

(435,

'James', 'Gonzalez',

' 16

Rockway Rd

',

'Wapiti',

'

',

'jgonzol@example.com',

230.40, 1000.00)

;

INSERT INTO CUSTOMER

_

INFO

(

,

NAME

_

FIRST, NAME

_

LAST, ADDRESS, CITY, STATE

_

POSTAL, EMAIL, BALANCE, CREDIT

_

REP

_

LIMIT

)

VALUES

(492,

'Elmer', 'Jackson',

' 22

Jackson Farm Hd

',

'Garland',

'

',

'ejackoson

40

@example.com',

45.20, 500.00)

;

INSERT INTO CUSTOMER

_

INFO

(

,

NAME

_

FIRST, NAME

_

LAST, ADDRESS, CITY, STATE

_

POSTAL, EMAIL, BALANCE, CREDIT

_

REP

_

LIMIT

)

VALUES

(543,

'Angie', 'Hendricks',

' 27

Locklear Ln

',

'Powell',

'

',

'ahendricks

7

@example.com',

61.50, 500.00)

;

INSERT INTO CUSTOMER

_

INFO

(

,

NAME

_

FIRST, NAME

_

LAST, ADDRESS, CITY, STATE

_

POSTAL, EMAIL, BALANCE, CREDIT

_

REP

_

LIMIT

)

VALUES

(616,

'Sally', 'Cruz',

' 199 18

th Ave', 'Ralston',

'

',

'scruz

5

@example.com',

315.00, 750.00)

;

INSERT INTO CUSTOMER

_

INFO

(

,

NAME

_

FIRST, NAME

_

LAST, ADDRESS, CITY, STATE

_

POSTAL, EMAIL, BALANCE, CREDIT

_

REP

_

LIMIT

)

VALUES

(721,

'Leslie', 'Smith',

' 123

Sheepland Ful', 'Elk Butte',

'

',

'lsmith

120

@example.com',

166.65, 1000.00)

;

INSERT INTO CUSTOMER

_

INFO

(

,

NAME

_

FIRST, NAME

_

LAST, ADDRESS, CITY, STATE

_

POSTAL, EMAIL, BALANCE, CREDIT

_

REP

_

LIMIT

)

VALUES

(795,

'Randy', 'Blacksmith',

' 75

Stream Rd

',

'Cody',

'

',

'rblacksmith

6

@example.com',

61.50, 500.00)

;

- -

Create the INVOICES table

CREATE TABLE INVOICES

(

INVOICE

_

NUM NUMBER PRIMARY KEY,

INVOICE

_

DATE DATE,

CUST

_

ID NUMBER,

FOREIGN KEY

(

CUST

_

)

REFERENCES CUSTOMER

_

INFO

(

)

)

;

- -

Insert data into INVOICES table

INSERT INTO INVOICES

(

INVOICE

_

NUM, INVOICE

_

DATE, CUST

_

)

VALUES

(14216,

_

DATE

(' 11 / 15 / 2021','

/

/

YYYY

'), 126)

;

INSERT INTO INVOICES

(

INVOICE

_

NUM, INVOICE

_

DATE, CUST

_

)

VALUES

(14219,

_

DATE

(' 11 / 15 / 2021','

/

/

YYYY

'), 227)

;

INSERT INTO INVOICES

(

INVOICE

_

NUM, INVOICE

_

DATE, CUST

_

)

VALUES

(14222,

_

DATE

(' 11 / 16 / 2021','

/

/

YYYY

'), 294)

;

INSERT INTO INVOICES

(

INVOICE

_

NUM, INVOICE

_

DATE, CUST

_

)

VALUES

(14224,

_

DATE

(' 11 / 16 / 2021','

/

/

YYYY

'), 182)

;

INSERT INTO INVOICES

(

INVOICE

_

NUM, INVOICE

_

DATE, CUST

_

)

VALUES

(14228,

_

DATE

(' 11 / 18 / 2021','

/

/

YYYY

'), 435)

;

INSERT INTO INVOICES

(

INVOICE

_

NUM, INVOICE

_

DATE, CUST

_

)

VALUES

(14231,

_

DATE

(' 11 / 18 / 2021','

/

/

YYYY

'), 126)

;

INSERT INTO INVOICES

(

INVOICE

_

NUM, INVOICE

_

DATE, CUST

_

)

VALUES

(14233,

_

DATE

(' 11 / 18 / 2021','

/

/

YYYY

'), 435)

;

INSERT INTO INVOICES

(

INVOICE

_

NUM, INVOICE

_

DATE, CUST

_

)

VALUES

(14237,

_

DATE

(' 11 / 19 / 2021','

/

/

YYYY

'), 616)

;

- -

Create the INVOICE

_

LINE table

CREATE TABLE INVOICE

_

LINE

(

INVOICE

_

NUM NUMBER,

ITEM

_

ID VARCHAR

2 (50),

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Use the following SQL tables(customers,offices,orders,products,salesrep) to answer the questions below, snippet the results with syntax used: drop table customers; CREATE TABLE CUSTOMERS (CUST_NUM...

Vital source: Art as LA ALEKS. Bo Waldru... Vitalsource: Art as L... 5 Letter from a Birmi... Lamar University Pr MISY 3310 - Access Assignment Total Points: 100 Premiere Products - Data Management...

Extra Credit Understanding Databases Use the following partial database tables to answer the required questions: Sales Table Sales Event # Dat e Terms Salesperson ID Customer ID 1 1 1 / 5 2 1 0 , net...

* * Please do not use any AI or reference any other projects * * studentData Table Student ID First Name Last Name Email Age Days in Course Degree Program A 1 John Smith John 1 9 8 9 @gm ail.com 2 0...

ANSWER Q4, HAVE INCLUDED ALL PARTS FOR REFERENCE BUT JUST ANSWER QUESTION 4: SQL QUERIES Question 1 (5 Points): Creating the database: Create a database using your name. Then create the following...

For this assignment, run this on SQL Workbench: Querying SQL Servers 1 Use SQL to complete the following exercises. 1. Create a table named REP. The table has the same structure as the SALES_REP...

SQL download the script database_university sql file from here: https://ufile.io/w7eu2 Section 1: Database Update Create a new database named as "YourUserName_University", and run the script...

In this assignment you will perform the physical design and implementation using SQL Data Definition Language (DDL) and proceed with populating the Mom and Pop Johnson Video Store database via Data...

Database Model: KimTay The management of KimTay Pet Supplies (a supplier of pet supplies, food, and accessories located in Cody, Wyoming) has determined that the companys recent growth no longer...

Lifestyle Publications Inc. is considering two new magazine products. The estimated net cash flows from each product are as follows: Each product requires an investment of $420,000. A rate of 15% has...

An auditor is auditing fixed assets and depreciation expenses of GMD Transportation Company for the fiscal year ending 31 December 2016. During the audit, the auditor detected the two trucks that are...

Q 7 . The information below relates to equipment owned by Bob the Builder as of December 3 1 , Year 7 : At December 3 1 , Year 7 , the equipment has a remaining useful life of five years with no...

If f x y z 2zy then the gradient at the point 3 2 4 is Vf 3 2 4 B