Changes between Version 11 and Version 12 of normalization

Timestamp:

01/30/26 01:12:52 (15 hours ago)

Author:

231175

Comment:

--

normalization

@@ -627 +627 @@
 
 {{{
-R1(productId, product_name, product_description, product_sku, product_unit_price, product_reorder_level, categoryId, supplierId)
-   PK: productId
-
-R2(saleId, sale_date_time, sale_total_amount, userId, customerId, warehouseId)
-   PK: saleId
-
-R3(poId, po_order_date, po_expected_delivery_date, po_status, supplierId, warehouseId)
-   PK: poId
-
-R4(saleId, productId, saleitem_quantity, saleitem_unit_price_at_sale)
-   PK: {saleId, productId}
-
-R5(poId, productId, poitem_quantity, poitem_unit_cost)
-   PK: {poId, productId}
-
-U5(saleId, poId, productId, userId, user_username, user_password, user_full_name, user_email, user_role, user_is_active,
-   customerId, customer_name, customer_email, customer_phone, customer_address,
-   categoryId, category_name, category_description,
-   supplierId, supplier_name, supplier_contact_person, supplier_phone, supplier_email, supplier_address,
-   warehouseId, warehouse_name, warehouse_location, warehouse_capacity,
-   stock_quantity_on_hand, stock_last_updated)
-   PK: {saleId, poId, productId}
+Verification_Token(verification_token_uuid, token_created_at, token_expired_at, user_id)
+   PK: verification_token_uuid
+
+Meeting_Reminder(meeting_reminder_id, meeting_at, meeting_scheduled_at, meeting_sent, meeting_link, user_id)
+   PK: meeting_reminder_id
+
+Expert(expert_id, expert_name, expert_email, expert_login_provider, expert_password_hash)
+   PK: expert_id
+
+Tag_Translate(tag_translate_id, tag_translate_language, tag_value, tag_id)
+   PK: tag_translate_id
+
+Course_Translate(course_translate_id, course_translate_language, course_title_short, course_title, course_description_short, course_description, course_description_long, course_id)
+   PK: course_translate_id
+
+Course_Content_Translate(course_content_translate_id, content_translate_title, content_translate_language, course_content_id)
+   PK: course_content_translate_id
+
+Course_Lecture_Translate(course_lecture_translate_id, lecture_title, lecture_language, lecture_content_file_name, lecture_description, lecture_content_text, course_lecture_id)
+   PK: course_lecture_translate_id
+
+User_Course_Progress(user_course_progress_id, progress_completed, progress_completed_at, enrollment_id, course_lecture_id)
+   PK: user_course_progress_id
+
+Universal_Relation_Shifter_Base_8(
+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,
+expert_id,
+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_content_id, content_position,
+course_lecture_id, lecture_duration_minutes, lecture_position, lecture_content_type,
+tag_id, tag_type
+)
+   PK: ∅
 }}}
 
@@ -657 +672 @@
 === Проверка за транзитивни зависности во секоја релација ===
 
-==== R1(productId, product_name, product_description, product_sku, product_unit_price, product_reorder_level, categoryId, supplierId) ====
+==== Verification_Token(verification_token_uuid, token_created_at, token_expired_at, user_id) ====
 
 '''Транзитивни зависности:'''
- * productId → categoryId → category_name, category_description?
-   * category_name и category_description НЕ се во R1, па нема транзитивна зависност во оваа релација.
- * productId → supplierId → supplier_*?
-   * supplier_* атрибутите НЕ се во R1.
-
-'''Заклучок:''' R1 е во 3NF ✓
-
-==== R2(saleId, sale_date_time, sale_total_amount, userId, customerId, warehouseId) ====
+ * verification_token_uuid → user_id → user_*?
+   * user_* НЕ се во Verification_Token, па нема транзитивна зависност во оваа релација.
+
+'''Заклучок:''' Verification_Token е во 3NF ✓
+
+==== Meeting_Reminder(meeting_reminder_id, meeting_at, meeting_scheduled_at, meeting_sent, meeting_link, user_id) ====
 
 '''Транзитивни зависности:'''
- * saleId → userId → user_*?
-   * user_* атрибутите НЕ се во R2.
- * saleId → customerId → customer_*?
-   * customer_* атрибутите НЕ се во R2.
- * saleId → warehouseId → warehouse_*?
-   * warehouse_* атрибутите НЕ се во R2.
-
-'''Заклучок:''' R2 е во 3NF ✓
-
-==== R3(poId, po_order_date, po_expected_delivery_date, po_status, supplierId, warehouseId) ====
-
-'''Транзитивни зависности:'''
- * Слично како R2, supplier_* и warehouse_* не се во R3.
-
-'''Заклучок:''' R3 е во 3NF ✓
-
-==== R4(saleId, productId, saleitem_quantity, saleitem_unit_price_at_sale) ====
+ * meeting_reminder_id → userId → user_*?
+   * user_* атрибутите НЕ се во Meeting_Reminder.
+
+'''Заклучок:''' Meeting_Reminder е во 3NF ✓
+
+==== Expert(expert_id, expert_name, expert_email, expert_login_provider, expert_password_hash) ====
 
 '''Транзитивни зависности:'''
  * Нема не-клучни атрибути кои одредуваат други не-клучни атрибути.
 
-'''Заклучок:''' R4 е во 3NF ✓
-
-==== R5(poId, productId, poitem_quantity, poitem_unit_cost) ====
-
-'''Заклучок:''' R5 е во 3NF ✓
-
-==== U5 - Проверка за транзитивни зависности ====
-
-Примарен клуч на U5: '''{saleId, poId, productId}'''
+'''Заклучок:''' Expert е во 3NF ✓
+
+==== Tag_Translate(tag_translate_id, tag_translate_language, tag_value, tag_id) ====
+
+'''Транзитивни зависности:'''
+ * tag_translate_id → tag_id → tag_*?
+   * tag_* атрибутите НЕ се во Tag_Translate.
+
+'''Заклучок:''' Tag_Translate е во 3NF ✓
+
+==== Course_Translate(course_translate_id, course_translate_language, course_title_short, course_title, course_description_short, course_description, course_description_long, course_id) ====
+
+'''Транзитивни зависности:'''
+ * course_translate_id → course_id → course_*?
+   * course_* атрибутите НЕ се во Course_Translate.
+
+'''Заклучок:''' Course_Translate е во 3NF ✓
+
+==== Course_Content_Translate(course_content_translate_id, content_translate_title, content_translate_language, course_content_id) ====
+
+'''Транзитивни зависности:'''
+ * course_content_translate_id → course_content_id → course_content_*?
+   * course_content_* атрибутите НЕ се во Course_Content_Translate.
+
+'''Заклучок:''' Course_Content_Translate е во 3NF ✓
+
+==== Course_Lecture_Translate(course_lecture_translate_id, lecture_title, lecture_language, lecture_content_file_name, lecture_description, lecture_content_text, course_lecture_id) ====
+
+'''Транзитивни зависности:'''
+ * course_lecture_translate_id → course_lecture_id → course_lecture_*?
+   * course_lecture_* атрибутите НЕ се во Course_Lecture_Translate.
+
+'''Заклучок:''' Course_Lecture_Translate е во 3NF ✓
+
+==== User_Course_Progress(user_course_progress_id, progress_completed, progress_completed_at, enrollment_id, course_lecture_id) ====
+
+'''Транзитивни зависности:'''
+ * user_course_progress_id → enrollment_id → enrollment_*?
+   * enrollment_* атрибутите НЕ се во User_Course_Progress.
+ * user_course_progress_id → course_lecture_id → course_lecture_*?
+   * course_lecture_* атрибутите НЕ се во User_Course_Progress.
+
+'''Заклучок:''' User_Course_Progress е во 3NF ✓
+
+==== Universal_Relation_Shifter_Base_8 - Проверка за транзитивни зависности ====
+
+Примарен клуч на Universal_Relation_Shifter_Base_8: '''{saleId, poId, productId}'''
 
 '''Транзитивни зависности во U5:'''