The following question is based upon the Patient-Treatment relation which records the details of transactions occurring in a medical surgery. 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
The following question is based upon the Patient-Treatment relation which records the details of transactions occurring in a medical surgery. 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 |
Design a relational
- What are the specific problems associated with the current design and why do they arise?
- How would you change the current design and how does your new design address the problems you have identified with the current design.
Step by step
Solved in 5 steps with 3 images