Q$9-2.(0\mathrm{.}5$ points$)$ The original Relational DB $($Figure $3)$ we create has an entity called SalesTransaction. Among the five attributes in the SalesTransaction entity, the TDate attribute becomes the Calendar dimension in Figure $2.$

SALESTRANSACTION

$\backslash$table$[[$TID$,$CustomerID,StoreID,TDate,TTime$],[$T$111,1-2-333,$S$1,1-$Jan$-2020,8$:$23$:$59$ AM$],[$T$222,2-3-444,$S$2,1-$Jan$-2020,8$:$24$:$30$ AM$],[$T$333,1-2-333,$S$3,2-$Jan$-2020,8$:$15$:$08$ AM$],[$T$444,3-4-555,$S$3,2-$Jan$-2020,8$:$20$:$33$ AM$],[$T$555,2-3-444,$S$3,2-$Jan$-2020,8$:$30$:$00$ AM$],[$T$666,2-3-444,$S$3,2-$Jan$-2020,9$:$30$:$00$ AM$]]$

Figure $3$

If you cannot access the figure $3,$ please download it from here darr.

We call this type of transformation as transformation.

Edit View Insert Format Tools Table

$12$pt

Paragraph

$$Q$9-3.(0\mathrm{.}6$ points$)$ In the Star Schema, the chosen subject of analysis is represented by a

$q,$ table. And, we have $q,$ tables $($#$)$ according to Figure $2.$

Edit View Insert Format Tools Table

$12$pt $vv$ Paragraph

$$

p

$0$ words

Q$9-4.(1\mathrm{.}5$ points$)$ Customer dimension of Figure $2$ is a slowly changing dimension. The two attributes $-$ CustomerZip and CustomerMaritalStatus $-$ are the two SCD attributes. There are three ways to deal with SCD attributes.

Please define each of the solutions $($in words$).$ And discuss the strengths and weaknesses of each method type. $($You can show examples to define each solution if you want.$)$

$($A$)$ Solution $1($Type $1)$:

$($B$)$ Solution $2($Type $2)$:

$($C$)$ Solution $3($Type $3)$:

$($If you decide to create a file to answer Q#$9-4,$ please make the solution in a jpeg, docx, or pdf format, and please email it to

jinsik$-$kim@utc.edu with an attached file $($within $10$ minutes you finish your exam.$).$Q$10.(3\mathrm{.}5$ points$)$ What are the key differences between ETL and EL$,$ and why is ETL preferred for Data Warehouses while EL is better suited for Data Lakes?

DATA LAKE

SOURCE SYSTEMS