Which data modeling approach is optimized for analytical queries with denormalized schemas?
- Third Normal Form
- Star Schema
- Entity-Relationship
- Graph Model
Answer: Star Schema
Star Schema (data warehousing) uses denormalized fact tables linked to dimension tables for fast analytical queries. Optimizes read performance at cost of storage redundancy. Contrasts with 3NF (normalized for OLTP). Critical for BI and analytics architecture questions.