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 9.31 and 9.32, illustrate how the tables in the dimensional model created in E9.1a would be populated. Make the following assumptions:
• The ETL process chooses the longest version of the name in cases when more than one version of a personal name for the same person is available.
• The ETL process recognizes that the same order was incorrectly recorded twice with two different OrderID values (O7 and O8) in the Big Z Inc. Orders Database.