Back to the Data Model.
The Business Rules have been drafted and are listed below.
The Area being Modelled is :-
A. The Things of Interest include
A.5 Group Years
A.5 Others to be determined
B. What do we know about The Things of Interest ?
B.1 Activities are available, and each Activity has a cost, name and description.
B.2 Activities are scheduled as and when appropriate.
B.3 A Scheduled Activity has Contact details, eg e. who is running it, where, what days of the week it is run and for how long.
B.4 A Scheduled Activity can be run by one or many members of Staff.
B.5 Each Form has one and only one member of Staff as the Form Teacher.
B.6 A Student can participate in zero, one or many Activities.
B.7 A Student can have one and only in one Address at a time.
B.8 A Student can have a history of multiple Addresses.
B.9 A Student can be in one and only in one Form at a time.
B.10 A Year Group consists of two and only two Forms.
B.11 Others to be determined
© DataBase Answers Ltd. 2009