Changes between Version 45 and Version 46 of Normalization

Timestamp:

05/11/26 11:39:09 (2 weeks ago)

Author:

221296

Comment:

--

Normalization

@@ -370 +370 @@
 {{{R6: Category:}}}
 
-- !Category(category_id, category_name, category_description)
+- Category(category_id, category_name, category_description)
   
   PK: category_id
@@ -394 +394 @@
 {{{R7: Course:}}}
 
-- !Course(course_id, course_name, course_price, course_status, instructor_id)
+- Course(course_id, course_name, course_price, course_status, instructor_id)
   
   PK: course_id
@@ -418 +418 @@
 {{{R8: Module:}}}
 
-- !Module(module_id, course_id, module_title, module_description)
+- Module(module_id, course_id, module_title, module_description)
   
   PK: module_id
@@ -440 +440 @@
 {{{R9: Lesson:}}}
 
-- !Lesson(lesson_id, module_id, lesson_title, material)
+- Lesson(lesson_id, module_id, lesson_title, material)
   
   PK: lesson_id
@@ -462 +462 @@
 {{{R10: Quiz:}}}
 
-- !Quiz(quiz_id, lesson_id, total_points, passing_score)
+- Quiz(quiz_id, lesson_id, total_points, passing_score)
   
   PK: quiz_id