Question: 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
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.
What would the star Schema look like?

Products Orders Product Employees ColumnName ED CodeTypeNu Customers Colume Com Conden Ow Fame CaregoryID Quartet 20 de 0 Avarcharo 250 Address Sa US U nder Reorderteve Too Brune Hire Address Yes Yes Yes Yes Yes Yes warda 15) wa narda 10 (1) Region Region ShAdded archar15 archar15 Show de wa She Country arch (15) varchar(15) Avarchar(15) archar(10) Avarchar(15) Postal Code Covery Home Phone Ergon vardar Raporto Photo Puth CustomerCustomer Demo Column Name Conden... Nullable OttomD c har(5) No Avarchar(255) Suppliers Column Name Condensed Type Ntable Supplier Companyamefardha (40) Co m e varchar(30) Contacte who arch narchar(15) nach (15) Powode Country Avarchar(15) 4 Condensed Type Nollable Order Details ColumnName OD Pod Une Price Quy Discount ton maline Employee Territories Column Name Condensed ... Employee 9 TerritoryID vard (20) Customer Demographics ColumnName Code. Nu Outomatylda No Na Categories Column Name CargoryID Condensed Type Nollable Territories ColumnName Candere Shippers Colume 9 Show Conde Territori t Rajanna Condens Region Columns 7 Region Regionen Ne Products Orders Product Employees ColumnName ED CodeTypeNu Customers Colume Com Conden Ow Fame CaregoryID Quartet 20 de 0 Avarcharo 250 Address Sa US U nder Reorderteve Too Brune Hire Address Yes Yes Yes Yes Yes Yes warda 15) wa narda 10 (1) Region Region ShAdded archar15 archar15 Show de wa She Country arch (15) varchar(15) Avarchar(15) archar(10) Avarchar(15) Postal Code Covery Home Phone Ergon vardar Raporto Photo Puth CustomerCustomer Demo Column Name Conden... Nullable OttomD c har(5) No Avarchar(255) Suppliers Column Name Condensed Type Ntable Supplier Companyamefardha (40) Co m e varchar(30) Contacte who arch narchar(15) nach (15) Powode Country Avarchar(15) 4 Condensed Type Nollable Order Details ColumnName OD Pod Une Price Quy Discount ton maline Employee Territories Column Name Condensed ... Employee 9 TerritoryID vard (20) Customer Demographics ColumnName Code. Nu Outomatylda No Na Categories Column Name CargoryID Condensed Type Nollable Territories ColumnName Candere Shippers Colume 9 Show Conde Territori t Rajanna Condens Region Columns 7 Region Regionen Ne
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
