Points: 40 Scenario: Our friend Patrick Maholmes 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 Tom Brady to form Maholmes and Brady, Attorneys at Law. Patrick and Brady 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 ERD based upon the following set of rules: 1. 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). 2. 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. 3. 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. 4. Each CASE is assigned to one and only one COURT. Attributes of COURT are Court ID, Court Name, City, State, and Zip Code. 5. 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. Tasks: 1. (40 points): Draw an entity-relationship diagram for this case. Use WorkBench or hand draw your diagram. 2. Submit your diagram on Canvas Let me know if you have any questions. Note: No late submissions. Late submissions will receive a zero