Need help with this Task 1 Create a table named REP. The table has the same structure as the SALES_REP table shown on page 1 of this lab, except the COMMISSION and RATE columns should use the NUMERIC data type. Execute the command to describe the layout and characteristics of the REP table. Task 2 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 rate: 0.05 Display the contents of the REP table. Task 3 Drop the REP table. Task 4 Check that the KimTay database is back to its starting point. The KimTay database should have the five tables shown on page 1 of this lab.
Need help with this Task 1 Create a table named REP. The table has the same structure as the SALES_REP table shown on page 1 of this lab, except the COMMISSION and RATE columns should use the NUMERIC data type. Execute the command to describe the layout and characteristics of the REP table. Task 2 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 rate: 0.05 Display the contents of the REP table. Task 3 Drop the REP table. Task 4 Check that the KimTay database is back to its starting point. The KimTay database should have the five tables shown on page 1 of this lab.
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
100%
Need help with this
Task 1
Create a table named REP. The table has the same structure as the SALES_REP table shown on page 1 of this lab, except the COMMISSION and RATE columns should use the NUMERIC data type. Execute the command to describe the layout and characteristics of the REP table.
Task 2
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
- rate: 0.05
Display the contents of the REP table.
Task 3
Drop the REP table.
Task 4
Check that the KimTay
Transcribed Image Text:INVOICE_NUM
14216
14219
14222
14224
14228
14231
14233
14237
INVOICE_DATE
2021-11-15
2021-11-15
2021-11-16
2021-11-16
2021-11-18
2021-11-18
2021-11-18
2021-11-19
CUST_ID
125
227
294
182
435
125
435
616
Transcribed Image Text:CUST_ID FIRST_NAME LAST_NAME ADDRESS
125
182
227
294
314
375
435
492
543
616
721
795
Joey
Billy
Sandra
Samantha
Tom
Melanie
James
Elmer
Angie
Sally
Leslie
Randy
Smith
Rufton
Pincher
Smith
Rascal
Jackson
Gonzalez
Jackson
Hendricks
Cruz
Smith
Blacksmith
17 Fourth St
21 Simple Cir
53 Verde Ln
14 Rock Ln
1 Rascal Farm Rd
42 Blackwater Way
16 Rockway Rd
22 Jackson Farm Rd
27 Locklear Ln
199 18th Ave
123 Sheepland Rd
75 Stream Rd
CITY
Cody
Garland
Powell
Ralston
Cody
Elk Butte
Wapiti
Garland
Powell
Ralston
Elk Butte
Cody
STATE POSTAL
WY
WY
WY
WY
WY
WY
WY
WY
WY
WY
WY
WY
82414
82435
82440
82440
82414
82433
82450
82435
82440
82440
82433
82414
EMAIL
jsmith17@example.com
billyruff@example.com
spinch2@example.com
ssmith5@example.com
trascal3@example.com
mjackson5@example.com
jgonzo@example.com
ejackson4@example.com
ahendricks7@example.com
scruz5@example.com
Ismith12@example.com
rblacksmith6@example.com
BALANCE
80.68
43.13
156.38
58.60
17.25
252.25
230.40
45.20
315.00
8.33
166.65
61.50
CREDIT_LIMIT REP_ID
500.00
750.00
500.00
500.00
250.00
250.00
1000.00
500.00
750.00
500.00
1000.00
500.00
05
10
15
10
15
05
15
10
05
15
10
05
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 3 images
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
Im having trouble with the code. So do I place all these codes in one page? the query.sql?
Solution
by Bartleby ExpertRecommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY