Changes between Version 9 and Version 10 of Normalization

Timestamp:

04/21/26 15:22:18 (11 days ago)

Author:

221296

Comment:

--

Normalization

@@ -9 +9 @@
 {{{
 R = {
- user_id, first_name, last_name, email, password, role,
-
- plan_id, plan_name, price, duration_months, access_type,
-
- subscription_id, start_date, end_date, subscription_status,
-
- payment_id, amount,
-
- ticket_id, admin_id, subject, description, ticket_status, created_at,
-
- category_id, category_name, category_description,
-
- course_id, course_name, course_price, course_status, instructor_id,
-
- module_id, module_title, module_description,
-
- lesson_id, lesson_title, material,
-
- quiz_id, total_points, passing_score,
-
- attempt_id, score, attempt_date,
-
- enrollment_id, enroll_date, completion_status, progress_percentage,
-
- certificate_id, issue_date, certificate_code, certificate_status
+user_id, first_name, last_name, email, password, role,
+plan_id, plan_name, price, duration_months, description, access_type,
+subscription_id, start_date, end_date, subscription_status,
+payment_id, amount,
+ticket_id, admin_id, subject, description_ticket, ticket_status, created_at,
+category_id, category_name, category_description,
+course_id, course_name, course_price, course_status, instructor_id,
+module_id, module_title, module_description,
+lesson_id, lesson_title, material,
+quiz_id, total_points, passing_score,
+attempt_id, score, attempt_date,
+enrollment_id, enroll_date, completion_status, progress_percentage,
+certificate_id, issue_date, certificate_code, certificate_status
 }
 }}}
@@ -45 +33 @@
 User / specialization
 {{{
-FD1: user_id → first_name, last_name, email, password, role  
-FD2: instructor_id → user_id  
+FD1: user_id → first_name, last_name, email, password, role
+FD2: instructor_id → user_id
 FD3: admin_id → user_id
 }}}
@@ -52 +40 @@
 Subscription plan / subscription / payment
 {{{
-FD4: plan_id → plan_name, price, duration_months, access_type  
-FD5: subscription_id → user_id_sub, plan_id_sub, start_date, end_date, subscription_status  
-FD6: payment_id → user_id_pay, subscription_id_pay, amount  
+FD4: plan_id → plan_name, price, duration_months, description, access_type
+FD5: subscription_id → user_id, plan_id, start_date, end_date, subscription_status
+FD6: payment_id → user_id, subscription_id, amount
 }}}
 
 Support ticket
 {{{
-FD7: ticket_id → user_id_ticket, admin_id, subject, description, ticket_status, created_at
+FD7: ticket_id → user_id, admin_id, subject, description_ticket, ticket_status, created_at
 }}}
 
 Category / course
 {{{
-FD8: category_id → category_name, category_description  
+FD8: category_id → category_name, category_description
 FD9: course_id → course_name, course_price, course_status, instructor_id
 }}}
@@ -70 +58 @@
 CourseCategory
 {{{
-The relation CourseCategory has composite key (course_id_cc, category_id_cc) and no additional non-trivial functional dependencies.
+The relation CourseCategory has composite key (course_id, category_id) and no additional non-trivial functional dependencies.
 }}}
 
 Course content hierarchy
 {{{
-FD10: module_id → course_id_mod, module_title, module_description  
-FD11: lesson_id → module_id_lesson, lesson_title, material  
-FD12: quiz_id → lesson_id_quiz, total_points, passing_score  
-FD13: attempt_id → user_id_attempt, quiz_id_attempt, score, attempt_date
+FD10: module_id → course_id, module_title, module_description
+FD11: lesson_id → module_id, lesson_title, material
+FD12: quiz_id → lesson_id, total_points, passing_score
+FD13: attempt_id → user_id, quiz_id, score, attempt_date
 }}}
 
 Enrollment / certificate
 {{{
-FD14: enrollment_id → user_id_enroll, course_id_enroll, enroll_date, completion_status, progress_percentage  
-FD15: certificate_id → enrollment_id_cert, issue_date, certificate_code, certificate_status
+FD14: enrollment_id → user_id, course_id, enroll_date, completion_status, progress_percentage
+FD15: certificate_id → enrollment_id, issue_date, certificate_code, certificate_status
 }}}