Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started