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, each dimension table has a one-to-many relationship with the central fact table. A single dimension record (like one product) relates to many fact records (many sales transactions). One-to-many is the defining characteristic that enables efficient querying.

Keep practicing — related questions