MySQL + SQL · Lesson 111

Normal Forms Quick Revision

All Normal Forms at a Glance

A quick revision table of every normal form and the one problem each removes.

Form	Removes	Rule
1NF	repeating groups	atomic values only
2NF	partial dependency	1NF + full dependency on key
3NF	transitive dependency	2NF + no non-key → non-key
BCNF	overlapping-key anomalies	every determinant is a candidate key

1NF→atomic, 2NF→no partial, 3NF→no transitive, BCNF→determinant is candidate key.
Each higher form removes a more subtle anomaly.

Form	हटाता है	नियम
1NF	repeating groups	सिर्फ atomic values
2NF	partial dependency	1NF + key पर पूर्ण dependency
3NF	transitive dependency	2NF + no non-key → non-key
BCNF	overlapping-key anomalies	हर determinant candidate key हो

Is page ki language (MYSQL) mein code likhein aur turant chalाएं — yahीं, bina kuch install kiye.

Is page ke program yahan ready hain — chalाएं, badlें aur seekhें. Bina kuch install kiye.

Powered by OneCompiler. Editor mein code apne aap aa jata hai — Run dabaakर output dekhें. Agar load na ho to naye tab mein kholें.