Data about the horses that have been awarded top places in events has already been captured in a spreadsheet (an extract from the spreadsheet is shown below). The data has been normalised to first normal form already – underlined column names indicate composite primary key columns. HorseID Horse Name BreedID Breed Name EventID Event Name Place 1 Speedy 1 Thoroughbred 15 Show Jumping 1 1 Speedy 1 Thoroughbred 2 Dressage 5 2 Candy Floss 2 Appaloosa 15 Show Jumping 2 3 Getting Warmer 1 Thoroughbred 2 Dressage 4 4 Mother’s Love 9 Arabian 3 Eventing 3 Normalise the above data to third normal form (3NF). Show all steps as well as the final answer in the form of dependency diagrams
Data about the horses that have been awarded top places in events has already been captured in
a spreadsheet (an extract from the spreadsheet is shown below). The data has been normalised to
first normal form already – underlined column names indicate composite primary key columns.
HorseID Horse Name BreedID Breed Name EventID Event Name Place
1 Speedy 1 Thoroughbred 15 Show Jumping 1
1 Speedy 1 Thoroughbred 2 Dressage 5
2 Candy Floss 2 Appaloosa 15 Show Jumping 2
3 Getting Warmer 1 Thoroughbred 2 Dressage 4
4 Mother’s Love 9 Arabian 3 Eventing 3
Normalise the above data to third normal form (3NF). Show all steps as well as the final answer in
the form of dependency diagrams
Step by step
Solved in 2 steps with 1 images