Naveen Rao

@naveenrao

Free member

Consultant helping teams ship reliable GCP workloads.

Bengaluru, Karnataka0–2 years1 questions2 answers

GCPRedshiftAzure

Streak: 0d
XP: 154
Lessons done: 3
Studio passes: 0

First Lesson

Share on X Share on LinkedIn

Questions

votes

answers

views

Bridge table for a many-to-many relationship, normalize or denormalize?

Students can enroll in multiple courses, courses have multiple students. Building the warehouse model, a bridge table between fact_enrollment and dim_course/dim_student, or denormalize course info directly onto the enrollment fact?

Data Modelingmodelingbridge-table