services to our student needs. Now you are tasked to create data warehouse using the data generated so far. This data warehouse will help in analyzing the usage of lab based on time of day, by majors, by student classification, semester, etc. Keep in mind that the focus is not on individual students’ use of lab and hence counts will be used in the fact table based on the dimensions. As a first step, you are going to design a star schema to carry out the dimensional model for the data. You have access to the following two tables and their data dictionaries: UseLog Table Column DataType Date Date Time DateTime StudentID String
Assume our university computer labs keep track of lab usage by students. This data is quite useful for providing adequate services to our student needs. Now you are tasked to create data warehouse using the data generated so far. This data warehouse will help in analyzing the usage of lab based on time of day, by majors, by student classification, semester, etc. Keep in mind that the focus is not on individual students’ use of lab and hence counts will be used in the fact table based on the dimensions. As a first step, you are going to design a star schema to carry out the dimensional model for the data.
You have access to the following two tables and their data dictionaries:
UseLog Table
Column |
DataType |
Date |
Date |
Time |
DateTime |
StudentID |
String |
Student Table
Column |
DataType |
StudentID |
String |
Full/Part |
String |
Classification |
String |
Major |
String |
Answer the following questions:
- Define the main facts to be analyzed. (Hint: These facts become the source for the design of the fact table.)
- Define and describe the appropriate dimensions. (Hint: These dimensions become the source for the design of the dimension tables.)
- Draw the lab usage star schema, using the fact and dimension structures you have defined in the earlier questions.
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)