Member Avatar for timkonu

i am designing a database for a football league and one of the requirements is Although the match is between two teams, it is common that many players are named in the team but they do not actually participate in that match when it takes place. reserved players and can be called any minute by the coach to join the match.

my confusion is i dont know how to represent this in erd
my main entities are player, teams, and competition
and if the player that was a reserve eventually played how it will be represented as well.
pls if you need more elaboration pls post it
thanks

Edited by timkonu because: n/a
  • 2 Contributors
  • 2 Replies
  • 80 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by timkonu
Member Avatar for drjohn

Reserve: yes/no AND selected: yes/no are probably attributes of a player, not an entity.
So from all the players that belong to a team, some are selected and of those, some are reserves.
However, I'm doing this from your very limited description of your homework ;) homework? yes, it's a common problem to give.

Member Avatar for timkonu

thanks drjohn you just saved my bacon or veg if you are vegetarian! Lol

Edited by timkonu because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.