Forum Discussion

Oliver2024's avatar
Oliver2024
Regular Visitor
2 years ago
Solved

Data Modeling and Star Schema

I have 7 tables for analyzing school grades. I want to use a star schema, but it doesn't look like a star. I'm thinking about combining the teachers, subjects and classes into the class dimension tab...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    Oliver2024 once you remove relationship between dimterm and dimclasses, it will allow you to make relationship between dimclasses and factsturdentresults to be active (it is inactive now), and that would be the correct approach.

     

    Only other part is that dimteacher and dimsubjects are related to dimclasses and that is making it a snowflake schema. In the ideal world these two tables will have direct relationship with fact table but seems like that is not possible.

parry2k's avatar
parry2k
Super User
2 years ago

Oliver2024 once you remove relationship between dimterm and dimclasses, it will allow you to make relationship between dimclasses and factsturdentresults to be active (it is inactive now), and that would be the correct approach.

 

Only other part is that dimteacher and dimsubjects are related to dimclasses and that is making it a snowflake schema. In the ideal world these two tables will have direct relationship with fact table but seems like that is not possible.