Changes between Version 11 and Version 12 of Normalization

Timestamp:

12/25/25 03:54:12 (9 days ago)

Author:

211101

Comment:

--

Normalization

@@ -220 +220 @@
 
 ==== 3
-TRANSACTION → TAG_ASSIGNED_TO_TRANSACTION
+
+TRANSACTION_ACCOUNT_WITH_USER_DATA → TRANSACTION_ACCOUNT + USER
+
+- R(transaction_account_id, account_name, balance, user_id, user_name, email)
+- R1(transaction_account_id, account_name, balance, user_id)
+- R2(user_id, user_name, email)
+
+R1 ∩ R2 = {user_id}
+
+- {user_id} → {user_name, email}
+
+(user_id) → R2 
+⇒ Декомпозицијата е lossless
+
+==== 4
+TRANSACTION_WITH_TAG_NAME → TRANSACTION + TAG_ASSIGNED_TO_TRANSACTION
 
 - R(transaction_id, transaction_name, amount, net_amount, date, tag_id)
@@ -233 +248 @@
 ⇒ Декомпозицијата е lossless
 
-==== 4
-TRANSACTION_ACCOUNT_WITH_USER_DATA → TRANSACTION_ACCOUNT + USER
-
-- R(transaction_account_id, account_name, balance, user_id, user_name, email)
-- R1(transaction_account_id, account_name, balance, user_id)
-- R2(user_id, user_name, email)
-
-R1 ∩ R2 = {user_id}
-
-- {user_id} → {user_name, email}
-
-(user_id) → R2 
-⇒ Декомпозицијата е lossless
-
 ==== 5
 TAG