Home /
Expert Answers /
Computer Science /
show-the-step-by-step-conversion-to-3nf-with-this-show-your-tables-fields-in-the-original-fo-pa541
(Solved): Show the step by step conversion to 3NF. With this, show your tables/fields in the original fo ...
Show the step by step conversion to 3NF. With this, show your tables/fields in the original form, then again as 1NF, then again as 2NF, and finally one last time in 3NF. Indicate Primary Keys.
Edit: Asked to edit question. Can you explain what information you lack?
Doctor D_ID - PK P_ID - FK D_Name Experience Specialty Patient P_ID - PK D_ID - FK P_Name \( D O B \) Address Sex Age
Admitted Admission_No - \( P K \) P_ID - FK Admission_Date Discharge Operations Operation_No - \( \mathrm{PK} \) P_ID - FK D_ID - FK Operation_Date Operation_Time
Ward Ward_No - PK P_ID - FK D_ID - FK Bed_ID - FK Ward_Name Ward_type Bed Bed_ID - PK P_ID - FK D_ID - FK Ward_No - FK Bed_Type
Expert Answer
1. By Group, what is the average age of patients by sex/gender : SQL query : select patSex,avg(PatAge) as 'Average Age' from Patient group by patSex;