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

A database is needed to track and record the medals won

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Sample Data for reference only. YOU DO NOT NEED TO COPY THE DATA. Just identify the tables. A database is needed to track and record the medals won at the Olympics. Gold, Silver and Bronze metals are...

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...

It is important to review HBR case - Olynpic rent a car case to solve this. Gold Silver Bronze Total All Renters Only Non- Medalists Enterprise Number of Cars Average Days Each Car Is Rented 63 146...

ment3_Description.docx - C... Search (Alt Prabin Giri ces Mailings Review View Help - AEEE 211 . A 1 Normal 1 No Spac... Heading 1 Heading 2 Title Subtitle Subtle Em... Paragraph is Styles B....

B. Scenario The 2022 Commonwealth Games officially known as the XXII Commonwealth Games and commonly known as Birmingham 2022 is an international multi-sport event for members of the Commonwealth...

Problem 1: Getting the Rules Right Suppose you are a member of an Olympic doubles badminton team. The setting we are considering is the 2012 Summer Olympics in London and your team is one of 16 teams...

Watkins Trophies, Inc., produces thousands of medallions made of bronze, silver, and gold. The medallions are identical except for the materials used in their manufacture. What costing system would...

Fixing the payment system at Alvalade XXI: a case on IT project risk management Ramon O'Callaghan Tilburg University, The Netherlands Correspondence: AO'Callaghan, School of Economics and Business...

Question Find the house(s) with the highest score at the end of the athletic meet of a particular year; List all games and the names of the record holders; One query of the student groups choice...

The periodic table can be used to count the protons, electrons, and neutrons of atoms using the atomic mass and atomic number. Note: the periodic table can be used to count the protons, electrons,...

Question 7/24 When a Product Owner adds a new feature/idea in the backlog and brings it up for discussion during refinement session, how should a team respond? Select only one answer. As the Product...

6 7 . 3 % complete Question Which of the following statements describing retirement is true ? A . Individuals who disagree with sacrificing their youth and the prime of their life in an attempt to...

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...

2. When and where did modern economic growth first happen? What are the major institutional factors that form the foundation for modern economic growth? What do they have in common? LO28.2

LO28.5 Explain how the average rate of U.S. productivity growth has fluctuated since 1973.

LO28.2 Define modern economic growth and explain the institutional structures needed for an economy to experience it.