Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Our friend Vivy 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 Lily to form Vivy & Lily, Attorneys at Law. Vivy and Lily 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. Draw an Entity Relationship Diagram (ERD) based upon the following set of rules: • An ATTORNEY is retained by one or more CLIENTS. • Attributes of ATTORNEY are: Attorney_ID, Name, City, State, Zip_Code, Specialty (may be more than one) • A CLIENT may have more than one ATTORNEY. • Attribute of CLIENT are Client_ID, Name, Address, City and State. • A CLIENT may have more than one CASE. Each CASE belongs to only one CLIENT. • Attributes of CASE are Case_ID, Case_Description, Case_Type. • An ATTORNEY may have more than one CASE. Each CASE belongs to only one ATTORNEY. • Each CASE is assigned to one and only one COURT. A COURT may be assigned to many CASES. • Attributes of COURT are Court_ID, Court_Name, City, State. • Each COURT has one or more JUDGES assigned to it. • Attributes of JUDGE are Judge_ID, Name, Years in Practice. • Each JUDGE is assigned to exactly one court.

Our friend Vivy 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 Lily to form Vivy & Lily, Attorneys at Law. Vivy and Lily 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. Draw an Entity Relationship Diagram (ERD) based upon the following set of rules: • An ATTORNEY is retained by one or more CLIENTS. • Attributes of ATTORNEY are: Attorney_ID, Name, City, State, Zip_Code, Specialty (may be more than one) • A CLIENT may have more than one ATTORNEY. • Attribute of CLIENT are Client_ID, Name, Address, City and State. • A CLIENT may have more than one CASE. Each CASE belongs to only one CLIENT. • Attributes of CASE are Case_ID, Case_Description, Case_Type. • An ATTORNEY may have more than one CASE. Each CASE belongs to only one ATTORNEY. • Each CASE is assigned to one and only one COURT. A COURT may be assigned to many CASES. • Attributes of COURT are Court_ID, Court_Name, City, State. • Each COURT has one or more JUDGES assigned to it. • Attributes of JUDGE are Judge_ID, Name, Years in Practice. • Each JUDGE is assigned to exactly one court.

Fundamentals of Information Systems
Fundamentals of Information Systems
8th Edition
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter3: Database Systems And Applications
Section: Chapter Questions
Problem 3PSE
See similar textbooks
icon
Related questions
Question
Our friend Vivy 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 Lily to form Vivy & Lily, Attorneys at Law. Vivy and Lily 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. Draw an Entity Relationship Diagram (ERD) based upon the following set of rules: • An ATTORNEY is retained by one or more CLIENTS. • Attributes of ATTORNEY are: Attorney_ID, Name, City, State, Zip_Code, Specialty (may be more than one) • A CLIENT may have more than one ATTORNEY. • Attribute of CLIENT are Client_ID, Name, Address, City and State. • A CLIENT may have more than one CASE. Each CASE belongs to only one CLIENT. • Attributes of CASE are Case_ID, Case Description, Case_Type. ● An ATTORNEY may have more than one CASE. Each CASE belongs to only one ATTORNEY. • Each CASE is assigned to one and only one COURT. A COURT may be assigned to many CASES. • Attributes of COURT are Court_ID, Court_Name, City, State. • Each COURT has one or more JUDGES assigned to it. • Attributes of JUDGE are Judge_ID, Name, Years in Practice. • Each JUDGE is assigned to exactly one court.
Transcribed Image Text:Our friend Vivy 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 Lily to form Vivy & Lily, Attorneys at Law. Vivy and Lily 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. Draw an Entity Relationship Diagram (ERD) based upon the following set of rules: • An ATTORNEY is retained by one or more CLIENTS. • Attributes of ATTORNEY are: Attorney_ID, Name, City, State, Zip_Code, Specialty (may be more than one) • A CLIENT may have more than one ATTORNEY. • Attribute of CLIENT are Client_ID, Name, Address, City and State. • A CLIENT may have more than one CASE. Each CASE belongs to only one CLIENT. • Attributes of CASE are Case_ID, Case Description, Case_Type. ● An ATTORNEY may have more than one CASE. Each CASE belongs to only one ATTORNEY. • Each CASE is assigned to one and only one COURT. A COURT may be assigned to many CASES. • Attributes of COURT are Court_ID, Court_Name, City, State. • Each COURT has one or more JUDGES assigned to it. • Attributes of JUDGE are Judge_ID, Name, Years in Practice. • Each JUDGE is assigned to exactly one court.
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Types of Database Architectures
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS