Changes between Version 17 and Version 18 of Normalization

Timestamp:

12/30/25 11:48:54 (4 days ago)

Author:

211101

Comment:

--

Normalization

@@ -286 +286 @@
 Со примената на формална анализа на функционални зависности, правилен избор на примарни клучеви и проверка со lossless-join тест се елиминираат сите аномалии, се обезбедува логичка коректност и се добива шема погодна за имплементација во релациона датабаза.
 
+Финални табели:
+||= USER =||=  =||=  =||=  =||
+||= //user_id =||= //user_name =||= //email =||= //password =||
+|| 1 || james || james@fein.com || $2y$10$rcqLdIzMcYfmGFWCP3kix.JNTOzjIp0xVehMd11wzaanAXUDFLQMu ||
+|| 2 || anita || anita@fein.com || $2y$10$CsSsqA.FFhBR/TWCZCUWYOPxYA.HmGb7ULQPgJGhv3vQS2xRqluYm ||
+//
+||= TRANSACTION_ACCOUNT =||=  =||=  =||=  =||
+||= //transaction_account_id =||= //account_name =||= //balance =||= //user_id =||
+|| 1 || credit card || 5000 || 1 ||
+|| 2 || cash || 1200 || 1 ||
+|| 3 || debit card || 3200 || 2 ||
+//
+||= TRANSACTION =||=  =||=  =||=  =||=  =||
+||= //transaction_id =||= //transaction_name =||= //amount =||= //net_amount =||= //date =||
+|| 1 || electricity bill || -1800 || -1800 || 18:03:25 Sep 26, 2025 ||
+|| 2 || burger || -800 || -200 || 12:43:00 Sep 26, 2025 ||
+|| 3 || nail polish || -200 || -200 || 19:31:32 Sep 12 2025 ||
+//
+||= TAG =||=  =||
+||= //tag_id =||= //tag_name =||
+|| 1 || bills ||
+|| 2 || food ||
+|| 3 || beauty ||
+//
+||= TRANSACTION_BREAKDOWN =||=  =||=  =||=  =||=  =||
+||= //transaction_breakdown_id =||= //transaction_id =||= //transaction_account_id =||= //spent_amount =||= //earned_amount =||
+|| 1 || 1 || 1 || -1800 || 0 ||
+|| 2 || 2 || 2 || -800 || 600 ||
+|| 3 || 3 || 3 || -200 || 0 ||
+//
+||= TAG_ASSIGNED_TO_TRANSACTION =||=  =||
+||= //transaction_id =||= //tag_id =||
+|| 1 || 1 ||
+|| 2 || 2 ||
+|| 3 || 3 ||
+
 ==