BEGIN WORK;

INSERT INTO currency VALUES ( 'USD','United States Dollar');
INSERT INTO bank VALUES ('YB','Your Bank');

/*
 Buy 100 shares at $20.00 per share.  Fees: $25.00
 Buy 200 shares at $16.00 per share.  Fees: $30.00
 Sell 150 shares at $22.00 per share.  Fees: $30.00
*/

INSERT INTO fund VALUES (1,'YB','USD','ETF','Exchange Traded Fund');

INSERT INTO share_purchase VALUES (1,'02/01/99',20,100,0.25);
INSERT INTO share_purchase VALUES (1,'06/01/00',16,200,0.15);
INSERT INTO share_redemption VALUES (1,'03/01/01',22,150,0.20);


COMMIT;

