Entity Relationship Modelling Sailing Club Wants Record Results Races Boat Unique Number N Q26368373
(Entity-Relationship Modelling )
A sailing club wants a record of the results of itsraces. Each boat has a unique number. The names of the boats arealso recorded. Each boat has a crew of more than one person. Eachcrewmember has a membership Number, name and phone number and onlysails one boat.
A boat may take part in many races. The race number,start date, start time and wind speed are recorded. The finishingposition of each participating boat is also recorded.
1.Identify the main entity and attributes for the club.
2.Identify the main relationship types and specify themultiplicity for each relationship. State any assumptions you makeabout the data.
3.Using your answers for (a) and (b) draw a single ER diagram torepresent the data requirements for the club withmultiplicities.