PatientID PatientName BloodID BloodType ExamDate P7010 08/01/2020 D5001 08/01/2020 D3222 |11/11/2020 D5001 11/11/2020 D7788 |15/11/2020 D5001 |12/12/2020 D3222 |12/12/2020 D5001 DiseaselD DiseaseDesc...


b) Based on the sample data shown in the PatientDiseaseExam table above, provide each of the following data anomalies with a specific example:
(i) Insertion anomaly
(ii) Modification anomaly
(iii) Deletion anomaly


PatientID PatientName BloodID BloodType ExamDate<br>P7010<br>08/01/2020 D5001<br>08/01/2020 D3222<br>|11/11/2020 D5001<br>11/11/2020 D7788<br>|15/11/2020 D5001<br>|12/12/2020 D3222<br>|12/12/2020 D5001<br>DiseaselD DiseaseDesc HospitallD HospitalName<br>Hospital KL<br>Hospital KL<br>Hospital PJ<br>Hospital SB<br>Hospital SB<br>Hospital KL<br>Hospital PJ<br>Alice<br>Alice<br>BO01<br>A+<br>COVID-19<br>H223<br>P7010<br>P7010<br>P8888<br>B001<br>B001<br>A+<br>Diabetes<br>H223<br>Alice<br>Thomas<br>Penny<br>Penny<br>Julie<br>A+<br>COVID-19<br>H881<br>B008<br>0-<br>SARS<br>Н666<br>P3000<br>B009<br>B009<br>BO08<br>AB+<br>COVID-19<br>Н666<br>P3000<br>AB+<br>Diabetes<br>Н223<br>P4455<br>O-<br>COVID-19<br>Н881<br>Table 1: Details of PatientDiseaseExam Table<br>

Extracted text: PatientID PatientName BloodID BloodType ExamDate P7010 08/01/2020 D5001 08/01/2020 D3222 |11/11/2020 D5001 11/11/2020 D7788 |15/11/2020 D5001 |12/12/2020 D3222 |12/12/2020 D5001 DiseaselD DiseaseDesc HospitallD HospitalName Hospital KL Hospital KL Hospital PJ Hospital SB Hospital SB Hospital KL Hospital PJ Alice Alice BO01 A+ COVID-19 H223 P7010 P7010 P8888 B001 B001 A+ Diabetes H223 Alice Thomas Penny Penny Julie A+ COVID-19 H881 B008 0- SARS Н666 P3000 B009 B009 BO08 AB+ COVID-19 Н666 P3000 AB+ Diabetes Н223 P4455 O- COVID-19 Н881 Table 1: Details of PatientDiseaseExam Table

Jun 04, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?