Working with databases/Assessment overview/Brief

The scenario
After lengthy negotiations, your town now has a minor league baseball team. The team owners and the town government are vigorously promoting the benefits of the new team. As part of their marketing strategy, they are selling items with the new team logo.

The marketing team has asked you to create and update a database that they can use to keep track of their inventory and suppliers.

You will complete the project in three stages:


 * Part 1: Develop a database plan.
 * Part 2: Create the database.
 * Part 3: Use the database to solve a problem

Database specifications
The current inventory is shown in the table below:



Assessment overview