Create a PL/SQL query to display the customer id, donation id, donator id and return id for the donation that had a delivery id of 512 only. In your query, include the delivery price which is calculated at 20% of the donation price.

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...
icon
Related questions
Question

Create a PL/SQL query to display the customer id, donation id, donator id and return id for the donation that had a delivery id of 512 only.
In your query, include the delivery price which is calculated at 20% of the donation price.


  Sample Output:
‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
CUSTOMER ID:11013
DONATION ID: 7114
DONATOR ID: 20115
DELIVERY ID: 512
RETURN ID: 512 ret002
RETURN REASON: Product had broken section                                           DELIVERY PRICE: R 159.8 ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐

  

23; 24; 25
EMPLOYEE TABLE
EMPLOYEE_ID FIRST_NAME
emp101
emp102
emp103
emp104
emp105
DONATOR TABLE
DONATOR_ID
20111
20112
20113
20114
20115
DONATION_ID
7111
DONATION TABLE
7112
7113
7114
7115
7116
23; 24; 25
DELIVERY TABLE
DELIVERY_ID
511
512
513
514
515
516
ret001
ret002
Jeff
8111
8112
Kevin
Adanya
8113
8114
Adebayo
Xolanil
8115
8116
Jeff
Stephen
James
Kelly
Abraham
20111
20112
The Independent Institute of Education (Pty) Ltd 2023
FIRST_NAME
20113
20115
DONATOR_ID
20114
20113
RETURNS TABLE
RETURN_ID RETURN_DATE
25 May 2022
No notes
INVOICE TABLE
INVOICE_NUM CUSTOMER_ID
SURNAME
Davis
Marks
DELIVERY_NOTES
25 May 2022
Andrews
Dryer
Samson
11011
11013
11012
11015
11011
11015
Double packaging requested
Delivery to work address
Signature required
Birthday present wrapping
required
Delivery to work address
Watson
Jones
Joe
Ross
Clark
CONTACT NUMBER
0877277521
0837377522
SURNAME
0817117523
0797215244
0827122255
DONATION
KIC Fridge
Samsung 42inch
LCD
Sharp Microwave
6 Seat Dining
room table
Lazyboy Sofa
JVC Surround
Sound System
REASON
Customer not
satisfied with
product
Product had
broken section
INVOICE_DATE
15 May 2022
15 May 2022
17 May 2022
17 May 2022
17 May 2022
18 May 2022
PRICE
11011
R 599
11013
R 1 299
R 1 599
R 799
R 1 199
DISPATCH_DATE
10 May 2022
12 May 2022
12 May 2022
12 May 2022
18 May 2022
R 179
20 May 2022
CONTACT NUMBER EMAIL
0827172250
0837865670
0878978650
0826575650
0797656430
CUSTOMER_ID
ADDRESS
10 main
road
EMPLOYEE_ID
emp103
emp101
emp101
emp102
emp102
emp103
18 water
road.
21 circle
lane
1 sea road.
12 main
road.
7116
7114
EMAIL
jand@isat.com
7111
7114
7112
7113
7115
7116
km@isat.com
aa@isat.com
aryer@isat.com
xosam@isat.com
jwatson@ymail.com
joness@ymail.com
jj@isat.com
kross@gsat.com
aclark@ymail.com
DONATION_DATE
1 May 2022
3 May 2022
DONATION_ID
3 May 2022
5 May 2022
7 May 2022
9 May 2022
DELIVERY_DATE
15 May 2022
15 May 2022
17 May 2022
15 May 2022
19 May 2022
25 May 2022
DONATION_ID EMPLOYEE_ID
emp101
2023
emp103
Page 4 of 19
DELIVERY_ID
511
512
513
514
515
516
2023
Transcribed Image Text:23; 24; 25 EMPLOYEE TABLE EMPLOYEE_ID FIRST_NAME emp101 emp102 emp103 emp104 emp105 DONATOR TABLE DONATOR_ID 20111 20112 20113 20114 20115 DONATION_ID 7111 DONATION TABLE 7112 7113 7114 7115 7116 23; 24; 25 DELIVERY TABLE DELIVERY_ID 511 512 513 514 515 516 ret001 ret002 Jeff 8111 8112 Kevin Adanya 8113 8114 Adebayo Xolanil 8115 8116 Jeff Stephen James Kelly Abraham 20111 20112 The Independent Institute of Education (Pty) Ltd 2023 FIRST_NAME 20113 20115 DONATOR_ID 20114 20113 RETURNS TABLE RETURN_ID RETURN_DATE 25 May 2022 No notes INVOICE TABLE INVOICE_NUM CUSTOMER_ID SURNAME Davis Marks DELIVERY_NOTES 25 May 2022 Andrews Dryer Samson 11011 11013 11012 11015 11011 11015 Double packaging requested Delivery to work address Signature required Birthday present wrapping required Delivery to work address Watson Jones Joe Ross Clark CONTACT NUMBER 0877277521 0837377522 SURNAME 0817117523 0797215244 0827122255 DONATION KIC Fridge Samsung 42inch LCD Sharp Microwave 6 Seat Dining room table Lazyboy Sofa JVC Surround Sound System REASON Customer not satisfied with product Product had broken section INVOICE_DATE 15 May 2022 15 May 2022 17 May 2022 17 May 2022 17 May 2022 18 May 2022 PRICE 11011 R 599 11013 R 1 299 R 1 599 R 799 R 1 199 DISPATCH_DATE 10 May 2022 12 May 2022 12 May 2022 12 May 2022 18 May 2022 R 179 20 May 2022 CONTACT NUMBER EMAIL 0827172250 0837865670 0878978650 0826575650 0797656430 CUSTOMER_ID ADDRESS 10 main road EMPLOYEE_ID emp103 emp101 emp101 emp102 emp102 emp103 18 water road. 21 circle lane 1 sea road. 12 main road. 7116 7114 EMAIL jand@isat.com 7111 7114 7112 7113 7115 7116 km@isat.com aa@isat.com aryer@isat.com xosam@isat.com jwatson@ymail.com joness@ymail.com jj@isat.com kross@gsat.com aclark@ymail.com DONATION_DATE 1 May 2022 3 May 2022 DONATION_ID 3 May 2022 5 May 2022 7 May 2022 9 May 2022 DELIVERY_DATE 15 May 2022 15 May 2022 17 May 2022 15 May 2022 19 May 2022 25 May 2022 DONATION_ID EMPLOYEE_ID emp101 2023 emp103 Page 4 of 19 DELIVERY_ID 511 512 513 514 515 516 2023
CUSTOMER TABLE
CUSTOMER_ID FIRST_NAME SURNAME ADDRESS
11011
11012
11013
11014
11015
Jack
Pat
Andre
Kevin
Lucy
Smith
Hendricks 22 Water Rd
Clark
Jones
18 Water Rd
Williams
101 Summer
Lane
55 Mountain
way
5 Main rd
CONTACT NUMBER EMAIL
0877277521
0863257857
0834567891
0612547895
0827238521
jsmith@isat.com
ph@mcom.co.za
aclark@mcom.co.za
kj@isat.co.za
lw@mcal.co.za
Transcribed Image Text:CUSTOMER TABLE CUSTOMER_ID FIRST_NAME SURNAME ADDRESS 11011 11012 11013 11014 11015 Jack Pat Andre Kevin Lucy Smith Hendricks 22 Water Rd Clark Jones 18 Water Rd Williams 101 Summer Lane 55 Mountain way 5 Main rd CONTACT NUMBER EMAIL 0877277521 0863257857 0834567891 0612547895 0827238521 jsmith@isat.com ph@mcom.co.za aclark@mcom.co.za kj@isat.co.za lw@mcal.co.za
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
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 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)
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
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY