Back to the Simple Data Model.
This page defines the Business Rules that the
Data Model must comply with to support an operational Database.
A. What are the Requirements ?
A.1 Performance Monitoring of Daily Student Attendance in a College.
B. What are the Things of Interest ?
B.1 Classes.
B.2 Key Performance Indicators.
B.3 Students.
C. How are they Related ?
C.1 Many Students can attend one Class.
C.2 Many Classes are held on every Day.
C.3 Total Student Attendance is a KPI.
D. What else do we need about them ?
D.1 Total summaries of Student attendances are required on a Daily basis
D.2 These are a KPI with predefined Minimum and Maximum values.
D.3 Comparison against these Min and Max values will result in the display
of a Green or Red indicator,(ie 'Traffic Light').
Barry Williams
6th. May 2003
Principal Consultant
Database Answers