Multiple choice technology databases

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, each dimension table relates to the fact table in a one-to-many relationship - one dimension record (like Product ID) links to many fact table records (transactions). The dimension is the 'one' side, facts are the 'many' side. Many-to-many would require a bridge table, and one-to-one is atypical in dimensional modeling.

Keep practicing — related questions