Search code examples
sqloracle-databasediagramerd

Can someone check if my Entity Relationship Diagram is correct?


I am pretty new at database. I just want to see if my logic is correct or mostly correct (I know I am not 100% correct lol) but I want to see where I am wrong. Please take a look and give some feedback! I made this diagram off of this dataset: https://www.kaggle.com/heesoo37/120-years-of-olympic-history-athletes-and-results/home

Picture of Dataset

ERD

Thank you so much!

(I updated the original diagram!)


Solution

  • Your model isn't too far away. I would structure the tables slightly differently. From here you can join tables in any way you want to go the data you need.

    see model here