$(0\mathrm{.}5$ points$)$ We can consider ClientBuyer dimension as slowly change dimension because of client address information. Let$$s say we have three customers $$ JSK$,$ MB$,$ and JA$.($Figure $3)$ Figure $3.$ Now, one of our clients, JSK$,$ is moving from Irvine CA to Chattanooga TN $($Hamilton County$).$ Therefore, we need to update the dimension as you can see in Figure $4.$ Figure $4.11$ What could be the concern if we update slowly changing dimension in this way $($update from Figure $3$ to Figure $4)?)(0\mathrm{.}5$ points$)$ Let$$s say we have a local database in marketing department. In this database, we track Advertising entity. In this Advertising entity, we have attributes such as advID, campaignStartingDate, campaignDuration, propertyNo, branchNo, PromotionNo, MediaName, MediaType, and AdvCampaignCosts. Now, we want to create a new fact table called Advertising Spending. The fact table can be analyze based on time, branch, promotion, and media. Please update the Figure $2$ and create a galaxy of stars schema. $9.($Total $1$ points$)$ Figure $2$ represents a star schema. Read the following questions and answer them careful.

Figure $2.$

$(1)(0\mathrm{.}5$ points$)$ We can consider ClientBuyer dimension as slowly change dimension because of client address information. Let's say we have three customers $-$ JSK$,$ MB$,$ and JA$.($Figure $3)$

Figure $3.$

Now, one of our clients, JSK$,$ is moving from Irvine CA to Chattanooga TN $($Hamilton County$).$ Therefore, we need to update the dimension as you can see in Figure $4.$

Figure $4.$