Admission Acceptance Process

Go down

Admission Acceptance Process

Post  businessintelligence on Mon Aug 03, 2015 2:56 am


I am trying to model a student acceptance process. The University offers a student a place, further students have the option to either accept or reject the offer and these statuses could also repeat in any number of combinations. First decline and then accept or vice-versa.

The business is interested to know the latest status of each applicant. How many were offered, how many accepted, how many decline, how many did not reply and so on. They are interested to analyze this data based on the applicant dimension.

Can you suggest what is the appropriate fact table design to answer this question and what is the type of fact table


Posts : 14
Join date : 2015-06-23

View user profile

Back to top Go down

RE:Admission Acceptance Process

Post  hkandpal on Mon Aug 03, 2015 11:44 am


this could be a transactional fact, where in you can capture the students degree level information, course and other information. Also you could store if the student has been accepted, waitlisted, rejected.




Posts : 113
Join date : 2010-08-16

View user profile

Back to top Go down

Back to top

- Similar topics

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