Multiple choice technology web technology

A star schema has what type of relationship between a dimension and fact table?

  1. Many-to-many

  2. One-to-one

  3. One-to-many

  4. All of the above.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In a star schema, the relationship between a dimension table and fact table is one-to-many - one dimension record relates to many fact records (Option C). Option A (many-to-many) is incorrect because star schemas don't have direct many-to-many. Option B (one-to-one) is wrong because dimensions describe multiple facts. Option D is incorrect since the relationship is specifically one-to-many.

Keep practicing — related questions