Student GPA Fact or Dimension

View previous topic View next topic Go down

Student GPA Fact or Dimension

Post  BIDW on Thu Mar 12, 2015 1:53 am

I have a requirement to report on student GPA's. In my star schema I have term, course, student and student term (attributes of student per term e.g. college, level etc) as dimensions. I have one fact table which records student course registration. The GPA is generally calculated AT THE END OF EACH TERM. my question is where does GPA related information go. Is it a separate fact table by itself or I could include GPA information as attributes of the student term dimension table.

Thanks

Hunain

BIDW

Posts : 25
Join date : 2015-01-18

View user profile

Back to top Go down

Re: Student GPA Fact or Dimension

Post  ngalemmo on Thu Mar 12, 2015 11:30 am

It can be both. From one standpoint, it is an aggregation of the course facts. But it can also be viewed as a characterization of the student.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Student GPA Fact or Dimension

Post  hkandpal on Thu Mar 12, 2015 11:41 am

Hi ,

It can be a separate fact if you want to see the history of the student's GPA, if you are not interested in seeing the history but only the current GPA then it can be made as a part of student dimension.


thnaks

hkandpal

Posts : 113
Join date : 2010-08-16

View user profile

Back to top Go down

Re: Student GPA Fact or Dimension

Post  BIDW on Sun Mar 15, 2015 12:54 am

Thanks both, this was helpful.

BIDW

Posts : 25
Join date : 2015-01-18

View user profile

Back to top Go down

Re: Student GPA Fact or Dimension

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum