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 E8.3a 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

Using data from Figures 8.43 and 8.44, illustrate how the tables in the dimensional model created in E8.3a would be populated.

Figure 8.43

Figure 8.44

HUMAN RESOURCES DEPARTMENT TABLE (EMPLOYEE DATA) \begin{tabular}{|l|l|l|l|l|} \hline EmployeeID & Name & Title & Education Level & Yea \\ \hline OC1 & Antonio & Order Clerk & High School & 2010 \\ \hline OC2 & Wesley & Order Clerk & College & 2016 \\ \hline OC3 & Lilly & Order Clerk & College & 2016 \\ \hline \end{tabular}