Changes between Version 39 and Version 40 of Normalization

Timestamp:

05/05/26 10:05:48 (3 weeks ago)

Author:

221296

Comment:

--

Normalization

@@ -252 +252 @@
 [[BR]]
 - !UserEntity(user_id, first_name, last_name, email, password, role)
- PK: user_id
+  PK: user_id
 
 - Derived from:
@@ -259 +259 @@
 - Lossless Join Check:
 
-R ∩ UserEntity = {user_id}
-user_id → UserEntity
+  R ∩ !UserEntity = {user_id}
+  user_id → UserEntity
 
 ⇒ The decomposition is lossless
@@ -266 +266 @@
 - Dependency Preservation:
 
- FD1 is fully contained in UserEntity
-
-⇒ PRESERVED
+ FD1 is fully contained in !UserEntity
+
+ ⇒ PRESERVED