Doris Daybreak has teamed up with Steve Sunset to form Daybreak and Sunset, Attorneys at Law. Doris and Steve have hired you to design a database system based on the following set of business rules. State any assumptions you make. Draw an ERD using Crows Foot notation.

An attorney is retained by one or more clients for each case

A client may have more than 1 attorney for each case

A client may have more than 1 case

An attorney may have more than 1 case

Each case is assigned to only one court

Each court has 1 or more judges

Each judge is assigned to exactly one court

Minimum Attributes:

Attorney Name, Address, City, State, Zip, Specialty (may be more than one), Bar (may be more than one)

Client Name, Address, City, State, Zip, Phone, Birth Date

Case Case Description, Case Type

Court Court Name, City, State, Zip

Judge Name, Years in Practice