Create a Crow’s Foot Notation Entity Relationship Diagram (ERD) to support the following business operations: Monash City Council needs a database system to keep track of all the swimming clubs in the council area. Data needs to be kept on each swimming club, members registered in each club, details of member payments, information about the competitions organised and details of coaches. The system needs to keep records of each member registered with these clubs, you need to store the following details about members: Member_ID Member_name Club_ID Member_name, Member_age Contact_no You also need to store details of the coaches Coach ID, Coach’s name, Coach’s phone number, Club_ID (id of the club they belong to)
#Sales Offer!| Get upto 25% Off: