We need a web-based "deal entry system" for a hedge fund that is trading energy-contracts. Up to 10 different traders will have individual web-pages to enter : contract, volume, price, broker and counterpart. When "done", every deal should be sent (with php-script I guess) to a MySql DB with a time-stamp. Every trader will have some default fields and the Web page must retrieve lists of contracts and brokers from the DB.
Traders must log in to "his" webpage with a password.
An administrator (risk controller) will have a special web-interface that allows to mark "accepted deals" and delete wrong entries.
There should be a function to automaticly "tank up" the DB to excel.
We will provide a sketch of the DB.