Question: The below table is a sample from a spreadsheet used to record times for a collegiate track and field website. You have been asked to
The below table is a sample from a spreadsheet used to record times for a collegiate track and field website. You have been asked to design and implement a database for this process.
| Meet ID Number | Athlete Name | Athlete Gender | Meet Name | Athlete ID Number | Event ID Number | Event Description | Result |
| 0049
| Joe Bobkin | M | 2020 Bobcat Invitational | 00145
| T100
T200
FLJ
T400 | 100m Run
200m Run
Long Jump
400m Run | 11.58
25.49
12.8
55.78 |
| 0025
| Harry Dunn | M | 2019 Canadian Futures Open | 00158 | T100
T800 | 100m Run
800m Run | 11.58
1:58.02 |
| 0049 | Betsy Smith | F | 2020 Bobcat Invitational | 00191 | T1600
T3200 | 1600m Run
3200m Run | 5:01.45
11:32.89 |
First, transform the table into first normal form and clearly label primary key(s).
Second, transform the table into second normal form by removing partial dependencies. Be sure to include all the information from the original table and clearly label primary key(s).
Finally, transform the table into third normal form, if necessary. Be sure to include all the information from the original table and clearly label primary key(s). If no changes from your answer to question 1.2 are necessary, state why.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
