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
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
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
Scenario
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education