Changes between Version 19 and Version 20 of Normalization

Timestamp:

07/15/26 06:10:10 (11 days ago)

Author:

235018

Comment:

--

Normalization

@@ -330 +330 @@
 
 
-
-
-
-
-
-
-
-
+== Third Normal Form (3NF)
+
+A relation is in Third Normal Form (3NF) if:
+
+**1.**  It is already in Second Normal Form (2NF).
+**2.**  There are no transitive dependencies.
+**3.**  Every non-key attribute depends only on the primary key, and not on another non-key attribute.
+
+A transitive dependency occurs when:
+
+{{{#!c++
+Primary Key → Non-key Attribute A
+Non-key Attribute A → Non-key Attribute B
+}}}
+
+
+
+
+
+
+