Option #1: Star Schema – JigSaw database.
Help me study for my Computer Science class. I’m stuck and don’t understand.
Option #1: Star Schema – JigSaw database
Utilize the JigSaw SQL file in the Module 6 folder to create a Star Schema diagram. Remember, to create a Star Schema from a normalized data model, you will need to denormalize the data model into fact and dimension tables.
The diagram should contain all of the facts and dimension tables necessary to integrate the JigSaw operational database into a data warehouse. Write a brief paper describing the challenges you experienced in completing this assignment.