Exercise
Figure 7.15 shows the ERD of Northwind that you saw in Chapter 2, Entity Analysis. Northwind is a company that purchases delicacies (products) from suppliers all over the world. The products have been categorized into categories. Products are sold to customers by Northwind employees. Shippers make sure that customers receive the products they buy:
Figure 7.15 – Northwind ERD
Because management feels they lack control because they lack information, you are asked to create management reports based on a star schema database. Following an initial analysis, the following demands have been formulated:
- The sales department needs reports showing sales by customer, by salesperson, by product, by supplier, and by country:
a. All reports should be based on fiscal years starting on July 1.
b. An analysis needs to be broken down from years into quarters and months. When an analysis is performed based on the calendar rather than on fiscal years, trimesters...