The scenario
A library or research team tracks journal collectors, their wishlist items, and the procurement orders placed with vendors to acquire the requested journals.
What is in this drawing
Read the decisions behind it.
01
Separate WishlistItem from ProcurementLine to distinguish desired titles from actual purchased line items
02
Use a Vendor table to support procurement orders and payment terms
03
Model many-to-many Journal-Collector via WishlistItem and Journal-ProcurementOrder via ProcurementLine
Use for systems that manage journal acquisition workflows, including wishlist prioritization, vendor procurement, and order tracking.
More like this