1. Delete the customer(s) who not ordering. 2. Update CITY_NAME of CUSTOMER table for all customers. Take CITY_NAME from CITY table according to CITY_ID of CUSTOMER table. 3. Display the ORDER_ID and how many product(s) ordered for per order

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
100%

Please write clearly, thank you

1. Delete the customer(s) who not ordering.
2. Update CITY_NAME of CUSTOMER table for all customers. Take
CITY_NAME from CITY table according to CITY_ID of CUSTOMER table.
3. Display the ORDER_ID and how many product(s) ordered for per order
4. Display the ORDER_ID and PRODUCT_NAME from ORDER_DETAIL
table where ordered product count>1.
5. Display the details of order as "ORDER_ID, ORDER_DATE,
CUSTOMER_NAME, CITY_NAME" of all orders. Combine three tables using
without JOIN method.
Transcribed Image Text:1. Delete the customer(s) who not ordering. 2. Update CITY_NAME of CUSTOMER table for all customers. Take CITY_NAME from CITY table according to CITY_ID of CUSTOMER table. 3. Display the ORDER_ID and how many product(s) ordered for per order 4. Display the ORDER_ID and PRODUCT_NAME from ORDER_DETAIL table where ordered product count>1. 5. Display the details of order as "ORDER_ID, ORDER_DATE, CUSTOMER_NAME, CITY_NAME" of all orders. Combine three tables using without JOIN method.
Given the ORDER, ORDER_DETAIL, CUSTOMER, and PRODUCT tables.
CUSTOMER
CUSTOMER_ID CUSTOMER_NAME
1565
Emre
1789
Akif
1265
Eyup
4537
Fatih
6542
Murat
CITY
CITY_ID CITY_NAME
1
Gaziantep
2
Balıkesir
3
Edirne
4
Van
5
Rize
6
Kayseri
ORDER
ORDER_ID ORDER DATE
1
05.08.2012
2
11.04.2015
3
12.06.2013
4
02.05.2015
5
02.09.2014
ADDRESS CITY_ID CITY_NAME
Gatem
2
Rasaf yolu
1
Damlacık
6
köyü
Seyrantepe
1
Sarıgüllük
PRODUCT
PRODUCT_ID PRODUCT_NAME
PRICE (TL)
1
Bilgisayar
3250
2
Telefon
1800
3
Monitör
650
4
Klavye
45
5
1200
Televizyon
Masa
6
60
CUSTOMER_ID
1565
1265
4537
6542
1565
ORDER_DETAIL
ORDER_ID PRODUCT_ID
1
1
1
3
1
4
2
4
3
4
3
5
4
1
4
3
4
5
4
6
5
1
5
3
Transcribed Image Text:Given the ORDER, ORDER_DETAIL, CUSTOMER, and PRODUCT tables. CUSTOMER CUSTOMER_ID CUSTOMER_NAME 1565 Emre 1789 Akif 1265 Eyup 4537 Fatih 6542 Murat CITY CITY_ID CITY_NAME 1 Gaziantep 2 Balıkesir 3 Edirne 4 Van 5 Rize 6 Kayseri ORDER ORDER_ID ORDER DATE 1 05.08.2012 2 11.04.2015 3 12.06.2013 4 02.05.2015 5 02.09.2014 ADDRESS CITY_ID CITY_NAME Gatem 2 Rasaf yolu 1 Damlacık 6 köyü Seyrantepe 1 Sarıgüllük PRODUCT PRODUCT_ID PRODUCT_NAME PRICE (TL) 1 Bilgisayar 3250 2 Telefon 1800 3 Monitör 650 4 Klavye 45 5 1200 Televizyon Masa 6 60 CUSTOMER_ID 1565 1265 4537 6542 1565 ORDER_DETAIL ORDER_ID PRODUCT_ID 1 1 1 3 1 4 2 4 3 4 3 5 4 1 4 3 4 5 4 6 5 1 5 3
Expert 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