BIS 445 Business Intelligence and Data Analysis Week 1 Lab 1B Solution – Homeworkmade

DOWNLOAD: BIS 445 Business Intelligence and Data Analysis Week 1 Lab 1B Solution – Homeworkmade

BIS 445 Week 1 Lab 1B

Using Lab 1B answer the questions and provide screen shots of your diagrams.

Part A:  Design dimension tables and a fact table 

1.         What are dimension tables used for?
2.         What is the purpose of a Fact table? 

Part B:  Link dimension tables to fact table 

Part C:  Create a university Star Schema