Database Answers City Hall

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Case Management
Back to the Data Model.

The Draft Business Rules have been defined and are listed below.
The Area being Modelled is :-
Law Enforcement Case Management.

A. DESIGN NOTES :
A.1 This is a very general design, based on People and Events, and could be applied to 
many other kinds of Events involving People taking different Roles.

B. The Things of Interest, ('THINGS'), include :-
B.1 People
B.2 Associates of Prisoners(also referred to as Guests and Visitors).
B.3 Cases
B.4 Defendents
B.5 Events

C. These THINGS are Related as follows :-
C.1 A Person can be a Defendant in zero, one or many one Defendant Events. 
D. Other Characteristics of these THINGS include :-
D.1 A PERSON has a DATE_OF_BIRTH and a GENDER.

E. Sample Data includes :-
E.1 To be determined

F. Typical Enquiries include :-
F.1 To be Determined
  Barry Williams
13th. March 2003
Principal Consultant
Database Answers
Home Ask a Question Careers Contact us Data Models First Timers Search Site Map