Question

Explain what needs to happen to convert a relation to third normal

form

Answer 1

First you must verify that a relation is in both first normal form and second normal

form. If the relation is not, you must convert into second normal form. After a relation

is in second normal form, you must remove all transitive dependencies.

DBMS Interview Questions-Interview Questions and Answers