Suppose a university wants to build a Student Record data warehouse with the following information: student, major, course, department, grade. Also, the school would like to calculate student GPA, major GPA etc. Using the idea of the snowflake schema diagram:

1. Write 4 possible Dimensions, example : X(a,b,c,d) ..etc

2. Write a possible fact table including possible measures