Dimension Table with Composite Key

View previous topic View next topic Go down

Dimension Table with Composite Key

Post  hunain on Sun Oct 27, 2013 4:02 am

I have a section table in my ERP. It contains sections for the courses offered. The columns part of composite key are term code and section. My question is should this be modelled as fact or dimension. if its dimension do i create something as section_key(surrogate) which will uniquely identify a section based on the natural key term code and section. Please also note that section is unique within a term so the same section can be used in another term. please advise. thanks.

hunain

Posts : 19
Join date : 2013-09-15

View user profile

Back to top Go down

Re: Dimension Table with Composite Key

Post  ngalemmo on Sun Oct 27, 2013 10:04 pm

Yes, as a dimension the natural key would be term and section, it would resolve to a unique primary surrogate key. Such an arrangement is very common. As a dimension you would store attributes such as room, capacity, time, etc. The enrollment would be a fact that contains a FK to the dimension.
avatar
ngalemmo

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

View user profile http://aginity.com

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