Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A law firm proposed the following table to keep track the information about cases and the lawyers who handle the cases: CASE (caseNumber, caseDescription, lawyerInCharge,

image text in transcribedimage text in transcribed

A law firm proposed the following table to keep track the information about cases and the lawyers who handle the cases: CASE (caseNumber, caseDescription, lawyerInCharge, caseAssistant, beginningdate, endingDate, lawyerRate, accumulatedHours, clientsName., clientPhone, clientAdress, clientType, laywerPhone, caseResultDescription, clientCurrentPayment, paymentMethod, salary, bonus) Among above attributes, caseNumber, is the ID of the case lawyerlnCharge is the name of the lawyer (a single person) who is in charge of the case. NOTE : There may be also several staffs in the firm serve as the caseAssistant working for one LawyerlnCharge in a case beginningDate, ending, Date indicate the period of the case lawyerRate, is the lawyer's hourly payrate for the case. accumulatedHours is the total hours of the client service for a case, clientType can be either individual or cooporate, laywerPhone is the phone number of the lawyerInCharge, caseResultDescription gives the description about the case result. clientCurrentPayment shows the total payment from a client currently paymentMethod can be credit card, cash or check, payment method cannot be changed once a case is on file. salary and bonus are paid to the lawyerlnCharge. Bonus depends on the case, salary is not. clientType can be either individual or cooporate, laywerPhone is the phone number of the lawyerlnCharge, caseResultDescription gives the description about the case result. clientCurrentPayment shows the total payment from a client currently paymentMethod can be credit card, cash or check, payment method cannot be changed once a case is on file. salary and bonus are paid to the lawyerInCharge. Bonus depends on the case, salary is not. Answer the following questions carefully a. List Function Dependencies based on above information. Also list the multivalued-dependency given by above narrative. b. What is the KEY for table Case? (hint: the caselD cannot be the key for above table because knowing the caselD only cannot identify the values of some other attributes in this table uniquely.) c. What normal form the table CASE is in? Why? Give a clear explanation. d. Normalize this table. Show your result

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

Strategic Management Awareness And Change

Authors: John L. Thompson , Frank Martin

5th Edition

1844800830, 978-1844800834

More Books

Students also viewed these General Management questions