Database Answers Pebble Beach

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Police Information Reports
Back to the Data Model.
The Area being Modelled is :-
A Database to store Police Information Reports
A. THE USER REQUIREMENTS :
A simple Database to manage incoming information reports on criminal activity. 
The basic categories of our intelligence reports are "Persons", "Crime Category",
i.e drugs, break & enter etc, "Locations of Interest", "Vehicles of Interest". 
There is a narrative field to describe the criminal activity. 
Each intelligence report is allocated a unique reference number, in the format of 'I 12345678'. 
It should be possible to enter a 'Person of Interest' only once in the database,
 with a photo, then relate that persons involvements to data stored in the locations, 
vehicles, intelligence category tables, and include a description of the the report 
narrative, as information comes in on their activities, like where they go to - 
different locations, where they drive different vehicles. 
Sometimes there are many persons of interest combined in the one report. 
So I would like to be able to find a common way of linking the persons where the 
information report number is the same, Or if there is a better way to 
link the persons who appear in the same intelligence report. 
Australia.
Home Ask a Question Careers Contact us Data Models First Timers Search Site Map