Changes between Version 37 and Version 38 of Normalization
- Timestamp:
- 05/05/26 10:01:11 (3 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Normalization
v37 v38 251 251 {{{R1: UserEntity:}}} 252 252 [[BR]] 253 - UserEntity(user_id, first_name, last_name, email, password, role)254 -PK: user_id253 - 'UserEntity'(user_id, first_name, last_name, email, password, role) 254 PK: user_id 255 255 256 256 - Derived from: 257 -FD1: user_id → first_name, last_name, email, password, role257 FD1: user_id → first_name, last_name, email, password, role 258 258 259 259 - Lossless Join Check: … … 266 266 - Dependency Preservation: 267 267 268 FD1 is fully contained in UserEntity268 FD1 is fully contained in UserEntity 269 269 270 270 ⇒ PRESERVED
