database structure for school management type script??????
Posted: Tue Jun 03, 2008 3:32 pm
Heres what I'm doing... setting up a CMS type script for schools to use. basically, students can login to check their grades and attendance, and can message teachers.... same for the parents....
teachers can login and post new assignments, update grades, and post attendance each day there is school (basic CRUD functions)... and as well they can message parents and students...
administrators can login and make reports from such information, and change settings.....
what would be a proper mysql structure for such a web application using mysql???
keep in mind I need a login table as well as the ability to do the above?
ALL help will be highly appreciated ... THANKS!!!
teachers can login and post new assignments, update grades, and post attendance each day there is school (basic CRUD functions)... and as well they can message parents and students...
administrators can login and make reports from such information, and change settings.....
what would be a proper mysql structure for such a web application using mysql???
keep in mind I need a login table as well as the ability to do the above?
ALL help will be highly appreciated ... THANKS!!!