Changes between Version 30 and Version 31 of Normalization

Timestamp:

04/27/26 03:07:19 (5 days ago)

Author:

221296

Comment:

--

Normalization

@@ -328 +328 @@
 - `Instructors`(instructor_id, user_id)
 
-`SubscriptionPlan`(plan_id, plan_name, price, duration_months, plan_description, access_type)
-`UserSubscription`(subscription_id, user_id, plan_id, start_date, end_date, subscription_status)
-`Payment`(payment_id, user_id, subscription_id, amount)
-
-`SupportTicket`(ticket_id, user_id, admin_id, subject, ticket_description, ticket_status, created_at)
-
-`Category`(category_id, category_name, category_description)
-`Course`(course_id, course_name, course_price, course_status, instructor_id)
-`CourseCategory`(course_id, category_id)
-
-`Module`(module_id, course_id, module_title, module_description)
-`Lesson`(lesson_id, module_id, lesson_title, material)
-`Quiz`(quiz_id, lesson_id, total_points, passing_score)
-`QuizAttempt`(attempt_id, user_id, quiz_id, score, attempt_date)
-
-`Enrollment`(enrollment_id, user_id, course_id, enroll_date, completion_status, progress_percentage)
-`Certificate`(certificate_id, enrollment_id, issue_date, certificate_code, certificate_status)
+- `SubscriptionPlan`(plan_id, plan_name, price, duration_months, plan_description, access_type)
+- `UserSubscription`(subscription_id, user_id, plan_id, start_date, end_date, subscription_status)
+- `Payment`(payment_id, user_id, subscription_id, amount)
+
+- `SupportTicket`(ticket_id, user_id, admin_id, subject, ticket_description, ticket_status, created_at)
+
+- `Category`(category_id, category_name, category_description)
+- `Course`(course_id, course_name, course_price, course_status, instructor_id)
+- `CourseCategory`(course_id, category_id)
+
+- `Module`(module_id, course_id, module_title, module_description)
+- `Lesson`(lesson_id, module_id, lesson_title, material)
+- `Quiz`(quiz_id, lesson_id, total_points, passing_score)
+- `QuizAttempt`(attempt_id, user_id, quiz_id, score, attempt_date)
+
+- `Enrollment`(enrollment_id, user_id, course_id, enroll_date, completion_status, progress_percentage)
+- `Certificate`(certificate_id, enrollment_id, issue_date, certificate_code, certificate_status)
 
 All resulting relations satisfy 3NF because for every non-trivial functional dependency X → Y inside a relation, X is a key of that relation, or the dependent attributes are stored in a separate relation determined by their own key.