Changes between Version 1 and Version 2 of Normalization

Timestamp:

04/21/26 00:29:57 (11 days ago)

Author:

221296

Comment:

--

Normalization

@@ -4 +4 @@
 
 === Global set of attributes
-This represents the initial de-normalized relation before any normalization is applied.
-Attribute names are made unique to avoid duplication.
+This represents the initial de-normalized relation for the Online Learning Platform Management System (OLPMS), before applying any normalization steps. 
+
+All attributes from the conceptual (ER) model are combined into a single universal relation R, assuming that all data is stored in one table. Attribute names are made unique to avoid duplication and ambiguity.
 {{{
 R = {
-user_id, username, email, name, surname, full_name, password_hash, user_created_at,
-client_id, is_blocked, blocked_at, blocked_reason,
-admin_id,
-owner_id,
-
-notification_id, notification_type, notification_message, notification_created_at, is_read,
-
-animal_id, animal_name, located_name, species, animal_type, breed, sex, date_of_birth, photo_url,
-
-listing_id, listing_status, listing_created_at, price, listing_description,
-
-saved_user_id, saved_listing_id,
-
-clinic_id, clinic_name, clinic_email, clinic_phone, clinic_address, clinic_location, clinic_city,
-
-application_id, app_name, app_email, app_phone, app_city, app_address, submitted_at, app_status, reviewed_at, reviewed_by, denial_reason,
-
-appointment_id, date_time, appointment_status, notes,
-
-healthrecord_id, hr_type, hr_description, hr_date,
-
-review_id, reviewer_id, rating, comment, review_created_at, updated_at, is_deleted,
-target_user_id, target_clinic_id
+ 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, 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
+}
 }
 }}}