 |
|
|
 |
Back to the Data Model.
The Draft Business Rules have been defined and are listed below.
The Area being Modelled is :-
Athletes and Teams in High School.
The User Requirements have been defined as follows :-
A Database for an athletics department – storing details of :-
Teams, with division, gender, coach
(Student) Athletes data file.
Individuals are selected for a team.
In addition, it is necessary to keep track of the points awarded to each
student for participating in a sport for the awarding of school letters.
The Database has to keep track of student Athletes over five years with any given
Athlete participating in multiple sports in a given year.
B. The Things of Interest, ('THINGS'), include :-
B.1 Athletes
B.2 Events
B.3 Points earned for success.
B.4 Teams
C. These THINGS are Related as follows :-
C.1 A (Student) Athlete can participate in zero, one or many TEAMS.
D. Other Characteristics of these THINGS include :-
D.1
E. Sample Data includes :-
E.1 To be determined
F. Typical Enquiries include :-
F.1 To be Determined
|
|
Barry Williams
6th. May 2004
Principal Consultant
Database Answers
|
|
 |
 |
|