Question
Given the following unnormalized NYS Vaccination Report for people who have received Covid-19 vaccines in New York State, show your 1NF, 2NF, and 3NF tables
Given the following unnormalized NYS Vaccination Report for people who have received Covid-19 vaccines in New York State, show your 1NF, 2NF, and 3NF tables as you go through the normalization process. Please underline the primary keys and also designate foreign keys using [FK] in the form of:
tblSomeTableName(FieldName1[FK], FieldName2, FieldName3, FieldName4[FK], )
Person ID | Person Name | Zip Code | Person County | Fully Vaccinated | Vac Date | Vac ID | Vac Name | Dose Num | Site ID | Site Name |
1 | Jane Smith | 10038 | Bronx | 1 (Yes) | 2021-02-01 2021-03-22 | 1 1 | Pfizer Pfizer | 1st 2nd | 12 12 | Bronx High Bronx High |
2 | John Lopez | 11210 | Kings | 0 (No) | 2021-02-28 | 2 | Moderna | 1st | 43 | Lincoln High |
3 | Mary Miller | 11373 | Queens | 1 (Yes) | 2021-03-03 | 3 | J & J | 1st | 75 | Citi Field |
Etc |
|
|
|
|
|
|
|
|
|
|
Functional Dependencies (FDs): |
PersonID PersonName, PersonZipCode, FullyVaccinated |
ZipCode PersonCounty |
VacID VacName |
SiteID SiteName |
PatientID, VaccinationDate, VacID DoseNum, SiteID
|
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