A database consists of one fact table that is composed of multiple dimensions.

Astar schemahas a central fact table linked to multiple dimension tables. The dimension tables are typically denormalized, meaning data is stored in a flat, non-normalized format for faster query performance. This design enables efficient queries in data warehousing and business intelligence.

CompTIA Data+ Reference:

CompTIA Data+ Study Guide (Exam DA0-001), Chapter 3: Databases and Data Sources, Section “Star Schema Design and Usage”, Official CompTIA CertMaster Learn for Data+, Module 3.6 “Data Warehousing Schemas”.

References Used:

CompTIA Data+ Study Guide (Exam DA0-001) – Official Sybex/CompTIA Book

CompTIA CertMaster Learn for Data+ – Official CompTIA Learning Modules

CompTIA Data+ Objectives (DA0-001)