Database Answers Zurich, Switzerland (Click for Zurich Web Site)
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Criminal Record Keeping 
Back to the Data Model
Subject: Criminal Record Keeping

Question: I would like to know how can i make a er diagram for a criminal record Project Description 

The government of the Republic of Wonderland has tasked you as an expert database programmer to 
improve their current manual criminal record keeping in their Ministry of Justice. 

All criminal records are currently recorded manually, 

this process is quite tedious as you may imagine and not reliable as it happened in the past that a 
number of case documents went missing. 

Your task is to design and implement a case database management system that fulfills these general 
requirements listed below: 

1. The prosecutor should be able to create a new case based on the docket provided by the police officer. 
   The docket contains all the relevant information about the complainant and the accused person 
   (e.g. ID, name, residential physical address, telephone, etc), date of arrest, whether or not finger 
   prints has been taken, type of case (e.g. criminal or civil) and type of offence (e.g. if it?s criminal 
   it could be stock theft, rape, robbery, assault, etc and if it?s civil could be divorce, maintenance, 
   defamation of character, etc) 

   The prosecutor should also indicate which magistrate office it is (e.g. Gobabis, Windhoek, Keetmanshoop, etc) 
   and then specify in which court the matter is to be heard (e.g. court A, court B, court C), 
   enter the date of hearing and the names of the people that would be involved in the case the Magistrate, 
   Prosecutor, Interpreter, Investigation Officer and at least one witness. 
   Once all the required information is captured a case record number (CRN) is automatically generated by the system. 

2. If the prosecutor wants to add another accused person on the same case, she / he should be able to search the 
   case using the CRN and then update that case accordingly 

3. The magistrate then update the case status as the case proceed to; convicted, acquitted / not guilty, 
   postponed to a specific date and the reason for postponement, bail granted, withdrawn and the time taken for the 
   court session. 

4. The minister would like the system to generate the following reports for statistical analysis:  Hours spent, 
   should display the total hours spent on each type of case, 
   the case type should be inputted by the user  
Display the most type of offence reported so far Page 3 of 3  

Chronological display of the type offence that most people are most convicted off 
Barry Williams
August 27th. 2011
Principal Consultant
Database Answers
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map