상황
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.
이 도면에 담긴 내용
그 이면의 의사결정을 읽어 보세요.
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.