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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started