Changes between Version 3 and Version 4 of Normalization

Timestamp:

05/28/26 01:02:56 (3 weeks ago)

Author:

213257

Comment:

--

Normalization

@@ -364 +364 @@
 === Decompose from 2NF to 3NF ===
 
-Each relation from Step 1 is checked below.
+Each relation from 2NF is checked below.
 
 ==== R_Admin ====
@@ -524 +524 @@
 All 11 relations produced in Step 1 are already in 3NF.
 
-=== STEP 3 — Decompose from 3NF to BCNF ===
+=== Decompose from 3NF to BCNF ===
 
 Check every FD in each relation:
@@ -541 +541 @@
 
 '''All 11 relations are in BCNF. No decomposition needed.'''
-
-=== 4NF Note ===
-
-No non‑trivial multi‑valued dependencies exist – every attribute is single‑valued
-per key. Therefore '''all relations are also in 4NF'''.
-
-BCNF / 4NF is the highest normal form achieved.
-
-----
 
 == Final Normalized Design & Discussion ==
@@ -645 +636 @@
 }}}
 
-=== Differences vs. Phase 2 Design ===
+=== Differences compared to Phase 2 ===
 
 || '''Aspect'''              || '''Phase 2 Design'''                   || '''P5 Normalized Design'''                           ||