names of their Category (CategoryName), include products that do not yet have a

Question

names of their Category (CategoryName), include products that do not yet have a category assigned. (Where CategoryID is null) PRODUCT Table CATEGORY Table ProductIlD ProductName CategorylD CategorylD CategoryName Q10: A furniture store needs a database solution to support its sales and and marketing department needs to look at quarterly sales data to identify top selling products and how they vary by location and across customer demographics. The sales manager typically needs such reports once or twice every quarter and the report is based on all transactions in the previous quarter which is typically in the millions. Discuss if a data warehouse would /would not be appropriate solution for this scenario. Provide 3 reasons in support of your recommendation.

Explanation / Answer

Please find my naswer for Q9.

Please repost others (Q 10) in separate post.

SELECT P.ProductID, P.ProductName, C.CategoryName
FROM Product P, Category C
WHERE P.CategoryID = C.CategoryId OR C.CategoryID is NULL

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

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