This is the question
“An athlete is allowed to register for up to 7 events and each event will have many athletes competing in it. The system will need to record the athlete ID, their full names and the college they represent and also hold records for each event ID and title. We also want to hold the results attained by each athlete for each event they competed in”.
Use an ER-diagram to model the above requirements and remember to include:
• All primary keys
This is my answer
is the answer correct? or there is a better way of doing it