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 ?
A.1 Investors
A.2 Lots
A.3 Purchases
A.4 Sales
A.5 Subscriptions
A.6 Transactions.