Use the RaceResults table to answer the following questions. Hamilton Island 'BoatRaceResults Table RacelD Division BoatName...

Transcribed Image Text:

Use the RaceResults table to answer the following questions. Hamilton Island 'BoatRaceResults Table RacelD Division BoatName BoatSail Num Race Boat Club Handicap RaceDate StartFrom Skipper Place Class Club Suburb 12 122 Division 1 About Time 7700 Bob Redfern 1 12 metre CYCA Daring Pt 30 25/08/2018 Rose Bay Dream 122 Divison 1 Catcher R3 Greg Snow 2 12 metre CYCA Darling Pt 60 25/08/2018 Rose Bay 122 Division 1 Van Diemen 64 Philip Nel 3 12 metre ROYS Newport 121 Division 2 Victoire 84001 David Fuller 1 15 metre MHYC Mosman 121 Division 2 About Time 121 Division 2 Vamp 43218 120 Division 3 Bushranger 120 Division 3 Erica 7700 Bob Redfern 2 Will Price 3 211 Gerry Hatton 1 6838 David Carrie 2 15 meter CYCA Darling Pt 15 meter MHYC Mosman 18 meter RYCV Newport 0 25/08/2018 Rose Bay 180 24/08/2018 Shark is 60 24/08/2018 Shark is 45 24/08/2018 Shark is 30 23/08/2018 Rose Bay 18 meter RYCV Newport 50 23/08/2018 Rose Bay 120 Division 3 Merlin 93 Mark Spring 3 18 meter CYCA Darling Pt 30 23/08/2018 Rose Bay Note: A unique Raceld is created for each new boat race. The functional dependencies of the Hamilton Island BoatRace Results' table are shown below. RaceID → Division, RaceClass, RaceDate, StartFrom RacelD, BoatName Handicap, Place, Skipper BoatName BoatSaleNum, BoatClub BoatClub ClubSuburb Using the Hamon and Baculty Tabaw an Entity Relationship Diagram on a blank piece of paper We "Diagram 1-Handon Island Badacelets ERD Student Number and Student Name at the top of the page You will have 15 minutes to scan and upload an image of your ERD to Camas at the conclusion of your examination Use the RaceResults table to answer the following questions. Hamilton Island 'BoatRaceResults Table RacelD Division BoatName BoatSail Num Race Boat Club Handicap RaceDate StartFrom Skipper Place Class Club Suburb 12 122 Division 1 About Time 7700 Bob Redfern 1 12 metre CYCA Daring Pt 30 25/08/2018 Rose Bay Dream 122 Divison 1 Catcher R3 Greg Snow 2 12 metre CYCA Darling Pt 60 25/08/2018 Rose Bay 122 Division 1 Van Diemen 64 Philip Nel 3 12 metre ROYS Newport 121 Division 2 Victoire 84001 David Fuller 1 15 metre MHYC Mosman 121 Division 2 About Time 121 Division 2 Vamp 43218 120 Division 3 Bushranger 120 Division 3 Erica 7700 Bob Redfern 2 Will Price 3 211 Gerry Hatton 1 6838 David Carrie 2 15 meter CYCA Darling Pt 15 meter MHYC Mosman 18 meter RYCV Newport 0 25/08/2018 Rose Bay 180 24/08/2018 Shark is 60 24/08/2018 Shark is 45 24/08/2018 Shark is 30 23/08/2018 Rose Bay 18 meter RYCV Newport 50 23/08/2018 Rose Bay 120 Division 3 Merlin 93 Mark Spring 3 18 meter CYCA Darling Pt 30 23/08/2018 Rose Bay Note: A unique Raceld is created for each new boat race. The functional dependencies of the Hamilton Island BoatRace Results' table are shown below. RaceID → Division, RaceClass, RaceDate, StartFrom RacelD, BoatName Handicap, Place, Skipper BoatName BoatSaleNum, BoatClub BoatClub ClubSuburb Using the Hamon and Baculty Tabaw an Entity Relationship Diagram on a blank piece of paper We "Diagram 1-Handon Island Badacelets ERD Student Number and Student Name at the top of the page You will have 15 minutes to scan and upload an image of your ERD to Camas at the conclusion of your examination

Answer rating: 100% (QA)

To interpret the given table and answer questions we need to clean up the table and understand the c... View the full answer