Design a dimensional $($star$)$ model and include the following:

Design the Dimensions and the Fact.

Take a screenshot showing your Dimensions and Fact.

Load the Dimensions and the Fact with relevant data from the operational database you designed in Step $1$ above, making sure to capture all of the queries.

Take a screenshot$($s$)$ to show that all relevant data has been loaded.

Write a query in SQL to get the quantities of the sold products on Wednesday in the category Footwear provided by vendor Pacific Gear within the tri$-$state region between the $1$st and the $2$nd quarter of $2024.$

Take a screenshot showing the query and the results.

In a succinct paragraph, explain how the ability to obtain information like that discovered in the above query could guide critical business decisions.

Submit the following in a single document compatible with the digital classroom $($e$.$g$.,$ Microsoft Word$).$ Include a one$-$line description above each screenshot.