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

Transcribed Image Text:

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. 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.

Answer rating: 100% (QA)

Solutions Step 1 ER Diagram An EntityRelationship ER diagram is a visual representation used in data... View the full answer