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.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
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.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education