Business Case: Marching Band Competition

Drum Corps International (DCI) organizes marching band and drum corps competitions all over the world. They require a database that can keep track of registered students that form teams who then participate in the competitions. For each team member we need to keep track of their personal information (name, address, date of birth, etc.) and associate them with their team. The team has a team name, team colors and mascot. Each team also has a coaching staff (for example). For each staff member we need to keep track of their personal contact information as well as their staff role and associate them with the team. Competitions are scheduled throughout the year. We need to keep track of when each competition starts and ends (date and time), the location for the competition, and which teams enter the competition. Prizes are awarded

Do the following:

1. An E-R diagram with all of the entities, attributes, identifiers and relationships. Be sure all relationships are labeled appropriately with verb phrases and the diagram includes an appropriate legend (Name of the Model, Created by, Date/Time, Your Name and Course information, etc.)

2. A set of Relationship Sentences

3. The initial set of relations resulting from the conversion from E-R to relational. Clearly indicate keys and foreign keys.