a. Based on the sources and requirements listed above, create a dimensional model that will be used for the dimensionally modeled data warehouse for Big Z Inc.
b. Using data from Figures 8.47 and 8.48, illustrate how the tables in the dimensional model created in E8.3a would be populated.
c. Based on the sources and requirements listed above, create an ER model and a mapped relational model for the normalized data warehouse for Big Z Inc.
d. Using data from Figures 8.47 and 8.48, illustrate how the tables in the relational model created in E8.3c would be populated.