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.