Draw EERD-A database is required for judiciary to keep record of law. The organization wants to...
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Expert Answer:
Answer rating: 100% (QA)
Solutions Step 1 ER Diagram An EntityRelationship ER diagram is a visual representation used in data... View the full answer
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these programming questions
-
A major supplier to company A offers 30 day payment terms, with a discount of 2% if the account is paid within 10 days. Company A has traditionally paid the supplier within 10 days in order to...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
(d) Consider a straight wire of length 1, and cross sectional area A, carrying a current I, in a uniform magnetic field B. The angle between the direction of current flow and the magnetic field is 0....
-
Set up two pocket mirrors at right angles and place a coin between them. You'll see four coins. Change the angle of the mirrors and see how many images of the coin you can see. With the mirrors at...
-
Think about a recent difficult conversation you had. Ideally, select a conversation that occurred in the workplace or at school. Based on this conversation, do the following: A. Summarize the...
-
When credit sales are $325 plus sales tax of 5%, and there is a bank credit card fee of 3%, what is the debit to Bank Credit Card Expense? (a) $16.25 (c) $341.25 (b) $10.24 (d) $331.01
-
The United Mutual and Accident Insurance Company has a large pool of clerical employees who process insurance application forms on networked computers. When the company hires a new clerical employee,...
-
At Sunland Electronics, it costs $28 per unit ($15 variable and $13 fixed) to make an MP3 player that normally sells for $44. A foreign wholesaler offers to buy 4,670 units at $30 each. Sunland...
-
Mr. Pawan Garg, a wealthy businessman, has approached you for professional advice on investment. He has a surplus of Rs. 20 lakhs which he wishes to invest in share market. Being risk averse by...
-
QUESTION 19 Paul takes out a PLUS loan for $5400. After a year, Paul decides to pay off the interest, which is 7.9% of $5400. How much will he pay 2 answers
-
1. Typical capital budgeting approaches does not account for the potential value of future expansion opportunities which may become available later in the life of the project. a)Provide an example of...
-
Find Vacant 2022, and monthly supply MS using the following: Vacant2021 = 4m SF. Construction2022 = 6m SF. Net Absorption2022 = 1m SF. Gross Absorption2022 = 2.5m SF.
-
John Mayor is an analyst reviewing his valuation of PWS Insurance (PWS).He has the following information and assumptions regarding PWS. The current market price is R67.53. Mayor's estimate of PWS's...
-
Assume a private equity firm raises a $9.4 billion buyout fund and charges a management fee of 1.07%. Calculate the present value of the management fees (in millions) to the private equity firm...
-
For this discussion board assignment, exercise your critical thinking and Google search skills. The string format method used in the textbook is the "new" and "preferred" approach to string...
-
Incorrect Question 21 0 / 7 pts Issacson Inc. has 2,500,000 shares that are currently selling at $30.50 per shares. They are considering making a stock-for-stock offer to acquire The Kissinger Co....
-
Tanaka Company's cost and production data for two recent months included the following: March April Production (units).........300................600 Rent.....................$1,800............$1,800...
-
Ask a database administrator or database or system analyst in a local company to show you an EER (or E-R) diagram for one of the organization's primary databases. Does this organization model have...
-
Contrast the following terms: a. Stored attribute; derived attribute b. Simple attribute; composite attribute c. Entity type; relationship type d. Strong entity type; weak entity type e. Degree;...
-
Drawing on material covered in prior chapters, explain the factors to be considered in deciding whether to create a key index for a table in SQL.
-
What are some of the requirements for audit committees under the Sarbanes-Oxley Act?
-
Why are Cynthia Cooper and Scott Sullivan significant in detecting financial reporting fraud?
-
Why might management be interested in forensic accounting services?
Study smarter with the SolutionInn App