dimensional model of rental house management
please answer correctly.
Answers
Answer:
not sure check it one time hope u like it and keep supporting ❣️
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.
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.