Hello everyone,
I am Vaibhav. I need help on a project which i wish to work on, also that i havent started the work yet.

Well i am going to work on a project in java which involves a lot of database activity. Well it consists of tracking of Shares bought and sold from the stock exchange. The process will be as follows...
1) A user has done some trading in the stock exchange thru some stock broker..
2) The user is given not a software copy but a pile of hard copies of the bills involving these transactions..
3) The user wishes to transfer these accounts to the Computer....

Now to do the 3rd step given above, i wish to create a java front end and a MS Access Back end (Database)....

Given the above scenario...i need help to create a database schema or the architecture...

Please any body suggest me an Architecture/Schema for the database......

I assume for 1 reason or another you can't use one of the thousands of pre-made stock trade db's that are available already so...

1- Will this be just long stocks/etf's or will it also include MF's, options, warrants, rights, shorts, annuity sub-accounts, etc?
2- are you using ODX or OFX transmissions from the broker?
3- what all are you tracking?
4- do you have the cusip numbers for these stocks or just a symbol or a name?

Anyway, I'll tell you a fraction of what I know about what you are doing (2 tables):
Each security has:
CUSIP (reqd -primary key)
SYMOBL (opt -unique)
NAME (opt)
TYPE (Especially important if you are doing accounting and need to know settlements)

Each transaction has:
TransactionID (reqd -primary key)
CUSIP
DATE
TRANSACTION (-required -buy/sell/sell short?/exercise?/assigned?/grant?)
SHARES
(I assume you also want)
PRICE
COMMISSION

EDIT: this all assumes you're using a USA broker. I'm not sure about cusip's on foreign exchanges.