Question: Develop a data warehouse based on the entity - relationship ( or ER ) model created for the relational database in Assessment 2 . Utilise
Develop a data warehouse based on the entityrelationship or ER model created for the relational database in Assessment Utilise Crow Foots notation to construct a Star Schema Note: The term star schema includes snowflakes and galaxies in this context Clearly label fact and dimensional tables, relationships, cardinalities, and connectivities on your schema.
Select one specific part of the ER model that you want to develop into a Star Schema. You do not need to create a Star Schema for the entire ER model. Your selection should be guided by how it can enhance operations and cater to management's interests.
Demonstrate the construction of the Star Schema based on the ER model. Illustrate stepbystep how both Fact and dimensional tables are built.
Please note that you are unlikely to receive feedback on your ER Model from Assessment when you start working on this assessment. This is acceptable since the emphasis will not be on the ER model itself, but on the steps, you will undertake to generate Fact and Dimensional tables. However, if you wish to enhance any specific aspect of the ER model, you are welcome to do so provided you highlight the modifications you have made.
The clarity and readability of your diagrams are critical.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
