Question on enrollment_term_id

[rubyn]

Is there always a 1:1 relationship between a course and enrollment term (I believe a course can only exist in one term at a time, but wanted to confirm)?  Also, we see enrollment_term_id in the quiz_submission_fact and submission_fact, but not in the requests table.  For requests, looks like we need to go through course_dim to get enrollment_term.  Is that by design?  Please advise, thanks!

[mlewis23]

Yes, a course should only be in a single term.

I too noticed this and also went through the course_dim with requests.

[msmith · Accepted solution]

Matt is correct there should be only a single enrollment term per course.   Not including the enrollment id in the requests table is an oversight.   We have this same problem in other tables as well.   One of our tasks before release is to take a pass over the schema and make sure all foreign keys are denormalized transitively.   We will try to make this happen as early as possible. Joining through course_dim is a good work around for now and will continue to work in the future.