Answered step by step
Verified Expert Solution
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,
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
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