Changes between Version 43 and Version 44 of Normalization
- Timestamp:
- 05/05/26 10:42:16 (3 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Normalization
v43 v44 246 246 247 247 == Decomposition to 2NF 248 {{{ 248 249 249 === We eliminate partial dependencies by decomposing R into smaller relations such that each determinant becomes a primary key in its own relation. 250 250 … … 565 565 Therefore, the decomposition satisfies Second Normal Form (2NF). 566 566 567 }}} 567 568 568 == Check for 3NF (and decomposition) 569 569 Now we look for transitive dependencies inside the relations obtained after the 2NF decomposition.
