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

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 Iname

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!