How to build schema/model of Tables for Student/Course allocation

I want to allocate courses to

students
semesters

I basically want to make the relation of

    - courses with semester
    - allocate semester to students

so students should have all courses which are taught in the chosen semester

please guide me on this

malico

6 years ago

Level 3

Hello @afrasiyabhaider,

I think what you need for your application is a many to many relationship. A student can have many courses he is taking and a course can be taken by many students.

http://laravel.com/docs/5.8/eloquent-relationships#many-to-many

afrasiyabhaider

6 years ago

Level 2

@malico thank you for your replay but I want to assign course to semester and then allocate semester to the student so a student can have all courses taught in selected semester.

Can you help me in understanding this scenario!

malico

6 years ago

Level 3

Migrations

Courses
- id
- semester_id

Semesters
- id 
- ...

Students
- id 
- ...
- semester_id

Models


// App\Student.php
class Student extends Model {

    public function courses()
    {
        return $this->hasManyThrough('App\Semester', 'App\Course');
    }
}

So with that your can query the students courses with

class StudentController extends Controller{
      public function controllerMethod(){
             $student->courses;
     }
}

Based on what you submit @afrasiyabhaider. Also check this out, it might help: https://github.com/staudenmeir/belongs-to-through

Please or to participate in this conversation.