Member Avatar for sixdegreesunder
sixdegreesunder 0 Newbie Poster

Good evening,
I am trying create new table from 2nf to 3nf but functinal dependencies confusing me. Do you see any errors?

Thank you

PATIENT (VisitNo, VisitDate, PatNo, PatAge, PatCity, PatZip, ProvNo, ProvSpecialty, Diagnosis)
The functional dependencies for the table are:
PatNo  PatAge, PatCity, PatZip
PatZip  PatCity
ProvNo  ProvSpecialty
VisitNo  PatNo, VisitDate, PatAge, PatCity, PatZip
VisitNo, ProvNo  Diagnosis

SECOND NORMAL FORM

PATIENT (VisitNo, ProvNo, Diagnosis)
Foreign key VisitNo references VISIT.
Foreign key ProvNo references PROVIDER.

PROVIDER(ProvNo, ProvSpecialty)

VISIT(VisitNo, VisitDate, PatNo, PatAge,PatCity,PatZip)

THIRD NORMAL FORM:

PATIENT(PatNo, PatAge, PatZip)
Foreign key PatZip references ZIPCODE

ZIPCODE (PatZip, PatCity)

PROVIDER (ProvNo, ProvSpecialty)

VISIT (VisitNo, VisitDate, PatNo)
Foreign key PatNo references PATIENT

PATDIAGNOSIS (VisitNo, ProvNo, Diagnosis)
Foreign Key VisitNo references VISIT
Foreign Key ProvNo references PROVIDER

Edited by sixdegreesunder because: n/a
  • 1 Contributor
  • 0 Replies
  • 57 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.