Resource Change Database Design

Problem Design a database-backed service for tracking changes to resources. The service must accept resource updates, persist the resulting state, publish a notification for each accepted change, and allow a consumer to retrieve the exact difference associated with a notification so that the consumer can store or process that difference. Your design should explain the data model, update-processing flow, notification format, consistency guarantees, and how the system behaves…