Saturday, September 27, 2014

Compare 2NF and 3NF

Difference between 2NF and 3NF / Comparison of 2NF and 3NF / Compare 2NF and 3NF / 2NF and 3NF Comparison / Differentiate 2NF and 3NF

Properties to be satisfied for 2NF and 3NF (recall)

2NF – Table should be in 1NF and no partial functional dependency presents.
3NF - Table should be in 2NF and Every non-prime attribute of R is non-transitively dependent on every superkey of R. 

Attribute Domain
Should be Atomic
Should be Atomic
Functional Dependencies Identification
Handling of Update Anomalies
Handle update anomalies
Handle update anomalies.
Partial Dependencies
Not permitted
Not permitted
Transitive Functional Dependency
Can be permitted
Cannot be permitted
Eliminate Redundant Data
Ensure Data Dependencies


No comments:

Post a Comment

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents

data recovery