Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Our friend Wally Los Gatos ( see Exercise 2 ) , realizing that his wallcovering business had a few wrinkles, decided to pursue a law
Our friend Wally Los Gatos see Exercise 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 Pjaro 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started