A law firm needs a database system based upon the following

A law firm needs a database system based upon the following set of business 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, and Specialty. An attorney may be more than one Specialty. 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.

Solution

The database system develop using the business logic will have following tables:

i) ATTORNEY_TABLE(ATTORNEY_ID, ATTORNEY_NAME, ATTORNEY_ADDRESS, ATTORNEY_CITY, ATTORNEY_STATE, ATTORNEY_ZIPCODE, ATTORNEY_SPECIALTY, CASE_ID)
ii) CLIENT_TABLE(CLIENT_ID, CLIENT_NAME, CLIENT_ADDRESS, CLIENT_CITY, CLIENT_STATE, CLIENT_ZIPCODE, CLIENT_TELEPHONE, CLIENT_DOB, ATTORNEY_ID)
iii) CASE_TABLE(CASE_ID, CASE_DESCRIPTION, CASE_TYPE)

Here ATTORNEY_ID is primary key in ATTORNEY_TABLE.
Here CLIENT_ID is primary key in CLIENT_TABLE
Here CASE_ID is primary key in CASE_TABLE