We need to store information about football teams in league matches. The information includes matches (identified by match_id, with attributes location, time) as well as the score of each team for the match, teams (identified by name, with attribute city), players (identified by name, with attributes age and several phone numbers), and individual player statistics (such as score, shooting, foul, etc.) for each match. Note that one player only belongs to one team.
1. Draw an E-R diagram for this database model with primary key underlined.
2. Transform the E-R diagram into a number of relational database schemas, with the primary key underlined.
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|