Our friend Wally Los Gatos $($see Exercise $2),$ realizing that his wallcovering business had a few wrinkles, 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 on 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 on 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.