web applications - Help on designing a database for a school management system -

Hi, I am about to create a school management system where teachers, courses, classes, parents, and relativity between the children should be assured.

Students, report cards, enrollment, administration, attendance ...

Some good ideas on DB structure and system will be appreciated.

I think that they are the key to getting right that information is stored in TIME.

For example, you should only use DB Schema

class ----- student-class----- student

Because of a class like ' Students of 11th Science Science will have each semester in different disciplines, so each class will have to link to one semester to join the semester so that you can see which year 2011 is of science or 2011 in which students are students.

This situation applies to students whether they are currently nominated or not? Most of the work is around the time to override the position of the object.

How do you know about collecting it, it is up to you and how do you want to use the data? Do you want to store it in this form?