Question: Based on the above ERD Diagram, create a Normalization(1NF, 2NF, 3NF) proccess. bdate vaccine_cost aptid tax billnum Bill has company medication_cost payid name paydate pid

Based on the above ERD Diagram, create a Normalization(1NF, 2NF, 3NF) proccess.
bdate vaccine_cost aptid tax billnum Bill has company medication_cost payid name paydate pid coverage_amt generates Payment done by Health Insurance insurancenum pid insurancenum billnum aptid fname pid resdate staffid id staffid aptdate Appointment arranges Staff arranges Follow_up fdate docid Iname phone has reason pid jobtitle has makes has id pid docid phone symptom Person has Side Effects fname Doctor time_of_symptom pid gender Iname speciality duration_of_symptom fname treated by dob gives takes cost type mid mid typeid Iname frequency vaccineid typeid dosage Treatment includes Medications name mstaffid Vaccine_Type has Vaccine medication cost tid side_effect_id docid consumption_time pid given by brand is_imported noted in Medical_stuff id Medical_Records mstaffid phone signed_date pid fname jobtitle vaccineid signedby_docid InameStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
