Can anyone explain Normal Forms in short?
4 posters
ramthegreatcv- Posts : 55
Join date : 2009-01-30
Age : 36
Correct me if wrong!
Beagle Sun Feb 01, 2009 3:10 am
1NF = All attributes need to have atomic data.
2NF = Relation should be in 1NF, but attributes should be transitively or otherwise dependent on the primary key.
3NF = Should be in 2NF, but all the transitive dependencies are to be removed but some partial dependencies can exist among attributes.
BCNF = Should be in 3NF, but there can be no sort of dependency, be it transitive or partial.
2NF = Relation should be in 1NF, but attributes should be transitively or otherwise dependent on the primary key.
3NF = Should be in 2NF, but all the transitive dependencies are to be removed but some partial dependencies can exist among attributes.
BCNF = Should be in 3NF, but there can be no sort of dependency, be it transitive or partial.
Beagle- Posts : 40
Join date : 2009-01-30
mnnit.rahul- Posts : 51
Join date : 2009-02-01
Re: Can anyone explain Normal Forms in short?
shivang Mon Feb 02, 2009 9:14 am
Hey Rampi....the answer given by Garg is enuf to solve the probs related to normalizations..... 
shivang- Posts : 42
Join date : 2009-01-30
Age : 35
Permissions in this forum:
You cannot reply to topics in this forum|
|
|