Let's say you are chairing a committee responsible for creating and maintaining a schedule for a youth baseball league. To help, you have decided to design a database that will maintain the schedule, contact data for each team, data for each site, and data for the umpires assigned to the game. You'll need to build out the following tables and build the relationships between them:

Games (to capture the home and visiting teams, location and date/time of the game and umpires assigned)

Teams (contact information for each team, such as team name, coach, uniform colors, etc.)

Umpires (names and contact information for the umpires assigned to the game)

Site (game location data such as the field number and address)

Build your model as an ER data model in MySQL Workbench and submit the wbm file.