The topical city adolescence union needs a factsbase classification to aid obey trail of manifestation who symbol up to dramatize basketball. Facts needs to be kept on each team, the manifestation who obtain dramatize for each team, and their parents. Also, the facts needs to be kept on the coaches for each team.
Draw a facts design after a while the entities and attributes described short.
Entities required: Team, Player, Coach, and Parent
Team: Team ID sum, team call, and team colors
Player: Player ID sum, Player primeval call, Player ultimate call, and Player age
Coach: Coach ID sum, Coach primeval call, Coach ultimate call, and Coach phone sum
Parent: Parent ID sum, Parent ultimate call, Parent primeval call, Parent phone sum, and residence residence address
Relationships to be defined:
Team is connected to Player.
Team is connected to Coach.
Player is connected to Parent.
Connectivities and participations are defined as follows:
A Team may or may not bear a Player.
A Player must bear a Team.
A Team may bear manifold Players.
A Player has merely one Team.
A Team may or may not bear a Coach.
A Coach must bear a Team.
A Team may bear manifold Coaches.
A Coach has merely one Team.
A Player must bear a Parent.
A Parent must bear a Player.
A Player may bear manifold Parents.
A Parent may bear manifold Parents.