Question 3 2 pts You are trying to create a query that will show you the product

Question

Question 3 2 pts You are trying to create a query that will show you the product id, product name and order id for all of the orders in your database. However, your partial output looks like the following: select productID productName Orderkey from product orderdetail product key productName Orderkey 1001 Basic Pizza Large 1005 Basic Pizza Large 1006 1001 Basic Pizza Large 1007 1001 Basic Pizza Large 1007 1001 Basic Pizza Large 1008 1001 Basic Pizza Large 1008 1001 1009 1001 Basic Pizza Large 1002 Basic Pizza Medium 1000 Basic Pizza Medium 1005 1002 Basic Pizza Medium 1006 1002 Basic Pizza Medium 1007 1002 Basic Pizza Medium 1007 1002 Basic Pizza Medium 1008 1002 Basic Pizza Medium 1008 1002 Basic Pizza Medium 1009 1002

Explanation / Answer

There is a cartesian product created by the impropert join of product with orderdertail. You can very well see the result having more duplicate records.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.