---- new requirements added ----
web pages now added too. existing site (different system) can be used to model. this bring my estimation of this work closer to large project, but very short time.
will seperate MS office requirements into a second bid, hopefully for same coder.
this affects deliverables
---- original ----
I need to get a database job done urgently. I think you could do it in just 2 weeks. I do need this completed on or before the middle of the 2nd week of august. It will be intergrated with a current MS database (MS SQL 2000)
The project is Final Lot Inspection (FLI) and simply caters to the process used by a land development company in Canada. This process varies from city to city and also requires different parties to be notified when certain stages are reached. ie accpted or rejected field are set to true. This would then trigger an email to parties in the contacts table for that stage and area. other than collecting data the rest should be simple.
If any is not do-able I figure you would know this best and that can be handed over to web-app logic. I would take over at that point and handle any changes, so you wouldn't need to be too concerned with maintenance.
The client has drawn what they expect to see at various stages in the web-app. different departments will see data differently, but that is more a concern of the web-app.
Users will use a web-app and also MS-OFFICE to connect so not too much logic must be left to web-app. Hopefully alerts can be handed to one or more email reciepients for any FLI event.
Right now this is just a question. And I may not accept any bids. But I may by early next week. More information will follow, if I find the interested party plus some contacts to work with in the company. If it works out well I'd recommend them To go directly to you for future projects, as this is my last year doing this.
If you wish to handle web-app too this may be able to be arranged. That would be between you, the client and rentacoder. Time extension could apply.
1) Complete tables triggers etc.
2) Complete web-pages to complement database and model real life process.
3) Source code and compiled form where applicable
4) Complete ownership and distribution copyrights to all work purchased.
Must work with MS SQL 2000 or later and SQL mail addon.
Users will use a web-app and also MS-OFFICE to connect