Using data from Figures $9\mathrm{.}25$ and $9\mathrm{.}26,$ show populated tables in the dimensional model created in E$9\mathrm{.}1$a$.$ 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

$($O$7$ and O$8)$ in the Big Z Inc. Orders Database.