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

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 Finance Questions!