Bike RacesUSAC Cyclist Cyclist TeamFnameRaceRaceTeamRace NameLocationDateLnameIDTeam NameSponsorRankFlagstaff,AZ Bike Shop 1stNaturalMonster CrossAZ11/1/12 | 67899 WoodsMike4356 AZ Bikes24345 Foreman Jill3333 Health StarsGrocers2ndBike RevBike12345 SmithJoe1122 LocalsRevolution3rd24Hr Mnt BikeSedona,NaturalMadnessAZ9/12/12 24345 | Foreman Jill3333 Health StarsGrocers1stNatural33245 Clark3333 Health Stars4356 AZ BikesSamGrocers2nd67899 WoodsMikeAZ Bike Shop 3rdMorman Lake RoadRaceBike RevBikeFlagstaff,AZ8/22/12 | 12345 SmithJoe1122 LocalsRevolution1stNAU Bike44589 JonesGina6579 ClubNAU2ndBike RevBike12246 SmithKelly1122 LocalsRevolution3rd Based on the above, come up with a fully normalized set of tables. Make sure to document the process of getting there as follows:1. Put the table into first NF. Quickly describe what you did specifically, to get the table into first NF.2. Provide the primary key and spell out the dependencies of the other attributes on the PK by way of a dependency diagram3. Provide the partial dependencies, if any and spell them out in a dependency diagram4. Given the partial dependencies above, if any, show the set of tables in second NF5. Provide the transitive dependencies, spell them out in a dependency diagram6. Given the transitive dependencies above, show the set of tables in third NF7. Provide the crow's foot diagram of your complete model with correct connectivities. This has to be done (in contrast to the above specs that ask you to just "show"tables, which is understood to be hand-drawn) in a professional tool, preferrably mySQLWorkbench.

Race Name Race Location Race Date USAC # Cyclist LName Cyclist RName Team ID Team Name Team Sponsor…

Answered: Based on the above, come up with a…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Bike Races
USAC Cyclist Cyclist Team
Fname
Race
Race
Team
Race Name
Location
Date
Lname
ID
Team Name
Sponsor
Rank
Flagstaff,
AZ Bike Shop 1st
Natural
Monster Cross
AZ
11/1/12 | 67899 Woods
Mike
4356 AZ Bikes
24345 Foreman Jill
3333 Health Stars
Grocers
2nd
Bike Rev
Bike
12345 Smith
Joe
1122 Locals
Revolution
3rd
24Hr Mnt Bike
Sedona,
Natural
Madness
AZ
9/12/12 24345 | Foreman Jill
3333 Health Stars
Grocers
1st
Natural
33245 Clark
3333 Health Stars
4356 AZ Bikes
Sam
Grocers
2nd
67899 Woods
Mike
AZ Bike Shop 3rd
Morman Lake Road
Race
Bike Rev
Bike
Flagstaff,
AZ
8/22/12 | 12345 Smith
Joe
1122 Locals
Revolution
1st
NAU Bike
44589 Jones
Gina
6579 Club
NAU
2nd
Bike Rev
Bike
12246 Smith
Kelly
1122 Locals
Revolution
3rd

Based on the above, come up with a fully normalized set of tables. Make sure to document the process of getting there as follows:
1. Put the table into first NF. Quickly describe what you did specifically, to get the table into first NF.
2. Provide the primary key and spell out the dependencies of the other attributes on the PK by way of a dependency diagram
3. Provide the partial dependencies, if any and spell them out in a dependency diagram
4. Given the partial dependencies above, if any, show the set of tables in second NF
5. Provide the transitive dependencies, spell them out in a dependency diagram
6. Given the transitive dependencies above, show the set of tables in third NF
7. Provide the crow's foot diagram of your complete model with correct connectivities. This has to be done (in contrast to the above specs that ask you to just "show"
tables, which is understood to be hand-drawn) in a professional tool, preferrably mySQLWorkbench.

Expert Solution

Step 1: First NF and Description

Race Name	Race Location	Race Date	USAC #	Cyclist LName	Cyclist RName	Team ID	Team Name	Team Sponsor	Rank
Monster Cross	Flag Staff, AZ	11/1/12	67899	Woods	Mike	4356	AZ Bikes	AZ Bike Shop	1st
Monster Cross	Flag Staff, AZ	11/1/12	24345	Foreman	Jill	3333	Health Stars	Natural Grocers	2nd
Monster Cross	Flag Staff, AZ	11/1/12	12345	Smith	Joe	1122	Bike Rev Locals	Bike Revolution	3rd
24 HR Mnt Bike Madness	Sedona, AZ	9/12/12	24345	Foreman	Jill	3333	Health Stars	Natural Grocers	1st
24 HR Mnt Bike Madness	Sedona, AZ	9/12/12	33245	Clark	Sam	3333	Health Stars	Natural Grocers	2nd
24 HR Mnt Bike Madness	Sedona, AZ	9/12/12	67899	Woods	Mike	4356	AZ Bikes	AZ Bikes Shop	3rd
Moran Lake Road Race	Flag Staff, AZ	8/22/12	12345	Smith	Joe	1122	Bike Rev Locals	Bike Revolution	1st
Moran Lake Road Race	Flag Staff, AZ	8/22/12	44589	Jones	Gina	6579	NAU Bike Club	NAU	2nd
Moran Lake Road Race	Flag Staff, AZ	8/22/12	12246	Smith	Kelly	1122	Bike Rev Locals	Bike Revolution	3rd

By using the above table I have made the four changes such as:

There are only Single Valued Attributes.
Attribute Domain does not change.
There is a Unique name for every Attribute/Column.
The order in which data is stored, does not matter.

Trending now

This is a popular solution!

Step by step

Solved in 7 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions