Changes between Version 37 and Version 38 of Normalization


Ignore:
Timestamp:
05/05/26 10:01:11 (3 weeks ago)
Author:
221296
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Normalization

    v37 v38  
    251251{{{R1: UserEntity:}}}
    252252[[BR]]
    253 - UserEntity(user_id, first_name, last_name, email, password, role)
    254 - PK: user_id
     253- 'UserEntity'(user_id, first_name, last_name, email, password, role)
     254 PK: user_id
    255255
    256256- Derived from:
    257 - FD1: user_id → first_name, last_name, email, password, role
     257 FD1: user_id → first_name, last_name, email, password, role
    258258
    259259- Lossless Join Check:
     
    266266- Dependency Preservation:
    267267
    268 FD1 is fully contained in UserEntity
     268 FD1 is fully contained in UserEntity
    269269
    270270⇒ PRESERVED