You have volunteered to automate the record keeping of a small recreational sports league. You are only concerned with this season's data, and do not have a zip code table.
The league consists of teams, each of which has an ID number, a nickname, and a color scheme.
Each team has multiple players. For each player, you want to store first name, last name, address, city, state, zip code, phone number, and skill rating. Each player is on only one team.
Each team also has multiple coaches. For each coach, you want to store first name, last name, address, city, state, zip code, phone number, and "status" (which is 1 for less experienced coaches, 2 for more experienced coaches). Each coach is associated with at most one team per season.
You also want to keep track of games and their outcomes. Each game has a date, a home team, and a visiting team. For games that have been played already, you also want to store the points scored by each team.
Draw an entity-relationship diagram and write a database design outline.