Changes between Version 28 and Version 29 of Normalization

Timestamp:

04/27/26 03:04:20 (5 days ago)

Author:

221296

Comment:

--

Normalization

@@ -324 +324 @@
 
 `UserEntity`(user_id, first_name, last_name, email, password, role)
-Users(user_id)
-Administrators(admin_id, user_id)
-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)
+`Users`(user_id)
+`Administrators`(admin_id, user_id)
+`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)
 
 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.