What is 3NF?

Answer

A relation schema R is in 3NF if it is in 2NF and for every FD X A either of the following is true

  1. X is a Super-key of R.
  2. A is a prime attribute of R.

In other words, if every non prime attribute is non-transitively dependent on primary key.

All database Questions

Ask your interview questions on database

Write Your comment or Questions if you want the answers on database from database Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---