Question: The following table shows data about daily COVID testing and the test outcomes. The data in the table is significant. Patient name Date of birth
The following table shows data about daily COVID testing and the test outcomes. The data in the table is significant.
Patient name Date of birth Date tested Outcome Variant if positive Patient birth country Doctor name Doctor birth country
Joseph George Negative UK Dr Matt Smith Australia
Mary Smith Negative Australia Dr Josephina Talbot Australia
Joseph George Positive Alpha UK Dr Rebecca Hammond UK
Tracey Zu Positive Delta India Dr Matt Smith Australia
Alan Fudge Positive Omicron South Africa Dr Nigel Curry UK
Nolleen Harrison Positive Gamma Brazil Dr Darren Rodgers USA
Is the table in second normal form?
Select
Is the table in third normal form?
Select
Is Doctor birth country dependent on Doctor name?
Partially dependent?
Select
Functionality dependent?
Select
Is Variant dependent on Outcome?
Partially dependent?
Select
Functionally dependent
Select
This attribute, or combination of attributes, would be an acceptable primary key:
Patient name
Select
Patient name, date of birth
Select
Patient name, date tested
Select
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
