Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Page Dewey Chestum and Howe (DCH) Twin provides multiple services to its customers. The firm has grown quickly and is having difficulty keeping up with

image text in transcribed
image text in transcribed
Page Dewey Chestum and Howe (DCH) Twin provides multiple services to its customers. The firm has grown quickly and is having difficulty keeping up with all the various information needs of the firm. OCH form offers many services to its customers (such as Divorce, Bankruptcy, etc.). For each service, the name and approximate legal hours is needed. Attorneys are identified by a timekeeper ID, but the system should also record an attorney's name, home address, telephone, and hourly fee. Attorneys are not able to practice all types of law, but each one has a specialty and several secondary types of law that they practice. It is important to know what types of low each attorney practices as well as knowing the primary area of law. DC them has many customers. Each customer can have 1 active case of each type of law. (For example, Customer lo can have a Divorce case and a Bankruptcy case, but he cannot have 2 active Divorce cases. Joe can have 2 divorce cases, but one must be inactive) it is important to know the customer's name, age birthdates, address, telephone). Each case can have customer assigned to it. There can be up to 3 attorneys assigned. Each attorney on the case has a degration. The attorney can be the responsible, working of originating attorney, Each case can have 1 status. Each case can be only of a particular type of service (Olvorce, Bankruptcy, etc.) Time worked on a case is tracked. You need to know the date, case, amount worked for each case and which attorney did the work. You can have multiple attorneys doing work on a case, but they need to be one of the 3 attorneys listed on the case. The dollar total for the total case depends on what attorney worked on the case and what their hourly fee is. Employee PK Emp ID Lune Frame SSN Birth Date HveDate Attorney PK,FK1 Emp_10 License GadDate Major PK,FKL mp ID Det Works 1. Create the implementation-ready UML class diagram for Dewey Cheatum and Howe lawfirm's data needs in Microsoft Visio, Make sure all of your keys are marked your linkage lines go to the correct fields, your relationship types are marked. This should be a full blow diagram and is a much smaller version of what you will do for the final project. UPLOAD THE VISIO FILE IN ADDITION TO YOUR ANSWERS BELOW Page Dewey Chestum and Howe (DCH) Twin provides multiple services to its customers. The firm has grown quickly and is having difficulty keeping up with all the various information needs of the firm. OCH form offers many services to its customers (such as Divorce, Bankruptcy, etc.). For each service, the name and approximate legal hours is needed. Attorneys are identified by a timekeeper ID, but the system should also record an attorney's name, home address, telephone, and hourly fee. Attorneys are not able to practice all types of law, but each one has a specialty and several secondary types of law that they practice. It is important to know what types of low each attorney practices as well as knowing the primary area of law. DC them has many customers. Each customer can have 1 active case of each type of law. (For example, Customer lo can have a Divorce case and a Bankruptcy case, but he cannot have 2 active Divorce cases. Joe can have 2 divorce cases, but one must be inactive) it is important to know the customer's name, age birthdates, address, telephone). Each case can have customer assigned to it. There can be up to 3 attorneys assigned. Each attorney on the case has a degration. The attorney can be the responsible, working of originating attorney, Each case can have 1 status. Each case can be only of a particular type of service (Olvorce, Bankruptcy, etc.) Time worked on a case is tracked. You need to know the date, case, amount worked for each case and which attorney did the work. You can have multiple attorneys doing work on a case, but they need to be one of the 3 attorneys listed on the case. The dollar total for the total case depends on what attorney worked on the case and what their hourly fee is. Employee PK Emp ID Lune Frame SSN Birth Date HveDate Attorney PK,FK1 Emp_10 License GadDate Major PK,FKL mp ID Det Works 1. Create the implementation-ready UML class diagram for Dewey Cheatum and Howe lawfirm's data needs in Microsoft Visio, Make sure all of your keys are marked your linkage lines go to the correct fields, your relationship types are marked. This should be a full blow diagram and is a much smaller version of what you will do for the final project. UPLOAD THE VISIO FILE IN ADDITION TO YOUR ANSWERS BELOW

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Securing SQL Server Protecting Your Database From Attackers

Authors: Denny Cherry

3rd Edition

0128012757, 978-0128012758

Students also viewed these Databases questions