Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David M. Kroenke, David J. Auer

7th edition

133544621, 133544626, 0-13-354462-1, 978-0133544626

More Books

Students also viewed these Databases questions