Question
turn this 1NF table into 2NF, and then 3NF? I know I need to use a composite key but I'm sure which one to choose
turn this 1NF table into 2NF, and then 3NF? I know I need to use a composite key but I'm sure which one to choose for 2NF, and then how to progress in 3NF. Any help would be appreciated.
PatientID PO01 PO02 PO02 PO03 PO04 PO01 PO03 Patient Name Kumar Sangakara Babar Azam Babar Azam Rahul Dravid Michael Bevan Kumar Sangakara Rahul Dravid Patient Address Columbo Lahore Lahore Dehli Sydney Columbo Dehli NurselD Nurse Name NO01 N003 NO01 NO02 NO01 NO02 N003 Wasim Akram James Anderson Wasim Akram Glenn Mcgrath Wasim Akram Glenn Mcgrath James Anderson -=== Nurse PhNumber 123456 231243 123456 234561 123456 234561 231243 VaccID V001 V003 V003 V001 VaccName V001 Pfizer Moderna V002 AstraZeneca Pfizer VaccExpiry Moderna Apr-22 Pfizer Jan-22 Apr-22 Dec-21 Jan-22 Jan-22 V002 AstraZeneca Dec-21 Time 10:00 15/03/2021 11:00 10:00 13:00 Date 10:00 9:00 20/04/2021 12/05/2021 14:00 8/04/2021 8/04/2021 3/03/2021 24/03/2021 DoseNumbe r 1 1 2 1 1 2 2
Step by Step Solution
3.46 Rating (162 Votes )
There are 3 Steps involved in it
Step: 1
To convert the given 1NF table into 2NF we need to identify the primary key and then remove any nonk...
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
Financial Accounting and Reporting a Global Perspective
Authors: Michel Lebas, Herve Stolowy, Yuan Ding
4th edition
978-1408066621, 1408066629, 1408076861, 978-1408076866
