Question

question is in the attachment
meaning less answers will be reported .

Answer 1

Step-by-step explanation:

The thing about star schema is that it is purpose-built for making certain kinds of queries easy and efficient.

If you're finding that some kinds of queries aren't being helped along by your star because of what is a dimension and what is a fact, then you build additional stars around the alternative views of dimensions and facts that will more easily support the queries you want to perform.

You keep your transactional database normalized. When it comes to your BI datawarehouse you need to let your redundancy anxiety go to avoid the heart burn.

Answer 2

Answer:

ǫ ᴊᴀ ʀʜɪ ʜᴏ ...

ᴄʜᴏᴅ ᴋʀ......