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
