Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beat The Market Win With Proven Stock Selection And Market Timing Tools

Authors: Gerald Appel

1st Edition

0132359170,0137154526

More Books

Students also viewed these Finance questions