Question: Detective Bureau: You are going to implement a database system to keep track of evidence and crime. Users of this system are going to be

Detective Bureau: You are going to implement a database system to keep track of evidence and crime. Users of this system are going to be investigators, field officers, and prosecutors. For each user, you should store a unique SSN, name, surname, phone number, password, and address. For field officers, you should also store a location. For each crime scene, you should store a unique scene number, address, and description. Field officers can find evidence in crime scenes. For each piece of evidence, you should store a unique evidence number, object name, description, and finding date. A piece of evidence can belong to exactly one crime scene, but in a crime scene, there could be multiple pieces of evidence. While including a piece of evidence in a crime scene, you should also record the field officer that is responsible for that evidence. Investigators assign field officers to crime scenes; multiple field officers can work at the same crime scene, and a field officer can work in multiple crime scenes. You should keep track of which investigator assigns which field officer to which crime scene on which date. For each suspect, you should store a unique phone number, name, surname, age, and gender. Investigators interrogate suspects to create reports. For each report, you should store a unique report number and report content. Each report should be associated with exactly one suspect and exactly one investigator. The same investigator can create multiple reports and there could be multiple reports for the same suspect. Prosecutors can charge suspects for their crimes, for this purpose an indictment is created. For each indictment, you should store a unique file number, status (Ongoing, Guilty, Not Guilty), crime description, and punishment description. Each indictment should be associated with exactly one suspect and exactly one prosecutor. Pieces of evidence can be related to indictments; in this case, you should also store a text that describes the role of this evidence. One evidence can be related to multiple indictments, and one indictment can be related to multiple evidence. Each piece of equipment is uniquely identified by an equipment name and the SNN of the field officer that owns this equipment. Each piece of equipment can belong to exactly one field officer, and the same field officer can have multiple pieces of equipment. For each piece of equipment, you should also store the date of registration and weight.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!