Consider each of the takes and teaches relations as a fact table; they do not have an explicit measure attribute, but assume each table has a measure attribute reg_count whose value is always 1. What would the dimension attributes and dimension tables be in each case. Would the resultant schemas be star schemas or snowflake schemas?
Dimension attributes:
- Dimension attributes of the takes relation: ID, course_id, sec_id, semester, year, grade
- Dimension attributes of the teaches relation: ID, course_id, sec_id, semester, year
Dimension tables:
- Dimension tables of the takes relation: student, section, course, department, classroom, time_slot
- Dimension tables of the teaches relation: instructor, section, course, department, classroom, time_slot
The resultant schema would be a snowflake schema ❄️.