option 1 star schema jigsaw database

by

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.