Answer to Question #245636 in Databases | SQL | Oracle | MS Access for Sonu

Question #245636

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.
1
Expert's answer
2021-10-03T04:01:24-0400

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 

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS