Changes between Version 42 and Version 43 of Normalization

Timestamp:

05/05/26 10:41:05 (3 weeks ago)

Author:

221296

Comment:

--

Normalization

@@ -246 +246 @@
 
 == Decomposition to 2NF
-
+{{{
 === We eliminate partial dependencies by decomposing R into smaller relations such that each determinant becomes a primary key in its own relation.
 
@@ -252 +252 @@
 
 - !UserEntity(user_id, first_name, last_name, email, password, role)
-  
   PK: user_id
-
 - Derived from:
 
@@ -567 +565 @@
 Therefore, the decomposition satisfies Second Normal Form (2NF).
 
+}}}
 == Check for 3NF (and decomposition)
 Now we look for transitive dependencies inside the relations obtained after the 2NF decomposition.