How can i make better realtionship for my database

I'm very new in designing professional database system and making an School Management System in Laravel. I have issues setting my database. How to enroll student. To know the problem you must have to read requirement once.

Every Classroom can have minimum 1 or maximum many Section. Every Section has many list of Courses and Students enrolled in. Every Classroom has Teacher

The database I am thinking for this is

• Student (many-to-many forming Registration ) Classroom

• Classroom (many-to-many forming Class_Section ) Section

• Section (many-to-many forming Section_Courses ) Courses

or

• Student (many-to-many forming Registration ) Classroom

• Classroom {class_id, section_id(FK)} (one-to-many ) Section

• Section {section_id, course_id} (one-to-many ) Course

The thing I actual need is that when enrolling a student I want to register him in ClassRoom and in any section of that classroom. A Student can see all the courses of that section.

This makes clear that registration should have section id as well. But if I make relation of section with registration. It will show all sections.

Kindly suggest me a possible way for designing this database. I'm really stuck up here and can't find a better option for it.

via Chebli Mohamed