Question

Subject : Database

Task #1: Make a database for judiciary system in which you have to define

i)Entities

ii)Attributes

iii)Relationships

iv)Keys implementations

v)Which model you will follow for making this kind of db.

Answer 1

(i) Entities:- Attorney, Client_DETAIL,case_DETAILS,court_DETAILS,judge_DETAILS.

(ii) Attributes:- each attributes are described in ER diagram.

(iii) Relationships:- parent child relation between attorney and case details where attorney_ID in case_DETAILS is referencing to attorney_ID in attorney table.

parent child relation between case_details and court_details

parent child relation between court_details and judge_details

(iv) key implementation:-

ATTORNEY Attorney ID PK) CLIENT_DETAIL Client_ID (PR) Client Name Client Address Client - Phone Case ID (FK) COURT CASE Attornej Attorney Name Address Case Details CaseID Pk) Case Deecription Attorney ID (FK) Asigned COURT-DETAILS Court-ID (PK) Court Name Court Address Case ID (FR) JUDGE_DETAILS Judge ID (PK) Court_ID (FK) Judge Name is designed

(v) Entity relation model is used to describe the database.

DON'T FORGET TO HIT LIKE.

THANKS BY HEART.