Thread: 3nf
View Single Post
  #1  
Old June 11th, 2004, 10:30 AM
Access Developer
external usenet poster
 
Posts: n/a
Default 3nf

I have the following table:-

tblPatients

PatientID PK
Forename
Surname
NextofKin
NextofKinDetails

I know that it's possible to have more than one patient
who can share the details of the SAME next of kin. Also
the next of kin can be a patient themselves. However if we
ignore these sceanrios for the moment, would the following
changes: -

tblPatients
========
PatientID PK
NOKID FK
Forename
Surname

tblNOK
=====
NOKID PK
Forename
Surname
TelNo


What I am interested in and the difficulty I am having is,
does the creation of tblNOK constitute 2nf OR 3nf? Or does
the the fact that if the 2 points that I asked u to ignore
above would mean 2nf or 3nf. I understand the definitions
of 2nf and 3nf but have difficulty in translating them in
the real world.

Any help would be appreciated.