A database that has the following functionality and is accessable through a website with PHP / mySQL:
1. Add & Edit customers
2. Add & Edit Activities
3. Add & Edit Operators (they operate the activities, one operator per activity but many activities per operator)
4. Add & Edit Equipment (equipment is used on activities, one activity can have many pieces of equipment, and equipment can be used for multiple activities so this is many to many).
5. Add & Edit Bookings. A booking consists of many activities, which can have many pieces of equipment and one operator. There can be many activities per booking.
6. Add payments to bookings (no payment processing required)
Please see the additional information section for full details on this project.
The interface needs to be clean and simple, nothing too fancy.
## Deliverables
We want to be able to add payments to bookings by typing in the amount of the payment, selecting the payment type and applying it. No "Payment Processing" through gateways etc is required. A booking cost is worked out by the cost of the all the activities in the booking, added onto the cost of all the equipment in the activities in the booking.
The database schema can be found here:
[login to view URL]
This is from a MS Access project we tried before we decided to submit to vWorker and have it completed in PHP / mySQL.
We reply to questions & responses very quickly, so any questions are always answered in a timley manner. We welcome as many questions as you want to ask, as the more you know the project the more you will understand it, and the better job you will do :).
We have attempted to do this in MS Access but were unable to do the forms etc for it and would prefer it in PHP / mySQL anyway. A database schema is attached for this. Please see the details information for this and some other requirements we have.
Please do NOT bid on this project if you can complete it. We require a 1 week turnaround. It is to be completed by 11/02/2011 at 12PM GMT+12