Saturday, 27 September 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

SQL exercises for beginners one

SQL Exercises for Beginners / Simple SQL Exercises with Answers / Solved SQL exercises / SQL solved exercises with simple conditions / So...