I am learning to create a project for college management system with the following requirements and I need to come up with a database design:
- There are many departments and each department has many courses
- Each course has many batches and each batch has many semesters
- Each (course_semester_batch) has many subjects and each subject has classes
- A student can enroll for only one course and will belong to that batch
- A student has to pay fees after two semesters together for next two semesters and so
- Each department has its own faculty and one person is head of department
- A student must be approved first only the he can pay fees
- Subject teacher makes attendance of students
Here's what I have so far.
