11.8

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 ❄️.