Changes between Version 25 and Version 26 of Normalization

Timestamp:

04/27/26 02:58:00 (5 days ago)

Author:

221296

Comment:

--

Normalization

@@ -383 +383 @@
 
 == Final relations
-* Users(user_id, username, email, name, surname, full_name, password_hash, user_created_at)
-* Clients(client_id, user_id, is_blocked, blocked_at, blocked_reason)
-* Admins(admin_id, user_id)
-* Owners(owner_id, client_id)
-* Notifications(notification_id, user_id, notification_type, notification_message, notification_created_at, is_read)
-* VetClinics(clinic_id, clinic_name, clinic_email, clinic_phone, clinic_address, clinic_location, clinic_city)
-* VetClinicApplications(application_id, clinic_id, app_name, app_email, app_phone, app_city, app_address, submitted_at, app_status, reviewed_at, reviewed_by, denial_reason)
-* Animals(animal_id, owner_id, animal_name, located_name, species, animal_type, breed, sex, date_of_birth, photo_url)
-* Listings(listing_id, admin_id, animal_id, listing_status, listing_created_at, price, listing_description)
-* FavoriteListings(saved_user_id, saved_listing_id)
-* Appointments(appointment_id, clinic_id, animal_id, date_time, appointment_status, notes)
-* HealthRecords(healthrecord_id, appointment_id, animal_id, hr_type, hr_description, hr_date)
-* Reviews(review_id, reviewer_id, rating, comment, review_created_at, updated_at, is_deleted)
-* UserReviews(review_id, target_user_id)
-* ClinicReviews(review_id, target_clinic_id)
+Final relations
+
+After applying normalization up to 4NF, the final normalized schema consists of the following relations:
+
+{{{
+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)
+}}}
+
+The final schema removes partial and transitive dependencies, avoids unnecessary redundancy, and preserves the functional dependencies from the initial universal relation.
 
 == Conclusion