We are a hospital in a former Soviet Union country and are trying to transfer from paperwork to fully integrated informational system, and working with a local company on it. The process should take almost 6 month. Meanwhile, we need something intermediate. So, we need a database for surgeries we perform in our hospital. The data entry contains: date, surgeon, doctor, patient's last and first name and type of operation. The entry depends on several factors, for example certain surgeons can only have surgeries in certain days of the week, or there can not be more then X amount of surgeries of some type in any given day. Plus, we have two operation tables, used at the same time. Supposedly, a user can choose from several lists, and if he chooses something, he cannot choose the other option.
Also, the user should be able to make queries by the surgeons name, or by the day, or by the month. Some way of searching within the database would also be nice.
The program is not that complicated. It has been done previously in php and mysql and then ran on a Apache server some time ago. So, may be we can do it a little better and upgraded this time. Will provide more details if you feel interested.