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
Thank you so much!
(I updated the original diagram!)
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.