Our friend Wally Los Gatos, realizing that his wallcovering business had a few wrinkles in it, decided

Question:

Our friend Wally Los Gatos, realizing that his wallcovering business had a few wrinkles in it, decided to pursue a law degree at night. After graduating, he has teamed up with Lyla El Pàjaro 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. Create an ERD based upon the following set of rules: 

  • An ATTORNEY is retained by one or more CLIENTS for each CASE. 
  • Attributes of ATTORNEY are Attorney ID, Name, Address, City, State, Zip Code, Specialty (may be more than one), and Bar (may be more than one). 
  • A CLIENT may have more than one ATTORNEY for each CASE. 
  • Attributes of CLIENT are Client ID, Name, Address, City, State, Zip Code, Telephone, and Date of Birth. 
  • A CLIENT may have more than one CASE. 
  • Attributes of CASE are Case ID, Case Description, and Case Type. 
  • An ATTORNEY may have more than one CASE. 
  • Each CASE is assigned to one and only one COURT.
  • Attributes of COURT are Court ID, Court Name, City, State, and Zip Code. 
  • Each COURT has one or more JUDGES assigned to it. 
  • Attributes of JUDGE are Judge ID, Name, and Years In Practice.
  • Each JUDGE is assigned to exactly one court. 

State any assumptions that you have made. Also, draw a data model for this situation using the tool you have been told to use in your course.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Essentials of Database Management

ISBN: 978-0133405682

1st edition

Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman

Question Posted: