A football club has a name, a stadium with a playing ground, and a team made up of players. A player can play for only one club. Each team is managed by a manager, represented by his name. A player has a registration number, name and age. A club manager also buys players. Each club plays against each other club in the league and matches have a date, stadium venue and score.
a) Draw an ER diagram to represent the case above.
b) Discuss how you managed the following:
What factors were considered for choosing entity, attribute and relationship for the above scenario?
Is a club manager the same as a team manager?
How did you represent the ‘league’ in the diagram?