Changes between Version 5 and Version 6 of normalization

Timestamp:

01/29/26 23:04:01 (17 hours ago)

Author:

231175

Comment:

--

normalization

@@ -16 +16 @@
 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_what_will_be_learned_text,
+course_what_will_be_learned,
 course_content_id, content_position,
 course_content_translate_id, content_translate_title, content_translate_language,
@@ -62 +62 @@
  * '''FD26:''' (course_version_id, content_position) → course_content_id
  * '''FD27:''' (course_content_id, lecture_position) → course_lecture_id
-
+ * '''FD28:''' (course_translate_id, course_what_will_be_learned) → ∅
 '''}'''
 
@@ -136 +136 @@
 || course_description || ✗ || ✓ (FD12) || десно ||
 || course_description_long || ✗ || ✓ (FD12) || десно ||
+|| course_what_will_be_learned || ✓ (FD28) || ✗ || лево ||
 || course_content_id || ✓ (FD13, FD23, FD27) || ✓ (FD14, FD15, FD26) || и лево и десно ||
 || content_position || ✓ (FD26) || ✓ (FD13) || и лево и десно ||
@@ -159 +160 @@
 === 3.3 Атрибути кои се појавуваат САМО на лева страна ===
 
- * '''saleId''' - мора да биде дел од секој кандидат клуч
- * '''poId''' - мора да биде дел од секој кандидат клуч
+ * '''verification_token_uuid''' - мора да биде дел од секој кандидат клуч
+ * '''meeting_reminder_id''' - мора да биде дел од секој кандидат клуч
+ * '''course_what_will_be_learned''' - мора да биде дел од секој кандидат клуч
 
 === 3.4 Пресметка на затворач ===
 
-'''Чекор 1:''' Започнуваме со {saleId, poId} и пресметуваме затворач:
-
-{{{
-{saleId, poId}⁺:
-- Од FD10 (saleId →): добиваме sale_date_time, sale_total_amount, userId, customerId, warehouseId
-- Од FD11 (poId →): добиваме po_order_date, po_expected_delivery_date, po_status, supplierId, warehouseId
-- Од FD1 (userId →): добиваме user_username, user_password, user_full_name, user_email, user_role, user_is_active
-- Од FD4 (customerId →): добиваме customer_name, customer_email, customer_phone, customer_address
-- Од FD8 (supplierId →): добиваме supplier_name, supplier_contact_person, supplier_phone, supplier_email, supplier_address
-- Од FD9 (warehouseId →): добиваме warehouse_name, warehouse_location, warehouse_capacity
-}}}
-
-'''{saleId, poId}⁺ ≠ U'''
-
-'''Недостасуваат:''' productId, product_name, product_description, product_sku, product_unit_price, product_reorder_level, categoryId, category_name, category_description, saleitem_quantity, saleitem_unit_price_at_sale, poitem_quantity, poitem_unit_cost, stock_quantity_on_hand, stock_last_updated
-
-'''Чекор 2:''' Додаваме productId:
-
-{{{
-{saleId, poId, productId}⁺:
+'''Чекор 1:''' Започнуваме со {verification_token_uuid, meeting_reminder_id, course_what_will_be_learned} и пресметуваме затворач:
+
+{{{
+{verification_token_uuid, meeting_reminder_id, course_what_will_be_learned}⁺:
+- Од FD2 (verification_token_uuid →): добиваме token_created_at, token_expired_at, user_id
+- Од FD3 (meeting_reminder_id →): добиваме meeting_at, meeting_scheduled_at, meeting_sent, meeting_link, user_id
+- Од FD1 (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
+- Од FD18 (user_email →): добиваме user_id
+}}}
+
+'''{verification_token_uuid, meeting_reminder_id, course_what_will_be_learned}⁺ ≠ Universal_Relation_Shifter'''
+
+'''Недостасуваат:''' 
+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,
+tag_id, tag_type,
+tag_translate_id, tag_translate_language, tag_value
+
+'''Чекор 2:''' Додаваме user_course_progress_id:
+
+{{{
+{verification_token_uuid, meeting_reminder_id, course_what_will_be_learned, user_course_progress_id}⁺:
 - Сè од претходно, плус:
-- Од FD5 (productId →): добиваме product_name, product_description, product_sku, product_unit_price, product_reorder_level, categoryId, supplierId
-- Од FD7 (categoryId →): добиваме category_name, category_description
-- Од FD12 ({saleId, productId} →): добиваме saleitem_quantity, saleitem_unit_price_at_sale
-- Од FD13 ({poId, productId} →): добиваме poitem_quantity, poitem_unit_cost
-- Од FD14 ({warehouseId, productId} →): добиваме stock_quantity_on_hand, stock_last_updated
-}}}
-
-'''{saleId, poId, productId}⁺ = U''' (ги содржи сите атрибути) ✓
+- Од FD6 (user_course_progress_id →): добиваме progress_completed, progress_completed_at, enrollment_id, course_lecture_id
+- Од FD15 (course_lecture_id →): добиваме lecture_duration_minutes, lecture_position, lecture_content_type, course_content_id
+- Од FD13 (course_content_id →): добиваме content_position, course_version_id
+- Од FD6 (enrollment_id →): добиваме enrollment_status, enrollment_purchase_date, enrollment_activation_date, enrollment_completion_date, user_id, course_version_id, payment_id, review_id
+- Од FD7 (payment_id →): добиваме payment_amount, payment_date, payment_method, payment_status, enrollment_id
+- Од FD8 (review_id →): добиваме review_rating, review_comment, review_date, enrollment_id
+- Од FD11 (course_version_id →): добиваме version_number, version_creation_date, version_active, course_id
+- Од FD5 (course_id →): добиваме course_image_url, course_color, course_difficulty, course_duration_minutes, course_price
+}}}
+
+'''{verification_token_uuid, meeting_reminder_id, course_what_will_be_learned, user_course_progress_id}⁺ ≠ Universal_Relation_Shifter'''
+
+'''Недостасуваат:''' 
+expert_id, expert_name, expert_email, expert_login_provider, expert_password_hash,
+course_translate_id, course_translate_language, course_title_short, course_title, course_description_short, course_description, course_description_long,
+course_content_translate_id, content_translate_title, content_translate_language,
+course_lecture_translate_id, lecture_title, lecture_language, lecture_content_file_name, lecture_description, lecture_content_text,
+tag_id, tag_type,
+tag_translate_id, tag_translate_language, tag_value
+
+'''Чекор 3:''' Додаваме expert_id, course_lecture_translate_id, course_content_translate_id, course_translate_id, tag_translate_id:
+
+{{{
+{verification_token_uuid, meeting_reminder_id, course_what_will_be_learned, user_course_progress_id, expert_id, course_lecture_translate_id, course_content_translate_id, course_translate_id, tag_translate_id}⁺:
+- Сè од претходно, плус:
+- Од FD4 (expert_id →): добиваме expert_name, expert_email, expert_login_provider, expert_password_hash
+- Од FD16 (course_lecture_translate_id →): добиваме lecture_title, lecture_language, lecture_content_file_name, lecture_description, lecture_content_text, course_lecture_id
+- Од FD14 (course_content_translate_id →): добиваме content_translate_title, content_translate_language, course_content_id
+- Од FD12 (course_translate_id →): добиваме course_translate_language, course_title_short, course_title, course_description_short, course_description
+- Од FD10 (tag_translate_id →): добиваме tag_translate_language, tag_value, tag_id
+- Од FD9 (tag_id →): добиваме tag_type
+- Од FD28 ({course_translate_id, course_what_will_be_learned} →): добиваме ∅
+}}}
+
+'''{verification_token_uuid, meeting_reminder_id, course_what_will_be_learned, user_course_progress_id, expert_id, course_lecture_translate_id, course_content_translate_id, course_translate_id, tag_translate_id}⁺ = Universal_Relation_Shifter''' (ги содржи сите атрибути) ✓
 
 === 3.5 Проверка за минималност ===
@@ -201 +242 @@
 || {poId, productId}⁺ || Недостасуваат атрибути од saleId: sale_date_time, sale_total_amount, saleitem_quantity, saleitem_unit_price_at_sale, userId→атрибути, customerId→атрибути || ✗ НЕ ||
 
-'''Заклучок:''' {saleId, poId, productId} е минимален и е кандидат клуч.
+'''Заклучок:''' {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} е минимален и е кандидат клуч.
 
 === 3.6 Други кандидат клучеви ===