Changes between Version 13 and Version 14 of Normalization

Timestamp:

12/26/25 23:04:00 (7 days ago)

Author:

211101

Comment:

--

Normalization

@@ -65 +65 @@
 || 2 || anita || anita@fein.com || $2y$10$CsSsqA.FFhBR/TWCZCUWYOPxYA.HmGb7ULQPgJGhv3vQS2xRqluYm ||
 
+====== Lossless join test
+
+R:
+||= //user_id =||= //user_name =||= //email =||= //password =||= //transaction_account_id =||= //account_name =||= //balance =||= //transaction_id =||= //transaction_name =||= //amount =||= //net_amount =||= //date =||= //transaction_breakdown_id =||= //spent_amount =||= //earned_amount =||= //tag_id =||= //tag_name =||
+R1:
+||= //user_id =||= //user_name =||= //email =||= //password =||
+
+R ∩ R1 = { user_id, user_name, email, password }
+
+user_id → R1
+
+R ∩ R1 → R1
+
+⇒ Декомпозицијата е lossless
+
+R1.1 = R - { user_name, email, password }
+
 ==== R2 
 
@@ -75 +92 @@
 || 3 || debit card || 3200 || 2 ||
 
+====== Lossless join test
+
+R1.1:
+||= //user_id =||= //transaction_account_id =||= //account_name =||= //balance =||= //transaction_id =||= //transaction_name =||= //amount =||= //net_amount =||= //date =||= //transaction_breakdown_id =||= //spent_amount =||= //earned_amount =||= //tag_id =||= //tag_name =||
+R2:
+||= //transaction_account_id =||= //account_name =||= //balance =||= //user_id ||
+
+R1.1 ∩ R2 = { transaction_account_id, account_name, balance, user_id }
+
+transaction_account_id → R
+
+R1.1 ∩ R2 → R2
+
+⇒ Декомпозицијата е lossless
+
+R2.1 = R1.1 - { account_name, balance, user_id }
+
 ==== R3
 
@@ -87 +121 @@
 || 3 || nail polish || -200 || -200 || 19:31:32 Sep 12 2025 || 3 || beauty ||
 
+====== Lossless join test
+
+R2.1:
+||= //transaction_account_id =||= //transaction_id =||= //transaction_name =||= //amount =||= //net_amount =||= //date =||= //transaction_breakdown_id =||= //spent_amount =||= //earned_amount =||= //tag_id =||= //tag_name =||
+R3:
+||= //transaction_id =||= //transaction_name =||= //amount =||= //net_amount =||= //date =||= //tag_id =||= //tag_name =||
+
+R2.1 ∩ R3 = { transaction_id, transaction_name, amount, net_amount, date, tag_id, tag_name }
+
+transaction_id → R3
+
+R2.1 ∩ R3 → R3
+
+⇒ Декомпозицијата е lossless
+
+R3.1 = R2.1 - { transaction_name, amount, net_amount, date, tag_id, tag_name }
+
 ==== R4
 
@@ -96 +147 @@
 || 2 || 2 || 2 || -800 || 600 ||
 || 3 || 3 || 3 || -200 || 0 ||
+
+====== Lossless join test
+
+R3.1:
+||= //transaction_account_id =||= //transaction_id =||= //transaction_breakdown_id =||= //spent_amount =||= //earned_amount =||
+R4:
+||= //transaction_breakdown_id =||= //transaction_id =||= //transaction_account_id =||= //spent_amount =||= //earned_amount =||
+
+R3.1 ∩ R4 = { transaction_breakdown_id, transaction_id, transaction_account_id, spent_amount, earned_amount }
+
+transaction_breakdown_id → R4
+
+R3.1 ∩ R4 → R4
+
+⇒ Декомпозицијата е lossless
+
+R4.1 = R3.1 - { transaction_breakdown_id, transaction_id, transaction_account_id, spent_amount, earned_amount }
+R4.1 = ∅
 
 === Премин од 2NF во 3NF