Changes between Version 19 and Version 20 of Normalization


Ignore:
Timestamp:
09/24/25 22:55:44 (3 weeks ago)
Author:
225144
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Normalization

    v19 v20  
    44{{{
    55R(
    6    user: username, description, password, registered_at, email, sex,is_active,name, user_id
     6  user: username, description, password, registered_at, email, sex,is_active,name, user_id
    77  feedback: feedback_submission_type, feedback_created_at, feedback_description
    88  submission: submission_id, submission_status, submission_created_at, submission_description,
    … …  
    1313  project_thread: repo_url, project_title,
    1414  associated_with: asc_started_at, asc_ended_at,
    15   channel: channel_name, channel_description, channel_UUID
     15  channel: channel_name, channel_description, channel_id
    1616  permissions: perm_name,
    1717  project_roles: pr_name, pr_id, pr_override_type,
    … …  
    40409. {{{ {thread_id, user_id } -> asc_started_at, asc_ended_at }}}
    4141
    42 10. {{{ channel_UUID ->  channel_name,channel_description}}} 
    43 
    44 12. {{{ {thread_id, msg_send_at, user_id } -> msg_content }}}
     4210. {{{ channel_id ->  channel_name,channel_description}}} 
     43
     4412. {{{ {channel_id, msg_send_at, user_id } -> msg_content }}}
    4545
    464613. {{{ pr_id -> pr_name, pr_override_type }}}
    … …  
    7272
    7373> **LHS**:
    74 >> {{{ submission_id,blacklisted_start_date, msg_send_at,pr_id,tag_name,perm_name,blacklisted_about_user, channel_UUID}}}
     74>> {{{ submission_id,blacklisted_start_date, msg_send_at,pr_id,tag_name,perm_name,blacklisted_about_user, channel_id}}}
    7575
    7676> **RHS**:
    77 >> {{{ 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 }}}
     77>> {{{ 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 }}}
    7878
    7979> **LHS & RHS**:
    80 >> {{{ user_id,thread_id,username,channel_name,parent_id,project_title,topic_title, pr_name,blacklisted_id}}}
     80>> {{{ user_id,thread_id,username,parent_id,project_title,topic_title, pr_name,blacklisted_id}}}
    8181
    8282== Нормализација
    … …  
    125125{{{
    126126    {
    127 submission_id
    128 user_id,
    129 blacklisted_start_date
    130 blacklisted_id
    131 msg_send_at
    132 pr_id
    133 tag_name
    134 perm_name
    135 channel_UUID,
    136 thread_id,
    137 msg_send_at
     127submission_id,
     128blacklisted_start_date,
     129msg_send_at,
     130pr_id,
     131tag_name,
     132perm_name,
     133blacklisted_about_user,
     134channel_id
    138135} = {
    139136submission_id
    … …  
    144141perm_name
    145142blacklisted_about_user
    146 channel_UUID,
     143channel_id,
    147144feedback_submission_type, feedback_created_at, feedback_description,
    148145submission_status, submission_created_at, submission_description ,
    … …  
    171168{{{ R4(thread_id,thread_created_at, thread_content,topic_title, parent_id,repo_url, project_title) }}}
    172169
    173 {{{ R5(channel_UUID,channel_name,channel_description) }}}
     170{{{ R5(channel_id,channel_name,channel_description) }}}
    174171
    175172{{{ R6(pr_id,pr_name, pr_override_type) }}}
    176173
    177 {{{ R7(thread_id, msg_send_at, user_id,msg_content) }}}
     174{{{ R7(channel_id, msg_send_at, user_id,msg_content) }}}
    178175
    179176 
    … …  
    291288=== Нормализација на R42 до BCNF
    292289Eдинстевни ФЗ присутни во оваа релација се:
    293 1. {{{ thread_id -> topic_title,parent_id }}}
     2901. {{{ thread_id channel_id-> topic_title,parent_id }}}
    2942912. {{{ {topic_title,parent_id} -> thread_id }}}
    2952923. {{{ parent_id -> topic_title, thread_id }}}
    … …  
    310307Единствена ФЗ присутна во оваа релациja е:
    311308
    312 {{{channel_UUID -> channel_name,channel_description}}}
     309{{{channel_id -> channel_name,channel_description}}}
    313310
    314311R6 е веќе во BCNF, заради тоа што единствената ФЗ го вклучува суперклучот и нема транзитивни зависности.
    … …  
    328325Единствена ФЗ присутна во оваа релациja е:
    329326
    330 {{{ {thread_id, msg_send_at, user_id} -> msg_content}}}
     327{{{ {channel_id, msg_send_at, user_id} -> msg_content}}}
    331328
    332329**R7** е веќе во BCNF, заради тоа што единствената ФЗ го вклучува суперклучот и нема транзитивни зависности.
    333330
    334 Притоа да согледаме дека **R7* е релацијата **messages**.
     331Притоа да согледаме дека **R7** е релацијата **messages**.
    335332
    336333=== Нормализација на R8 до BCNF
    … …  
    366363
    367364
     365