Create an entity - relationship diagram ( ( ERD ) ) for a Tennis League's business
Fantastic news! We've Found the answer you've been seeking!
Question:
Create an entityrelationship diagram ERD for a Tennis League's business environment.
The league needs to store information about teams, coaches, and players.
Key team details include a unique team number, name, city, and manager's name.
Coaches have a unique name within their team and a telephone number. Coaches also possess work experience units, specifying the type and duration. Players have a unique leaguewide player number, name, and age. A coach can have multiple units of work experience associated with them.
Teams have one or more coaches, each working exclusively for one team.
A player can be on multiple teams with details such as the number of years played on a team, and a team can have multiple players.
Related Book For
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel
Posted Date: