This project is to build an online database; the database is to be called "What's My Homework?".
There will be up to 2000 pupil USERS.
Each user can sign up to any number of CLASSES
For each CLASS there will be a CLASSTEACHER (there may be up to 100 CLASSTEACHERS specified) and each CLASSTEACHER may be attached to any number of CLASSES.
For each class there can be any number of HOMEWORKS - each of which will have a number of dates, content etc.
I can provide the table structure for each of the above.
There also needs to be an interface with USERS, CLASSTEACHER and ADMIN logins
USERS can subscribe to any CLASS (or unsubscribe)
CLASSTEACHERS can create, edit and delte HOMEWORKS for any of their CLASSES
ADMIN can create USERS, CLASSTEACHERS and CLASSES