Following tables support the database of a shopping store. The schema contains four tables i.e. Customer, Product, Order and Order Product. Table details including attributes, primary keys (underline) and foreign keys (bold) are also shown below: CUSTOMER(CustID, CustName, CustEmail, CustPhone, CustCNIC) PRODUCT(ProdID, ProdName, ProdPrice) ORDER(OrderID, OrderDate, OrderPrice, CustID) ORDER_PRODUCT(OPID, ProdID, OrderID)
Following tables support the database of a shopping store. The schema contains four tables i.e. Customer, Product, Order and Order Product. Table details including attributes, primary keys (underline) and foreign keys (bold) are also shown below: CUSTOMER(CustID, CustName, CustEmail, CustPhone, CustCNIC) PRODUCT(ProdID, ProdName, ProdPrice) ORDER(OrderID, OrderDate, OrderPrice, CustID) ORDER_PRODUCT(OPID, ProdID, OrderID)
Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter7: Introduction To Structured Query Language (sql)
Section: Chapter Questions
Problem 65C: Write the SQL code to create the table structures for the entities shown in Figure P7.65. The...
Related questions
Question
Following tables support the
Customer, Product, Order and Order Product. Table details including attributes, primary keys
(underline) and foreign keys (bold) are also shown below:
CUSTOMER(CustID, CustName, CustEmail, CustPhone, CustCNIC)
PRODUCT(ProdID, ProdName, ProdPrice)
ORDER(OrderID, OrderDate, OrderPrice, CustID)
ORDER_PRODUCT(OPID, ProdID, OrderID)
iii. Write a SQL query to show all product names that are in price range of 500 – 1500 (both inclusive) in descending order.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning