The star design (often called a star schema) uses a central fact table connected to dimension tables that are not heavily normalized. This creates a clear structure for analytics, while similar approaches like snowflake arrangement feature more normalization in dimension tables and require additional relationships. Other options listed do not accurately describe this simplified structure.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is a star schema?
Open an interactive chat with Bash
How does a star schema improve data analysis?
Open an interactive chat with Bash
What are the differences between star schema and snowflake schema?