Answered step by step
Verified Expert Solution
Link Copied!

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 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Horse Betting The Road To Absolute Horse Racing 2

Authors: NAKAGAWA,YUKIO

1st Edition

B0CFZN219G, 979-8856410593

More Books

Students also viewed these Databases questions