JD Hub is a national retailer company specialized in selling electronics products. The CEO of JD Hub 
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.