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 11/08/198601/01/2021 Negative UK Dr Matt Smith Australia
Mary Smith 12/12/199017/03/2021 Negative Australia Dr Josephina Talbot Australia
Joseph George 11/08/198603/04/2021 Positive Alpha UK Dr Rebecca Hammond UK
Tracey Zu 18/07/198812/02/2021 Positive Delta India Dr Matt Smith Australia
Alan Fudge 01/02/195013/01/2021 Positive Omicron South Africa Dr Nigel Curry UK
Nolleen Harrison 15/03/197516/04/2021 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 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 Databases Questions!