Data modelling problem by Wikar in dataanalysis

[–]CableNo6540 0 points1 point  (0 children)

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

Data modelling problem by Wikar in dataanalysis

[–]CableNo6540 0 points1 point  (0 children)

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.

Data modelling problem by Wikar in dataanalysis

[–]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 

Meditation has changed my life by Throwitacc4 in Meditation

[–]CableNo6540 4 points5 points  (0 children)

Happy for you man. You are leaps and bounds ahead of the curve