JD Hub is a national retailer company specialized in selling electronics products. The CEO of JD Hub
Fantastic news! We've Found the answer you've been seeking!
Question:
wants to increase their sales on Boxing Day. This year (2022), he plans to give more discounts to the
electronics products that were the most sold on the Boxing Days of recent years. He would like to
try NSW shops as a trial for this year, before rolling out to all states in future.
The CEO asks you to find out the top 9 electronics products that are the best sold in quantity on
Boxing Days over all the past five years in NSW.
• Provide a star schama to show your physical desgin. Explain what your facts,
measures, and dimensions are, and how they are linked with each other.
• Produce a query which can be executed on your star schema and addresses the CEO's
requirement. Provide explanations to your query regarding its logic.
Related Book For
Core Concepts Of Accounting Information Systems
ISBN: 9780470507025
11th Edition
Authors: Nancy A. Bagranoff, Mark G. Simkin, Carolyn Strand Norman
Posted Date: