Changes between Version 4 and Version 5 of P5


Ignore:
Timestamp:
01/27/26 23:22:15 (13 days ago)
Author:
213087
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • P5

    v4 v5  
    5858
    5959
    60 Please review the proof here [[Proof of Candidate Key]]
     60Please review the proof explained in more details here -> [[Proof of Candidate Key]]
    6161
    6262|| Candidate Key ||
     
    7070A relation is in 1NF if:
    7171
    72 All attributes contain atomic values
    73 
    74 No repeating groups exist
    75 
    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.
    7777
    7878=== Transformation to 1NF ===
     
    8888All attributes are now atomic.
    8989
     90Please review the proof explained in more details here -> [[Proof of 1N form]]
     91
    9092== Second Normal Form (2NF) ==
    9193
     
    9395A relation is in 2NF if:
    9496
    95 It is in 1NF
    96 
    97 No non-key attribute is partially dependent on a composite key
     97*It is in 1NF
     98
     99*No non-key attribute is partially dependent on a composite key
    98100
    99101=== Partial Dependency Proof ===
     
    128130This decomposition is mandatory for correctness.
    129131
     132Please review the proof explained in more details here -> [[Proof of 2N]]
     133
    130134== Third Normal Form (3NF) ==
    131135
     
    159163This ensures entity integrity.
    160164
     165Please review the proof explained in more details here -> [[Proof of 3N]]
     166
    161167== Lossless Join Decomposition Proof ==
    162168