Figure $8\mathrm{.}43$ Source $1$: The Big Z Inc. Orders Database

HUMAN RESOURCES DEPARTMENT TABLE $($EMPLOYEE DATA$)$

Figure $8\mathrm{.}44$ Source $2$: The Big Z Inc. Human Resources Department Table

customer, including:

customer ID

customer name

customer type

customer zip

depot, including:

depot ID

depot size

depot zip

order clerk, including:

order clerk ID

order clerk name

order clerk title

order clerk education level

order clerk year of hire

E$8\mathrm{.}3$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.

E$8\mathrm{.}3$b Using data from Figures $8\mathrm{.}43$ and $8\mathrm{.}44,$ illustrate how the tables in the dimensional model created in E$8\mathrm{.}3$a would be populated.