(Solved): A novice database designer created the following database to track athlete information for the Olymp ...

A novice database designer created the following database to track athlete information for the Olympic Games Paris 2024. It appears that the design was missing the basic concept of database design. Help out by normalizing the database into 3NF and explain what you are doing in each step. Write down the table structures for the normalized data. Athlete(Ath-id, Ath-name, coach, college, college-rep, country, country-president, sport, event-date, attendance, finish-place, metal).