Assignment No#03
Submitted To: Sir Ashar
Submitted By:
Hamza Ali Minhas (22-Arid-4363)
Program: BSCS 2n°
Submission Date: 08 June, 2023
ASSIGNMENT # 3
Draw EBRD and relational schema of following case study
Draw an EER diagram for the fallowing description of a law firm. Each case
handled by the firm has a xnrqxe case number; a date opened, date closed, and
judgment description are also kept on each case. A case is brought by one or
more plaintiffs, and the same plaintiff may be involved in many cases. A plaintiff
has a requested judgment characteristic. A case is against one or more
defendants and the same defendant may be involved in many cases. A plaintiff
or defendant may be a person or an organization. Over time, the same person
or organization may be a defendant or a plaintiff in cases. In either situation,
such legal entities are identified by an entit y number, and other attributes are
name and net worth. A database is required for judiciary ta keep record af law.
The organization wants to keep record of prisaner and their cases information.
The prisoner has the unique numher name address . the perisoner commil
different type of crimes. The crime has unique number, punishment I ype and
duration. The crime can be medium, low and high risk crime. Minimum securit y
prisons are usually reserved for white collar criminals who have committed acts
such as embemlement 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 Iype is living environment and punishment duration.
Medium securit)! prisons are the standard facilities used to house most
criminals. The y feature cage-style housing, armed guards, and a much more
regimented dail y routine than minimum securit y. The attributes for this type of
crime are punishment amount High securit y 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
cnrifined ta 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 Iype 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
Relañonal schema for EERD:
e cid, dateqopened, dateqclosed, description j
ibid,name, netqworth, req udgr cha oreign key
referencing cases),pidporeign key references person ), oidporeign
key references organization))
de(endantsldid, name, netpworthforeign key referencing cases),
pidiforeign key references person ),org_idfioreign key
references organi tion))
orgonijotion(org_id, name, netqworth)
r erson_id, name, address)
i ersonqid, name, address,prison idlforeign key references
ri rison id, name, address, type)
ice crimeqid, punish type, duration, risk level)
commit(crime_idfioreign key references
crime),person_idfloreign key references prisoner))
hearing(hid, date, pre_finding,crimeqidporeign key referencing
crime))
