university management system

i am making a university management system and i need to add a time table it has 3 interphases students, lectures and admin similarly ,there is adatabase that is department,model,lectures , student and timetable

The columns in the time table data base are respectively department_name, year, semester, model, start_time, end_time, lecture. The department table contains the name of the department and the department id In the model table, there is a column that says the modli id, the name of the module, the year in which the model is in which semester and in which department. In the lecture table, lectures_name, id, and the module of the lecture are available I want to insert data into time_table table Insert data into the time_table table following conditions must be satisfied

First select the department in the timetable.blade.php file Four more years are given to choose and two semesters can be selected. These should be done using the radio button Now, according to the selected department, the models related to that department will be displayed There is also a way to insert the start time and end time into the table

condition

01.Here, at any time, one lecturer cannot have two lectures at the same time 02.And one student cannot have two lectures at the same time