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....
-
Although the hydrogen electrode may be conceptually the simplest electrode and is the basis for our reference state of electrical potential in electrochemical systems, it is cumbersome to use....
-
What assets constitute property, plant and equipment?
-
Uniform horizontal sheets of water of 3-mm thickness issue from the slits on the rotating manifold shown in Fig. P12.3. The velocity relative to the arm is a constant \(3 \mathrm{~m} / \mathrm{s}\)...
-
The text mentioned a model of predatory pricing in which an incumbent tries to ''beat up'' a rival, exhausting the resources the rival needs to continue operating in the market, causing it to exit....
-
What are some of the factors that determine health behaviors? Identify a health behavior that you struggle to perform? Which theory of health behavior change best relates to your inability to achieve...
-
Ozone gas (O 3 , solute A) dissolved in high-purity water is commonly used in wet cleaning processes associated with semiconductor device fabrication. It is desired to produce a liquid water stream...
-
You deposit $1,000 into a bank account. The account pays 3.75% annual interest compounded monthly. Find the balance after 6 years. Round answers to two decimal places.
-
3. Determine the fillet radius (units of millimeters) such that the maximum stress in the region of the hole is equal to the maximum stress in the region of the step. 40 mm 20 mm 5 mm 13.33 mm
-
Find the force applied by support BC to the gate AB. The width of the gate and support is 3 m and the weight of the gate is 1500 N. B F= ? 4 m 5 m Water 3 m a=50 A, hinge
-
Describe how an engineering firm can use blueprinting to minimize problems which may arise during service encounter?
-
Compute the collection float, the disbursement float, and the net float in dollars in the following table. (Note: by definition, collection float is always considered negative, and disbursement float...
-
The Halleck Company reported the following at the end of the year: (a) notes payable of $2,300, (b) cash of $5,600, (c) retained earnings of $7,300 (d) equipment of $29,100 and (e) inventory of...
-
2. 3. Using the absorbance versus wavelength plot given in Figure I, determine the approximate value of Amax of the dye used to construct this plot. Then using this value of Amax and the color wheel,...
-
The MIT Sloan School of Management is one of the leading business schools in the U.S. The following table contains the tuition data for the masters program in the Sloan School of Management. a. Use...
-
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.
-
\(\mathrm{NaK}(56 \% / 44 \%)\), which is an alloy of sodium and potassium, is used to cool fast neutron nuclear reactors. The NaK flows at a rate of \(\dot{m}=0.8 \mathrm{~kg} / \mathrm{s}\) through...
-
Heated air required for a food-drying process is generated by passing ambient air at \(20^{\circ} \mathrm{C}\) through long, circular tubes \((D=50 \mathrm{~mm}, L=5 \mathrm{~m}\) ) housed in a steam...
-
Liquid mercury at \(0.25 \mathrm{~kg} / \mathrm{s}\) is to be heated from 325 to \(375 \mathrm{~K}\) by passing it through a \(25-\mathrm{mm}\)-diameter tube whose surface is maintained at \(400...
Study smarter with the SolutionInn App