Below are the tables and attributes for the Hillside College club championship: Coach (CoachID, CoachName) Member (MemberID, MemberEmail, MemberName, CoachID) Registration (MemberID, EventID, MemSecEvent) Event (EventID, EventName) You are expected to draw an ER-Diagram for the club championship using UML notation.
warning ::
Solve only if you can, dont copy paste. i will report your account.
correct answer will get 4 likes from me.
Solve only id you are seeing this question before 5:30 pm (15/06/2021) deadline for assignment submission.
if you rejected this question ,then i will report your account to bartleby! so,if you dont no the answer then simply skip. do not reject.
SUB:
You have been coaching athletics at the Hillside College club for the past year. The yearly club championship is upcoming and you were asked to assist with the design of a database for the championship. The organizing committee of the championship provided you with the following information regarding the athletics championship:
- Each member of the club is uniquely identified by their ID number.
- The name and email address of each member must also be stored.
- Each member can be trained by only one coach.
- A member is not allowed to register for the championship without a coach.
- All coaches in the database must train at least one member.
- One coach can train a maximum of ten members.
- Each coach is uniquely identified by their ID number, and the name of the coach must also be stored.
- Each member in the club is required to have at least one registration but can only have a maximum of four registrations.
- Each row in the registration table, is required to be linked to one member and one event respectively.
- One event can have a maximum of twenty registrations but it might happen that there are no registrations for a particular athletics event.
- Each track event is uniquely identified by an ID number and the name of the track event must also be stored.
- After each track event, the registration table should be updated to store the time achieved by the member in seconds for the particular event and stored in the MemSecEvent attribute.
Below are the tables and attributes for the Hillside College club championship:
Coach (CoachID, CoachName)
Member (MemberID, MemberEmail, MemberName, CoachID)
Registration (MemberID, EventID, MemSecEvent)
Event (EventID, EventName)
You are expected to draw an ER-Diagram for the club championship using UML notation.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
