Database Answers Rare Book Library at Yale.

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Tracking Share Transactions
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 ?
A.1 Investors
A.2 Lots
A.3 Purchases
A.4 Sales
A.5 Subscriptions
A.6 Transactions.


Barry Williams
28th. March 2007
Principal Consultant
Database Answers

 

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map