Database Answers Ski slopes in Villars, Switzerland

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Performance Monitoring Data Model
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

 

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map