In star schema representation, a fact table is related to each dimension table in a _____ relationship.
A) many-to-one (M:1)
B) many-to-many (M:M)
C) one-to many (1:M)
D) one-to-one (1:1)

Question

Quizplus · Accepted Answer

In star schema representation, a fact table is typically related to each dimension table in a many-to-one relationship, since a single fact can relate to multiple elements in a single dimension but only one element in each dimension. Therefore, option A) many-to-one (M:1) is the best choice.

In Star Schema Representation, a Fact Table Is Related to Each