$$ 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$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.

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