Question

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

1. What normal form is the relation in ?
2. If it is not in 3NF convert into 3NF.Explain your answer.

Answer 1

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