The following question is based upon the Patient-Treatment relation wch records the details of transactions occurring in a medical surgery. You

Excerpt
and that it will need to be modified in order to work effectively. What are the specific problems associated with the current design and why do they arise?( Illustrate define for problem (Insert/Delete/Update) the give example; Table-> Function dependency ->1nf/2nf/3nf-> the relation is … because…)

The following question is based upon the Patient-Treatment relation wch records the details of transactions occurring in a medical surgery. You may assume the data are representative. PATIENT ID PATIENT NAME PATIENT DOB CONSULT DATE ITEM NUMBER ITEM DESCRIPTION FEE PROVIDER NUMBER DOCTOR NAME 437 REARDON 4/08/1989 19/7/2020 A012 Standard 56 S55768 Leahy 437 REARDON 4/08/1989 20/7/2020 A012 Standard 56 D42433 Meuller 562 BILSTEIN 12/05/2001 20/7/2020 A013 Short 35 S55768 Leahy 361 WILSON 13/08/1997 20/7/2020 A014 Long 75 S55768 Leahy 895 LEMOS 13/10/1952 20/7/2020 A013 Short 35 D42433 Meuller 895 LEMOS 13/10/1952 20/7/2020 A014 Long 75 D42433 Meuller 678 MORTAL 27/02/1969 20/7/2020 A014 Long 75 S55768 Leahy 432 SOAPIER 1/08/1976 21/7/2020 A012 Standard 56 S55768 Leahy You have been asked to design a relational database for ts system. You know that there are problems with the current design and that it will need to be modified in order to work effectively. What are the specific problems associated with the current design and why do they arise?( Illustrate define for problem (Insert/Delete/Update) the give example; Table-> Function dependency ->1nf/2nf/3nf-> the relation is … because…)

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer