Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Students also viewed these Databases questions

Question

Find Vo in the circuit shown using nodal analysis. 2k +12 V

Answered: 1 week ago

Question

Where those not participating, encouraged to participate?

Answered: 1 week ago

Question

Were all members comfortable brainstorming in front of each other?

Answered: 1 week ago

Question

4. What will the team agreement contain?

Answered: 1 week ago