Database Answers City Hall
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Legal Case Management Data Model 
You can ask for an Access Database, but you must enter a Subject, otherwise your email will be treated as Spam.
The Business Rules have been drafted for the Data Model.

Design Notes :-
1) This is a specific example of a more general design, based on Organisations, People and Events.
2) Reference Data, such as Address Types, Organizations Types and Roles, is not shown on this diagram.
This makes the diagram easier to read and understand. The existence of Reference Data is implied anywhere you see a '_code' field.


Case Management Data Model


Barry Williams
21st. April 2004
Principal Consultant
Database Answers Ltd.
London, England

 

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