Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

The Morgantown Hockey Association is planning big changes in the coming years. With the construction of a second rink, they also want to create a

The Morgantown Hockey Association is planning big changes in the coming years. With the construction of a second rink, they also want to create a new database to track important information. MHA wants to keep track of its teams and players. For each team, they need to track the teams name, level (8U,12U, etc.), the head coachs name, the assistant coaches names, the rink it will be assigned to, and the number of players in the team. A rink can host multiple teams, but a team can only ever be assigned to one rink. A rink will have an address, a hosting capacity (in number of available skating hours), and a percentage of this capacity that can be dedicated to MHA.
Multiple players play for each team (a new team might not yet have any players). For each player, the league wants to keep track of the first and last names, and the players jersey number. They only track the players most recent team no historical data are stored. One and only one player on each team is designated the captain this also needs to be stored.
Each team has one and only one head coach but one or more assistant coaches. A coach can coach several teams at the same time. For each coach, they need to track the first and last name, all of the coachs phone numbers, and the teams he/she coaches. They also need to track the number of hours each assistant coach spends with each team.
At the end of the season, the league needs to publish a season-end report that lists every player on a roster at the end of the season, and every coach of every team. They also need to list the number of teams playing in each rink.
________________________________________
Draw an object model that shows the necessary data components of this system. If you make assumptions (which you should keep to an absolute minimum!), make sure to list them in detail.
________________________________________

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions