Normalize the below given Patient Prescription Bill to First Normal Form, Second Normal Form and Third...

Transcribed Image Text:

Normalize the below given Patient Prescription Bill to First Normal Form, Second Normal Form and Third Normal Form. (30 marks) PHARMACY INFORMATION SYSTEM, APOLLO HOSPITALS Patient Prescription Bill Bill number: 0000501 Registration Number: 0500010001 Patient Name: Mohsin Doctor ID: 129 Doctor Name: Imaan Bill date: 02-May-2016 Prescription Number: 501 Patient Address: Al Khuwair Patient Category: M Pres. Date Drug ID Drug Name 29/12/2015 1111 19/03/2016 1232 19/03/2016 2425 SYRINGE 21/03/2016 1111 AAAAA 21/03/2016 33 39 PANADOL AAAAA GGGGG Quantity 10 4 10 10 10 Unit Price 2.00 9.00 0.50 2.00 1.00 TOTAL LESS 10% NETT PAYABLE AMOUNT (OMR) Total 20.00 36.00 5.00 20.00 10.00 91.00 9.10 81.90 b) For the finally arrived normalized form in task 3a above, discuss how the redundancy has been minimized. (15 marks) Normalize the below given Patient Prescription Bill to First Normal Form, Second Normal Form and Third Normal Form. (30 marks) PHARMACY INFORMATION SYSTEM, APOLLO HOSPITALS Patient Prescription Bill Bill number: 0000501 Registration Number: 0500010001 Patient Name: Mohsin Doctor ID: 129 Doctor Name: Imaan Bill date: 02-May-2016 Prescription Number: 501 Patient Address: Al Khuwair Patient Category: M Pres. Date Drug ID Drug Name 29/12/2015 1111 19/03/2016 1232 19/03/2016 2425 SYRINGE 21/03/2016 1111 AAAAA 21/03/2016 33 39 PANADOL AAAAA GGGGG Quantity 10 4 10 10 10 Unit Price 2.00 9.00 0.50 2.00 1.00 TOTAL LESS 10% NETT PAYABLE AMOUNT (OMR) Total 20.00 36.00 5.00 20.00 10.00 91.00 9.10 81.90 b) For the finally arrived normalized form in task 3a above, discuss how the redundancy has been minimized. (15 marks)

Answer rating: 100% (QA)

ANSWER a Diagram Ward Whild No Ward Nome Type of Bods wowed relations patient Bat No Sanam Foname ... View the full answer