Question

Hussam Jabali decided to pursue a law degree. After graduating, he has teamed up with Layal Jbeily to form Jabali and Jbeily Law office.

As the team started growing and the business picked up, they realized they need to be able to print reports about the cases of their clients, the cases of each lawer, the cases in each court and with each judge. To do that they want to input the data when it is generated. Layal also wants the system to warn her when the load of a lawyer becomes more than the double of the average load.

Hussam and Layal hired you to design an information system to manage their clients and the cases they take.

1- Identify 10 requirements of the new system (you can make some up as long as they are in line with the case).

2- Identify the themes/ entities for the database

3- Draw the E-R diagram, using visio or word - make sure to use the convention we have used

4- Design the database . For each table you must provide the table name, list of fields, PK (primary key), FKs (when applicable).

Client name	Client address	Client phone	Case description	Case type	Attorney	Attorney Address	Attorney Phone	Court	Judge	Judge since
Franck House	45 blue avenue	01-222333	Office rental contract	Corporate	Ben Jelly	55 Laurier av.	01-999888	Beirut	Judge Thomas	2010
John Card	37 5th avenue	01-333444	Home rental contract	Personal	Peter Blake	152 Mont Royal	01-999777	Saida	Judge White	2005
Helena Mara	122 white boulevard	01-444555	Lawsuit against Tom Green	Personal	Ben Jelly	55 Laurier av.	01-999888	Saida	Judge White	2005
Kate White	63 blue avenue	01-555666	Merger contract	Corporate	Los Gatos	22 Britany	01-999666	Tripoli	Judge Greene	2016
Franck House	45 blue avenue	01-222333	Will	Personal	Los Gatos	22 Britany	01-999666	Beirut	Judge Thomas	2020
John Card	37 5th avenue	01-333444	Lawsuit against Ted Brown	International	Peter Blake	152 Mont Royal	01-999777	Beirut	Judge Thomas	2004
Helena Mara	122 white boulevard	01-444555	New product	Corporate	Ben Jelly	55 Laurier av.	01-999888	Tripoli	Judge Greene	2013
Kate White	63 blue avenue	01-555666	Establishing a company abroad	International	Los Gatos	22 Britany	01-999666	Beirut	Judge Thomas	2010
Franck House	45 blue avenue	01-222333	Lawsuit against XYZ	Personal	Lyla El Pajaro	23 Bernard	01-999555	Beirut	Judge Brown	2018

Answer 1