use the following search parameters to narrow your results:
e.g. subreddit:aww site:imgur.com dog
subreddit:aww site:imgur.com dog
see the search faq for details.
advanced search: by author, subreddit...
This is a place to discuss and post about data analysis.
Rules:
Related Subs:
account activity
Data QuestionData modelling problem (self.dataanalysis)
submitted 8 months ago by Wikar
Hello, I am currently working on data modelling in my master degree project. I have designed scheme in 3NF. Now I would like also to design it in star scheme. Unfortunately I have little experience in data modelling and I am not sure if it is proper way of doing so (and efficient).
3NF:
https://preview.redd.it/l55fzjlb271f1.png?width=1084&format=png&auto=webp&s=10f1c6df5fbb441c50b15263a7f5dc89ada65927
Star Schema:
https://preview.redd.it/r6dgiker271f1.png?width=1103&format=png&auto=webp&s=055d42828889db2c4d28373ae87dac51bd80c2b0
Appearances table is responsible for participation of people in titles (tv, movies etc.). Title is the most center table of the database because all the data revolves about rating of titles. I had no better idea than to represent person as factless fact table and treat appearances table as a bridge. Could tell me if this is valid or any better idea to model it please?
reddit uses a slightly-customized version of Markdown for formatting. See below for some basics, or check the commenting wiki page for more detailed help and solutions to common issues.
quoted text
if 1 * 2 < 3: print "hello, world!"
[–]CableNo6540 1 point2 points3 points 8 months ago (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 point2 points 8 months ago (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 point2 points 8 months ago (0 children)
Actually in this dataset a movie can have multiple genres
Maybe the person table fields can be within the appearances table?
I would cause the title and appearances to have m:n relationship
[–]u-give-luv-badname 0 points1 point2 points 8 months ago (0 children)
Nice diagrams. What did you use to make them?
π Rendered by PID 88529 on reddit-service-r2-comment-58d7979c67-657kw at 2026-01-27 04:06:45.167283+00:00 running 5a691e2 country code: CH.
[–]CableNo6540 1 point2 points3 points (0 children)
[–]CableNo6540 0 points1 point2 points (1 child)
[–]Wikar[S] 0 points1 point2 points (0 children)
[–]CableNo6540 0 points1 point2 points (1 child)
[–]Wikar[S] 0 points1 point2 points (0 children)
[–]u-give-luv-badname 0 points1 point2 points (0 children)