In Criminal Management System there are different Prisons across country where different criminals across country are kept. There are multiple cells within prisons; each cell can hold multiple prisoners. Each prisoner can get one or more plenty depending upon nature of crime. Each Prison has Administrator which manage the Prisoners. Each Criminal is supposed to do Social work during his imprisonment and this social work is part of its plenty. Beside administrator there are different employees which are also part of prisoner. Task to do: i. Identify Entities with atleast 10 attributes per Entities. ii. Identify all relationship from the given Scenario iii. Generate Entity Relationship Diagram

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter7: Nonlinear Optimization Models
Section: Chapter Questions
Problem 59P
icon
Related questions
Question

Scenario – 3

In Criminal Management System there are different Prisons across country where
different criminals across country are kept. There are multiple cells within prisons; each
cell can hold multiple prisoners. Each prisoner can get one or more plenty depending
upon nature of crime. Each Prison has Administrator which manage the Prisoners. Each
Criminal is supposed to do Social work during his imprisonment and this social work is
part of its plenty. Beside administrator there are different employees which are also
part of prisoner.

Task to do:

i. Identify Entities with atleast 10 attributes per Entities.
ii. Identify all relationship from the given Scenario
iii. Generate Entity Relationship Diagram

Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Optimization models
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,