Question
The state judicial system is composed of Judges, Defendants, Crimes, Lawyers, and Trials. A Judge has a unique Judge Id, a Name, an Office, and
The state judicial system is composed of Judges, Defendants, Crimes, Lawyers, and Trials. A Judge has a unique Judge Id, a Name, an Office, and a Jurisdiction. Judges preside over Trials. A Trial has a unique Docket Number, a Date, and a Location. Each trial will have only one Judge but a Judge may preside over multiple Trials. It may also be true that at any given time a Judge may not have any Trials assigned to him/her. Defendants are assigned to one Trial. There may be several defendants for a Trial but each defendant must be assigned to only one trial. A Defendant has a Defendant Id, a Name, and an Address. Defendants are also people that have been charged with a specific Crime (or may be charged with multiple crimes). A Crime has a unique Investigation Number, Date, and Description. A crime may have multiple defendants. Defendants hire (or are assigned) a Lawyer to represent them. A Lawyer has a unique Bar License Number, Name, and Office Location. A Lawyer can represent one or zero defendants. A defendant must hire (or be assigned) one and only one lawyer to represent him/her for a particular crime.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started