Read case $2\mathrm{.}3$ on page $31$ in the Taniar textbook. Examine Fig$\mathrm{.}2\mathrm{.}15$ ERD $($reproduced below for proper identification$)$ and the corresponding Star model in Fig. $2\mathrm{.}16.$ Answer the following:

How would you change the Star model $($Fig$\mathrm{.}2\mathrm{.}16)$ if the granularity is lowered to $$per transaction$$ rather than $$per quarter$?$ Create the new Star model.

In the Star model of Fig$\mathrm{.}2\mathrm{.}16,$ why is Product not a Dimension?

Include Product as a Dimension in your Star model.

How will the SQL code provided in the case change due to the new requirements above? Provide the SQL code without executing it on the DBMS $($i$.$e$.,$ there is no need to use PostgreSQL, which will be next week$$s requirement$).$

Summarize the learning from this exercise in the form of bullet points.