Design A Fact Table, homework help

User Generated

jvyyvnzxhzv

Description

(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)

Unformatted Attachment Preview

ACADEMIC_COLLEGES.TBL College_of_Study_Name Air University College_of_Study_Code AU DEGREE_ AND _CERTIFICATE.TBL Degree_Code AAS Degree_Name ARTS _and_SCIENCES Degree_Code BUS Degree_Name BUSINESS Degree_Code EDU Degree_Name EDUCATION Degree_Code HP Degree_Name - HEALTH PROFESSIONS Degree_Code AOA Degree_Name ASSICIATE OF ARTS Degree_Code TECH Degree_Name TECHNOLOGY Degree_Code SABS Degree_Name SOCIAL AND BEHAVIORAL SCIENCES Degree_Code CR Degree_Name CONFLICTS RESOLUTION (CERTIFICATE) Degree_Code ABS Degree_Name APPLIED BUSINESS STATISTIC (CERTIFICATE) Degree_Code ACC Defree_Name ACCOUNTING (CERTIFICATE) Degree_Code OR Degree_Name ORGANIZATIONAL LEADERSHIP (CERTIFICATE) COURSES FORMAT.TBL Course_Code COM Format_Code TC Course_Name COMMUNICATION Format_Name TRADITIONAL CLASS Course_Code FIN Format_Code ON Course_Name FINANCE Format_Name - ONLINE Course_Code IST Format_Code HY Course_Name Information Systems Technology Format_Name HYBRID Course_CodeBSN Format_Code TC Course_Name Bachelor of Science in Nursing Format_Name TRADITIONAL CLASS Course_Code LS Format_Code TC Course_Name LIBERAL STUDIES Format_Name TRADITIONAL CLASS Course_Code ISM Format_Code HY Course _Name INFORMATION SYSTEMS MANAGEMENT Format_Name HYBRID Course_Code CJ Format_Code HY Course_Name CRIMINAL JUSTICE Format_Name HYBRID Course_Code CR Format_Code ON Course_Name CONFLICT RESOLUTION Format_Name - ONLINE Course_Code ABS Format_Code ON Course_Name APPLIED BUSINESS STATISTIC Format_Name - ONLINE Course_Code ACC Format_Code ON Course_Name ACCOUNTING Format_Name - ONLINE Course_Code OL Format_Code TC Course_Name ORGANIZATIONAL LEADERSHIP Format_Name TRADITIONAL CLASS LOCATION.TBL Location_Code NC Location_Name NEWCASTLE Location_Code TBA Location_Name TBA Location_Code BD/TBA Location_Name BRANDYWINE/TBA Location_Code DV Location_Name -DOVER Location_Code SA Location_Name SALEM Location_Code GT Location_Name GEORGETOWN Location_Code DV /TBA Location_Name DOVER /TBA Location_Code TBA Location_Name TBA Location_Code TBA Location_Name TBA Location_Code TBA Location_Name TBA Location_Code NC Location_Name NEWCASTLE REGISTRATION.TBL Student_Name WILLIAMS WHITE Student_ID 24256 Stdent_Name RICE BROWN Student_ID 94578 Student_Name PETER ADAMS Student_ID 26570 Student_Name KELVIN ALI Student_ID 55967 Student_Name RITA WATER Student_ID 24289 Student_Name MICHEAL ADAMS Student_ID 44256 Student_Name ROBERT HANDS Student_ID 76589 Student_Name PETER JAMES Student_ID 27659 Student_Name EMMA KOFI Student_ID 76594 Student_Name ENOUCH PLUSS Student_ID 62425 Student_Name SAMUEL TRAINN Student_ID 30862 FINANCE Student_Account $ 1062 Student_ID 24256 Student_Account $ 1062 Student_ID 94578 Student_Account $ 1062 Student_ID 26570 Student_Account $1062 Student_ID 55967 Student_Account $ 1062 Student_ID 24289 Student_Account $ 1062 Student_ID 44256 Student_Account $ 1062 Student_ID 76589 Student_Account $ 1062 Student_ID - 27659 Student_Account $ 1062 Student_ID 27594 Student_Account $ 1062 Student_ID 62425 Student_Account$ 1062 Student_ID 30862 STUDENT.TBL Student_ID 24256 Student_Age 25 Student_ID 94578 Student_age 30 Student_ID 26570 Student_Age 20 Student_ID 55967 Student_Age 21 Student_ID 24289 Student_Age 29 Student_ID 44256 Student_Age 22 Student_ID 76589 Student_Age 28 Student_ID - 27659 Student_Age 27 Student_ID 27594 Student_Age 23 Student_ID 62425 Student_Age 25 Student_ID 30862 Student_Age 26 TERM.TBL Semester - Spring Year - 2017 Semester -Spring Year- 2017 Semester - Spring Year - 2017 Semester- Spring Year - 2017 Semester -Spring Yea r- 2017 Semester - Spring Year - 2017 Semester - Spring Year - 2017 Semester - Spring Year - 2017 Semester- Spring Year - 2017 Semester - Spring Year - 2017 Semester - Spring Year - 2017
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Related Tags