Johnny decided to pursue a law degree. After graduating, he has teamed up with Jessie to form Johnny and Jessie's 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. Jessie also wants the system to warn her when the load of a lawyer becomes more than the double of the average load.
Johnny and Jessie hired you to design an information system to manage their clients and the cases they take.
2- Identify the themes/ entities for the database.
| 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 |
Entities for the database
Attributes of Entities
Client ------------- ClientName, ClientAddress, ClientPhone
Case ------------ CaseDescription, CaseType
Attorney ------------ AttorneyName, AttorneyAddress, AttorneyPhone
Judge -------- JudgeName, JudgeSince
Do ask if any doubt.
Johnny decided to pursue a law degree. After graduating, he has teamed up with Jessie to...
Johnny decided to pursue a law degree. After graduating, he has teamed up with Jessie to form Johnny and Jessie's 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. Jessie also wants the system...
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...