Changes between Version 22 and Version 23 of Normalization

Timestamp:

09/25/25 01:19:36 (3 weeks ago)

Author:

226026

Comment:

--

Normalization

@@ -38 +38 @@
 8. {{{ thread_id -> repo_url, project_title }}} 
 
-9. {{{ {thread_id, user_id } -> asc_started_at, asc_ended_at }}} 
+9. {{{ {thread_id, user_id, asc_started_at } -> asc_ended_at }}} 
 
 10. {{{ channel_id ->  channel_name,channel_description}}}  
@@ -72 +72 @@
 
 > **LHS**: 
->> {{{ submission_id,blacklisted_start_date, msg_send_at,pr_id,tag_name,perm_name,blacklisted_about_user, channel_id}}}
+>> {{{ submission_id,blacklisted_start_date, msg_send_at,pr_id,tag_name,perm_name,blacklisted_about_user, channel_id, asc_started_at}}}
 
 > **RHS**: 
->> {{{ description, password, registered_at, email, sex,is_active,name, feedback_submission_type, feedback_created_at, feedback_description, submission_status, submission_created_at, submission_description,blacklisted_end_date, reason, tag_name,thread_created_at, thread_content, guidelines,repo_url, asc_started_at, channel_description, perm_name, pr_override_type, msg_content, channel_name }}} 
+>> {{{ description, password, registered_at, email, sex,is_active,name, feedback_submission_type, feedback_created_at, feedback_description, submission_status, submission_created_at, submission_description,blacklisted_end_date, reason, tag_name,thread_created_at, thread_content, guidelines,repo_url, channel_description, perm_name, pr_override_type, msg_content, channel_name }}} 
 
 > **LHS & RHS**: 
@@ -337 +337 @@
 Единствена ФЗ присутна во оваа релациja е: 
 
-{{{{thread_id,user_id} -> asc_started_at, asc_ended_at}}}
+{{{{thread_id,user_id, asc_started_at} -> asc_ended_at}}}
 
 **R8** е веќе во BCNF, заради тоа што единствената ФЗ го вклучува суперклучот и нема транзитивни зависности.