You have been requested to develop a database to record the registration and competition results for a regional gymnastics meet.The competition is expected to include 250 gymnasts from eighteen gymnastics clubs.Each of the gymnasts is expected to enter an average of two events.The system will be used to record entries, produce event catalog and scoring sheets, record individual scores, and produce reports to send to the national organization.

Sample of Reports Required:Clubs and Club Contacts (alphabetical order)

Gymnasts and Club (alphabetical order)

Event with competitors (events in alpha order, competitors in numerical order)

Sample data from Excel Spreadsheet currently used to maintain data:

Gymnast#GymnastNameClubNameClubContactClubPhoneEventTimeScoreJudge

101Clark, SheilaThomasville TigersMaria Garza309-584-9987Balance Beam11:009.250Owen

101Clark, SheilaThomasville TigersMaria Garza309-584-9987Uneven Bars1:008.325Mercer

101Clark, SheilaThomasville TigersMaria Garza309-584-9987Floor Exercise3:008.650Owen

103Dyer, JennaCapital CougarsNancy Taylor217-632-0207Uneven Bars1:008.550Mercer

104Shanahan, MandyParkerville PanthersChia-Jung Li618-778-9042Balance Beam11:006.875Owen

104Shanahan, MandyParkerville PanthersChia-Jung Li618-778-9042Floor Exercise3:008.900Owen

104Shanahan, MandyParkerville PanthersChia-Jung Li618-778-9042Vault9:009.100Thomas

105Nguyen, TrinhCapital CougarsNancy Taylor217-632-0207Balance Beam11:009.125Owen

105Nguyen, TrinhCapital CougarsNancy Taylor217-632-0207Vault9:009.585Thomas

106Monroe, BettyThomasville TigersMaria Garza309-584-9987Floor Exercise3:008.750Owen

Analyze the data provided and develop a set of normalized tables to use to record this data in the database system.You should use the data presented in the spreadsheet to define the relationships between entities.