Changes between Version 21 and Version 22 of Normalization

Timestamp:

04/27/26 02:39:27 (5 days ago)

Author:

221296

Comment:

--

Normalization

@@ -274 +274 @@
 === Typical transitive issues from the ER
 * In Payment(payment_id, user_id, subscription_id, amount), we have:
+
   payment_id → subscription_id
+
   subscription_id → user_id, plan_id, start_date, end_date, subscription_status.
+
   Because subscription details are stored in UserSubscription, they should not be repeated in Payment. Payment keeps only payment_id, user_id, subscription_id and amount, so no transitive dependency remains inside Payment.