Question: 4) The table stores information about infectious disease reports. The DoctorlD is the ID number of the doctor who made the diagnosis. The InfectionLevel represents

4) The table stores information about infectious disease reports. The DoctorlD is the ID number of the doctor who made the diagnosis. The InfectionLevel represents how infectious that disease is (for example, a Cold might be a 3, and COVID might be a 8 . FatalityRate is the percent of people who die from the disease (for example, a Cold might be .03\%, and COVID may be .7) Identity any functional dependencies in the current relation. Convert the relation into a 3NF model and show the referential relationships. (PatientiD, DiseaselD, Date, DoctorlD, PatientName, PatientAddress, InfectionLevel, FatalityRate)
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
