Hi,
I am proposing we build an app with a simple and user friendly interface that will record and report the required data and that will ensure record integrity (editing records directly into database tables can result in data loss).
The app will:
- manage tutors (name, subject, location and email)
- manage availability (daily availability, leaves, sick days maybe)
- manage assignments and schedule (assign students - with name, address, phone, email - to a tutor for a specific day in a time interval)
- report each tutor schedule for the next 30 days or less
- send schedule by mail to a tutor (if that tutor has an email address defined, of course).
Regarding the email sending part, will you be using a private email address (like name[at]mycompany[dot]com) or a public address (like GMail or Yahoo)?
If you like my idea and would like to see a demo, I can have one ready in a couple of hours. Send me a message if so and I will be more than happy to build it.
Thanks!
Florin