Changes between Version 7 and Version 8 of Normalization
- Timestamp:
- 09/22/25 02:12:08 (31 hours ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Normalization
v7 v8 7 7 feedback: feedback_submission_type, feedback_created_at, feedback_description 8 8 submission: submission_id, submission_status, submission_created_at, submission_description, 9 blacklisted_user: blacklisted_start_date, blacklisted_end_date, reason 9 blacklisted_user: blacklisted_start_date, blacklisted_end_date, reason,blacklisted_about_user 10 10 tag: tag_name, #20 11 11 thread: thread_id, thread_created_at, thread_content … … 20 20 sends_message_in: msg_send_at, msg_content, 21 21 moderator: moderator_id 22 22 23 ) 23 24 }}} … … 33 34 4. {{{ submission_id -> submission_status, submission_created_at, submission_description }}} 34 35 35 5. {{{ { user_id,moderator_id, thread_id, blacklisted_start_date} -> blacklisted_end_date, reason }}}36 5. {{{ {blacklisted_about_user,moderator_id, thread_id, blacklisted_start_date} -> blacklisted_end_date, reason }}} 36 37 37 38 6. {{{ {thread_id, moderator_id} -> moderator_started_at }}} … … 45 46 10. {{{ {thread_id, user_id } -> asc_started_at, asc_ended_at }}} 46 47 47 11. {{{ {thread_id, channel_name} -> channel_description }}}48 11. {{{ {thread_id, channel_name} -> channel_description,resource_id }}} 48 49 49 50 12. {{{ resource_id -> channel_description, channel_name, thread_id }}} … … 79 80 80 81 > **LHS**: 81 >> {{{ submission_id, moderator_id,blacklisted_start_date, resource_id, msg_send_at,pr_id,tag_name,perm_name}}}82 >> {{{ submission_id, moderator_id,blacklisted_start_date, msg_send_at,pr_id,tag_name,perm_name,blacklisted_about_user}}} 82 83 83 84 > **RHS**: … … 85 86 86 87 > **LHS & RHS**: 87 >> {{{ user_id,thread_id,username,channel_name,parent_id,project_title,topic_title, pr_name }}}88 >> {{{ user_id,thread_id,username,channel_name,parent_id,project_title,topic_title, pr_name,resource_id }}} 88 89 89 90 == Нормализација … … 129 130 130 131 === Декомпозиција R2 во 2NF 131 Прво да согледаме дека во било кој супер клуч атрибутите кои се присутни само на левата страна мора да бидат вклучени. Да започниме само со тие атрибути:132 132 133 133 {{{ … … 138 138 msg_send_at, 139 139 pr_id, 140 blacklisted_about_user, 140 141 tag_name, 141 142 perm_name}+ = {
