normalisation

Question Two: [15 marks] a) What is the purpose of Normalization? Explain in your own words with an example. (5 Marks] b) Normalize the form below into third normal form. Explain the steps. (10 Marks) MUSCAT PHARMACY BILL Bill No :874 Bill Date :10/11/18 Patient Details Doctor Details :8723 Patientid First Name Address Mobile : Adil : Al Khuwair :92369874 Doctor Reg No : 568 First Name : Dr.Khalsa Specialization : Pediatrics Quantity 2 Cost 1.2 Medicine Code LV2 AD1 SC3 Medicine Name Liv52 Adol Scopinal 1.1 1 1 Total Amount 2.4 1.1 1.5 5 1.5 Grand Total