(QUESTION 1) #1) From the Data Model that was created back on week 1 (ATTACHED BELOW), now please
create a “FACT” Table. Fact Table Elements should be data that can be
used as a metric or for measure’s – i.e. GPA, Grading Scale (100-95),
Course Credit Hours…
Your Fact Table should also contain the Primary Keys within your Dimension Table(s) from Week #1 (ATTACHED BELOW)
.#2) Insert your Fact Table as a center point within your Data Model so it depicts a Star Schema. (USE MICROSOFT ACCESS TO DO THIS ASSIGNMENT. DO NOT COMBINE QUESTION 1 AND 2 ON THE SAME ACCESS)
(QUESTION 2.) CREATING AND POPULATING THE FACT TABLE FROM DIMENSION TABLES. For this assignment, please use the internet to research the SQL Code to perform the following:
1) Create a Dimension Table (this table can be created from the excel attached below. i.e same information can be used to create the dimension table in access)
2) Create a Fact Table
3) Load Data into the Fact Table referencing the Dimension Tables
Please do not reference any Database Tool’s Wizards on completing this exercise. I’m looking for the actual SQL Code. (USE MICROSOFT ACCESS TO DO THIS ASSIGNMENT. DO NOT COMBINE QUESTION ONE AND TWO ON THE SAME ACCESS)
0 comments