Answer:
This schema is used in data warehouse models where one centralized fact table references number of dimension tables so as the keys (primary key) from all the dimension tables flow into the fact table (as foreign key) where measures are stored. This entity-relationship diagram looks like a star, hence the name.
Previous Question | Next Question |
Can you explain me what is meant by Data Analytics? | Tell us what is a mini dimension? |