School Management System DB Project
Design a database to maintain information about school staff and students satisfying
following properties:
1. Staff will have their id, name, and classes they are teaching
2. Student will be having name, roll no, section, class
3. Another table containing section, subject, and teacher information
4. Next will contain fee information for students
5. One contains salary information for teachers
6. Rooms are assigned to classes keeping in mind that there is no time clash of
same room or lab, students cannot be entered in more than one section, no
student should be there who have not paid fees up to a particular date.