The scenario
A journal collection manager needs to track which publishers provide which journals, which subscribers hold which subscriptions, and the renewals and payments associated with each subscription period.
What is in this drawing
Read the decisions behind it.
01
Separate Subscription and Renewal entities to preserve renewal history while keeping current subscription terms clean.
02
Use Payment as a child of Renewal so each renewal can have its own settlement record.
03
Include Publisher and Subscriber tables to normalize relationships and avoid storing names directly on transactional rows.
Use this ERD when building a database for library or individual journal collection systems that must track subscription periods, renewal history, and payment records.
More like this