Youth Baseball League: You want to keep records for your local area youth baseball league, as follows:
Each player can only be on one team. For each player, you want to keep first name, last name, home address, and phone number.
Each team has a name, a mascot, and a shirt color.
Teams may have more than one coach, but each coach works only for one team. You want to store each coach’s first name, last name, home address, phone number, and mobile phone number.
Each team has a home field where it holds practice sessions and home games. Each field has a name and address information. Several teams can have the same home field.
In addition to knowing each team’s home field, you need to store all necessary information to identify each team’s players and coaches.
Assume that you do have the master zip code table available.
A small minority of the players have medical conditions and play under a doctor’s supervision. For such players, we want to store a 256‐character text description of the condition, the doctor’s name, and the doctor’s phone number.
Design the database so that you do not need to rely on blank fields to indicate that a player does not have medical supervision — that is, keep medical data in a separate table, only for players who need it.
