Changes between Version 9 and Version 10 of normalization

Timestamp:

01/30/26 00:27:22 (16 hours ago)

Author:

231175

Comment:

--

normalization

@@ -268 +268 @@
 === Чекор 4.1: Декомпозиција на релацијата Universal_Relation_Shifter ===
 
-'''Нарушува 1NF:'''Релацијата не е во 1NF бидејќи атрибутот course_what_will_be_learned претставува повеќевредносен (multi-valued) атрибут. Секој course_translate може да има повеќе ставки од course_what_will_be_learned.
+'''Нарушува 1NF: '''Релацијата не е во 1NF бидејќи атрибутот course_what_will_be_learned претставува повеќевредносен (multi-valued) атрибут. Секој course_translate може да има повеќе ставки од course_what_will_be_learned.
 
 '''Декомпозиција:'''
@@ -277 +277 @@
 
 Universal_Relation_Shifter_Base = Universal_Relation_Shifter - {course_what_will_be_learned}
+
+Universal_Relation_Shifter_Base(
+user_id, user_name, user_email, user_login_provider, user_password_hash, user_verified, user_profile_complete, user_used_free_consultation, user_company_size, user_work_position, user_points,
+meeting_reminder_id, meeting_at, meeting_scheduled_at, meeting_sent, meeting_link,
+expert_id, expert_name, expert_email, expert_login_provider, expert_password_hash,
+course_id, course_image_url, course_color, course_difficulty, course_duration_minutes, course_price,
+course_version_id, version_number, version_creation_date, version_active,
+enrollment_id, enrollment_status, enrollment_purchase_date, enrollment_activation_date, enrollment_completion_date,
+payment_id, payment_amount, payment_date, payment_method, payment_status,
+review_id, review_rating, review_comment, review_date,
+course_translate_id, course_translate_language, course_title_short, course_title, course_description_short, course_description, course_description_long,
+course_content_id, content_position,
+course_content_translate_id, content_translate_title, content_translate_language,
+course_lecture_id, lecture_duration_minutes, lecture_position, lecture_content_type,
+course_lecture_translate_id, lecture_title, lecture_language, lecture_content_file_name, lecture_description, lecture_content_text,
+user_course_progress_id, progress_completed, progress_completed_at,
+verification_token_uuid, token_created_at, token_expired_at,
+tag_id, tag_type,
+tag_translate_id, tag_translate_language, tag_value
+)
    PK: {verification_token_uuid, meeting_reminder_id, user_course_progress_id, expert_id, course_lecture_translate_id, course_content_translate_id, course_translate_id, tag_translate_id}
+}}}
 
 '''Проверка за lossless join:''' Може да се реконструира преку course_translate_id