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 coachs 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 teams home field, you need to store all necessary information to identify each teams 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 doctors supervision. For such players, we want to store a 256character text description of the condition, the doctors name, and the doctors 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.