CSC 4480: Principles of Database Systems

Phase 1: Project Proposal

Turcotte Hockey School

 

Turcotte Hockey School is a business that specializes in teaching stickhandling skills to hockey players. The school is a traveling operation; a crew consisting of one head instructor and four co-instructors travel to a number of ice rinks in the United States and Canada to conduct week long sessions in the summer, 3 days sessions over the winter holidays, or special sessions.

 

Business Rules

 

1.    An instructor must either be a head instructor or co-instructor. The head instructor supervises the co-instructors in the session. The head instructors are supervised by the school’s owner.

2.    Instructors must specify if they are allowed to work in Canada, the United States, or both. The instructors will receive a work assignment only if they are eligible to work in that country.

3.    Students can be designated current or alumnus. Current students should be assigned to a session. Since the students are children, a parent or guardian will be assigned to him/her. The parent or guardian will be responsible for billing and for receiving information. The students should have current player classification for proper placement.

4.    If a student is under 18 and listed as an alumnus, the school reaches out to the parents through mail and e-mail advertising.

5.    If a student is over 18, the school keeps track of current player status. If they are currently or former professional players, the school may contact the players to use in advertisements.

6.    A camp session must have 1 head instructor and 4 co-instructors assigned. Each session will include information about the location of the session (rink name), address, and city. It should also include enrollment information.

7.    The number of stickhandling moves to be taught at the session depends on the session designation. There are three designations:

 

-       Elite (all the moves)

-       Beginner (12 moves)

-       Intermediate (16 moves)

 

8.    Sessions must be designated summer, winter, or special. Pay for the instructor is contingent on the type of session they work.

9.    The school sells merchandise: hats, t-shirts, jerseys, instructional DVDs, and books. The school keeps track of the point of sale (internet or at arena) and customer information.

10.  The school would also like to monitor enrollment in hockey associations and arenas for feasibility analyses for future expansion.

 

Exceptions:

 

1.    A player cannot register for concurrent sessions

2.    Instructors may not be assigned concurrent sessions.

3.    A parent or guardian will be assessed a fee should they cancel 30 days before a session.

 

Questions:

 

1.    What instructors are assigned to which session?

2.    Are there a sufficient number of students (minimum 24) to make a session profitable?

3.    Where is the point of sale for a merchandise item?

4.    What is the current hockey class standing of a player?

 

Click for EER Diagram

Phase 3: Relational Model