Back to the Data Model
Requirement is a Database for Tracking Share Transactions in a Fund
It is necessary to link specific investor purchases (subscriptions are in units and
can be in purchased in fractions of a unit) with sales.
One purchase can have many sales and one sale can comprise many purchases.
For example, Investor A purchases shares in three lots over a 12 month period.
Lot 1 … 220.8 shares,
Lot 2 … 400.75 shares and
Lot 3 … 334 shares.
Investor A then sells 700 shares.
There is a need to link this sale to each of the individual lots on a 'First-In First-Out' basis,
so that the remaining balance is related to Lot 3.
One key question is 'How should Reference Data be modelled ?'
A. What are the Things Of Interest ?
28th. March 2007