Patient # =1111
Surgeon# = 311
Surgery Date = 12.Jun.95
Patient Name = John White
Patient Address = 15 New St., New York, NY
Surgeon Name = Michael Diamond
Surgery = Kidney stones removal
Drug admin = None
Side effects = Rash
The relation is in 2NF because the relation is in 1NF and it contains no partial dependency.
A relation is in 3NF if there is no transitive functional dependency between non-key attributes.
3NF of the relation above is:
Table 1: Patient #, Surgeon #, Surgery Date, Surgery, Drug Admin
Table 2: Drug admin, Side effects
Comments
Leave a comment