Changes between Version 4 and Version 5 of P5
- Timestamp:
- 01/27/26 23:22:15 (13 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
P5
v4 v5 58 58 59 59 60 Please review the proof here[[Proof of Candidate Key]]60 Please review the proof explained in more details here -> [[Proof of Candidate Key]] 61 61 62 62 || Candidate Key || … … 70 70 A relation is in 1NF if: 71 71 72 All attributes contain atomic values73 74 No repeating groups exist75 76 The UNF relation contains repeating venue and booking attributes.72 *All attributes contain atomic values 73 74 *No repeating groups exist 75 76 *The UNF relation contains repeating venue and booking attributes. 77 77 78 78 === Transformation to 1NF === … … 88 88 All attributes are now atomic. 89 89 90 Please review the proof explained in more details here -> [[Proof of 1N form]] 91 90 92 == Second Normal Form (2NF) == 91 93 … … 93 95 A relation is in 2NF if: 94 96 95 It is in 1NF96 97 No non-key attribute is partially dependent on a composite key97 *It is in 1NF 98 99 *No non-key attribute is partially dependent on a composite key 98 100 99 101 === Partial Dependency Proof === … … 128 130 This decomposition is mandatory for correctness. 129 131 132 Please review the proof explained in more details here -> [[Proof of 2N]] 133 130 134 == Third Normal Form (3NF) == 131 135 … … 159 163 This ensures entity integrity. 160 164 165 Please review the proof explained in more details here -> [[Proof of 3N]] 166 161 167 == Lossless Join Decomposition Proof == 162 168
