Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw EERD-A database is required for judiciary to keep record of law. The organization wants to keep record of prisoner and their cases information.

Draw EERD-A database is required for judiciary to keep record of law. The organization wants to keep record

Draw EERD-A database is required for judiciary to keep record of law. The organization wants to keep record of prisoner and their cases information. The prisoner has the unique number name address the perisoner commit different type of crimes. The crime has unique number, punishment type and duration. The crime can be medium, low and high risk crime. Minimum security prisons are usually reserved for white collar criminals who have committed acts such as embezzlement or fraud. Although these are serious crimes, they are non- violent in nature and therefore the perpetrators are not considered to be a risk for violence. These perpetrators are sent to facilities that offer a dormitory-type living environment, fewer guards, and more personal freedoms, The characteristic of this type is living environment and punishment duration. Medium security prisons are the standard facilities used to house most criminals. They feature cage-style housing, armed guards, and a much more regimented daily routine than minimum security. The attributes for this type of crime are punishment amount High security prisons are reserved for the most violent and dangerous offenders. These prisons include far more guards than both minimum and medium security, and very little freedom. Each person confined to such a prison is considered to be a high-risk individual. The attributes of high security risk are date of committed crime and severity level. The persior may commit one or all type of crime. The crime committed by any prisoner have hearing. The cases are of two type either the cases has been closed and their final result has been saved. Or the hearing is continues. In case of continues case the date of next hearing and record of previous findings are store.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Solutions Step 1 ER Diagram An EntityRelationship ER diagram is a visual representation used in data... 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

Step: 3

blur-text-image

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

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Programming questions

Question

mple 10. Determine d dx S 0 t dt.

Answered: 1 week ago