already complete database for scheduling of sanitation jobs

[Guest]

Does there already exist a database designed for recording cleaning jobs for
sanitation for FOOd companies. It would show what is needed for the cleaning
job automatically show when the job should be done, etc. I would hate to
reinvent the wheel if something already exists out there???

Thanks,
BArb

 

[John Vinson]

Does there already exist a database designed for recording cleaning jobs for
sanitation for FOOd companies. It would show what is needed for the cleaning
job automatically show when the job should be done, etc. I would hate to
reinvent the wheel if something already exists out there???

Thanks,
BArb

Well... good luck. That's a VERY specific requirement; and I can't
imagine that the business rules of some company which has one would
exactly match the business rules that you work under!

It will take some study and work, but I can't see that this would be a
very complex database. You'll need to identify the real-life Entities
- persons, things or events - of importance; create tables to
represent them; define the relationships... and maybe you'll be able
to sell it to other food service companies when you're done!


John W. Vinson[MVP]