A database is needed to track and record the medals won at the Olympics. Gold, S

Question

A database is needed to track and record the medals won at the Olympics. Gold, Silver and Bronze metals are awarded for each winner of the final competition of each sport.

Normalize the table in the accompanying image to 3NF:

Functional Dependencies:

AthleteNo -> AthleteName, AthleteCountry, AthleteDOB,

SportID -> SportName, SportType,

EventID -> EventDate, EventTime,SportID

AthleteNo, EventID -> SportName, SportType, EventDate, AthleteName, AthleteCountry, MedalWon

Sample Data for reference only AthleteNoAthleteNameAthleteCount AthleteDOB SportID SportName. 3897 8930 EventiD EventDate Event Time MedalWon 72 98 98 19 29 39 SportType 8/12/2016 3:00 pm 8/16/2016 1:00 pm 8/16/2-16 1:00 pm 8/13/2016 10:00 am 8/17/2016 7:00 pm 8/17/2016 9:00 pm Gold Gold Ku Bon-chan South Korea 6/2/1989 Usain Bolt Jamaica JustinGatin USA Estelle Mossely France Nino Schurter Switzerland4/5/1998 David Boudia USA 8/3/1987 5/23/1985 55 7/7/1992 Med Individual Men 100 meters Men 100 meters Women Lightweight Track Track 8234 9035 7873 78 Gold Mountain Biking Mens Cross Country 6/7/1992 Men 10 m platform YOU DO NOT NEED TO COPY THE DATA. Just identify the tables

Explanation / Answer

For 3NF we need to make sure that all the table should be in 2Nf and there
should not be any transiitive dependency of any non prime attribute to the super
key.

The tables are as follows:

Table 1

AthleteNo AthleteName AthleteCountry AtheleteDOB

Table 2

SportID SportName SportType

Table3

EventID EventDate EventTime

Table4

EventID SportID

Table 5

AthleteNo EventID MeadlWon

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---