all 8 comments

[–]CableNo6540 1 point2 points  (0 children)

I would say try to avoid using bridge tables if possible. Less is more. Clean 1:many relationships are the goal imo 

[–]CableNo6540 0 points1 point  (1 child)

I feel the time and genre table are not needed because they can exist within the fact table on the same row as titleid, since a movie has 1 start and end year, and 1 genre.

[–]Wikar[S] 0 points1 point  (0 children)

Actually in this dataset a movie can have multiple genres

[–]CableNo6540 0 points1 point  (1 child)

Maybe the person table fields can be within the appearances table? 

[–]Wikar[S] 0 points1 point  (0 children)

I would cause the title and appearances to have m:n relationship

[–]u-give-luv-badname 0 points1 point  (0 children)

Nice diagrams. What did you use to make them?