A star schema has what type of relationship between a dimension and fact table?
-
Many-to-many
-
One-to-one
-
One-to-many
-
All of the above
C
Correct answer
Explanation
In a star schema, each dimension table has a one-to-many relationship with the fact table. One dimension record (like one product) relates to many fact records (many sales transactions). This is the fundamental relationship pattern that enables efficient querying in dimensional modeling. Many-to-many and one-to-one don't describe star schema relationships.