Database Answers City Hall
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Legal Case Management Data Model 
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 Best Practice Careers Contact Us Data Models Search Site Map