Question: Which of the following is a characteristic of a star schema in database design?

Options:

1. Highly normalized structure
2. Central fact table with dimension tables
3. Complex relationships between tables
4. Use of many-to-many relationships

Correct Answer: Central fact table with dimension tables

Solution:

A star schema features a central fact table surrounded by dimension tables, providing a simple and efficient structure for data analysis.