Wally Los Gatos decides to pursue a law degree. After graduating, he has teamed up with Lyla El Pajaro to form Peck and Paw, Attorneys at Law. Wally and Lyla have hired you to design a database system based upon the following set of business rules. It is in your best interest to perform a thorough analysis, to avoid needless litigation. Please create an ER model based up on the following set of rules: • an attorney is retained by one or more clients, for each case • attributes of attorney are: attorneyID, name (firstName, lastName), address (street, city, state, zipcode), specialty (may be more than one), bar (may be more than one) • a client may have only one attorney for each case • attributes of client are name (firstName, lastName), address, city, state, zipcode, telephone, dateOfBirth • a client may have more than one case • attributes of case are caseID, case_description, caseType • an attorney may have more than one case • each case is assigned to one and only one court • attributes of court are courtID, courtName, city, state, zipcode, country • each court has one or more judges assigned to it • attributes of judge are JudgeID, name, YearsInPractice • each judge is assigned to exactly one court • both judge and attorney attended university • university has attributes: name and address (street, city, state, zipcode)
Wally Los Gatos decides to pursue a law degree. After graduating, he has teamed up with Lyla El Pajaro
to form Peck and Paw, Attorneys at Law. Wally and Lyla have hired you to design a
based upon the following set of business rules. It is in your best interest to perform a thorough analysis, to
avoid needless litigation. Please create an ER model based up on the following set of rules:
• an attorney is retained by one or more clients, for each case
• attributes of attorney are: attorneyID, name (firstName, lastName), address (street, city, state,
zipcode), specialty (may be more than one), bar (may be more than one)
• a client may have only one attorney for each case
• attributes of client are name (firstName, lastName), address, city, state, zipcode, telephone,
dateOfBirth
• a client may have more than one case
• attributes of case are caseID, case_description, caseType
• an attorney may have more than one case
• each case is assigned to one and only one court
• attributes of court are courtID, courtName, city, state, zipcode, country
• each court has one or more judges assigned to it
• attributes of judge are JudgeID, name, YearsInPractice
• each judge is assigned to exactly one court
• both judge and attorney attended university
• university has attributes: name and address (street, city, state, zipcode)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images