What are the OLAP operations that will allow you to extract the following information from your data mart/warehouse

computer science

Description

STUDY

 

Design a data mart for university consisting of the following dimensions:

student, course, semester, major, and instructor.

1.One set of measure it will be student GPA.

2. Design your dimensions in such a way that you could answer all the sub questions below

Design and Implementation

 a. Logical and physical design

 b. Draw a star-schema model

 c. Discuss what the benefits of designed data mart.

 d. Extend the star schema to snowflake schema.

  f. Populating the data mart

  g. Logical steps in ETL

  h. What are the OLAP operations that will allow you to extract the following information from your data mart/warehouse (ex: drilling)

 I. Highest grade among the students in the course

II. The average GPA for the students in the course for the year 2018.

III. Success rate of students according to courses

Instruction Files
Asg.docx
13.0 KB

Related Questions in computer science category