Image Courtesy www.tutorialandexample.com Q. What is First Normal Form (1 NF )? The domain of attribute must include only atomic values. Q. What is Second Normal Form ( 2NF)? A relation schema R is in 2NF if it is in 1NF and every non-prime attribute A in R is fully functionally dependent on primary key. Q. What is Third Normal Form (3NF)? 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.
A digital gateway to Assam’s culture, heritage, tourism, history, and development