Database Answers St.Stephen's School Logo

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Student Activities 

Back to the Data Model.
The Business Rules have been drafted and are listed below.
The Area being Modelled is :-
Student Activities

A. The Things of Interest include
  • A.1 Activities
  • A.2 Forms
  • A.3 Staff
  • A.4 Students
  • 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
    Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map