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

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

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: 

  1. Define the main facts to be analyzed. (Hint: These facts become the source for the design of the fact table.) 
  1. Define and describe the appropriate dimensions. (Hint: These dimensions become the source for the design of the dimension tables.) 
  1. Draw the lab usage star schema, using the fact and dimension structures you have defined in the earlier questions. 
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY