The Scenario: The Scared Hitless Sofball League (SHSL for short) has grown to th

Question

The Scenario:

The Scared Hitless Sofball League (SHSL for short) has grown to the point where it’s become too challenging to keep track of everything on paper. The league has decided it needs a database to keep track of all of the people and events going on. You’ve been asked to develop a database for SHSL and have met with the owners to discuss the project. The notes you see below are what you’ve taken away from that conversation

• The league is made up of teams who are sponsored by schools. While most schools sponsor only one team, a few of the larger ones sponsor several.

• The league has a group of coaches. To become a coach in the league, one must be qualified for the level the given team is at. A level defines the minimum and maximum weight and age of the players. A given coach can qualify for multiple levels, but he or she must possess the qualification for the level that the team has. The league needs to record the first and last name of the coaches as well as their date of birth and the date the individual was brought on as a coach.

• The league has to keep track of the name of each team as well as the team’s, level, number of wins, coaches, players, and the school the team belongs to.

• Every player who participates in the league must have at least one person who can be contacted in case of an emergency. The database must store the first and last name of each contact person, as well as the date of birth, telephone number, and an optional email address for each contact.

• Every player belongs to a specific team and is assigned a position on that team. Some players may not have a specific position assigned to them yet, but most eventually do. The database must keep track of every player’s first and last name, date of birth, team, position, and emergency contacts.

Question:

1. Provide a complete list business rules, where a business rule describes the relationship between two entities. Since a relationship can be described two ways depending on which entity you start with, a business rule is composed of two sentences, or by a single sentence that contains two independent clauses linked by a conjunction. The nouns should represent the entities in the problem domain, and the verbs should describe how those entities are related. Technically, business rules do not describe the attributes of any of the entities. A complete set of attributes are indicated in the logical data model that is built later.

Explanation / Answer

1. The League is comprised of several Teams and each Team is part of the League

2. The League employs Coaches and each Coach is employed by the League

3. Each Team is sponsored by a School and each School sponsors one or more Teams

4. Each Team is assigned a Level and each Level can be assigned to one or more Teams

5. Each coach is qualified for one or more Levels and each Level can be assigned to one or more Coaches

6. Each Team is comprised of several Players and each Player is part of only one Team .

7. Each Team contains several Positions and each Position can be part of one or more Teams .

8. Each Player may be assigned one Position and each Position can be assigned to one or more Players

9. Each Player provides one or more Emergency Contacts and each Emergency Contact is provided by a Player

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.