i will give you a list of courses and an insert statment do all the courses the same way as the insert if a course has two prerequest only give the first one,  this is the insert DB::table('courses')->insert([
        ['id' => 1, 'courseCode' => 'ARAB 110', 'courseName' => 'Arabic Language Skills', 'credits' => 3, 'prerequisite_id' => null, 'major_id' => 1],
        ['id' => 2, 'courseCode' => 'ITCS 113', 'courseName' => 'Computer Programming I', 'credits' => 3, 'prerequisite_id' => null, 'major_id' => 1],
        // Insert the remaining courses with their respective prerequisite_id and major_id values
        // ...
    ]); , and this is the courses Course Code Course Title
Course Hours Course 
Type
Pre
requisite
Major 
LEC PRAC CRD GPA
ARAB 110 Arabic Language Skills 3 0 3 UR ------ No
ITCS 113 Computer Programming I 3 2 3 CR ------ Yes
ENGL 154 Language Development I 3 0 3 CR ------ No
MATHS 101 Calculus I 3 0 3 CR ------ No
PHYCS 101 General Physics I 3 3 4 MSR ------ No
Year 1 - Semester 2
Course Code Course Title
Course Hours Course 
Type
Pre
requisite
Major 
LEC PRAC CRD GPA
ITCS 114 Computer Programming II 3 2 3 CR ITCS 113 Yes
ENGL 155 Language Development II 3 0 3 CR ENGL 154 No
PHYCS 102 General Physics II 3 3 4 MSR PHYCS 101 No
ITIS 103 Fundamentals of Information Systems 3 2 3 MR ------ Yes
MATHS 102 Calculus II 3 0 3 MSR MATHS 101 No
Year 2 - Semester 3
Course Code Course Title
Course Hours Course 
Type
Pre
requisite
Major 
LEC PRAC CRD GPA
HIST 122 Modern History of Bahrain and Citizenship 3 0 3 UR ------ No
ISLM 101 Islamic Culture 3 0 3 UR ------ No
ITCS 214 Data Structures 3 2 3 CR ITCS 114 Yes
STAT 273 Probability and Statistics 3 0 3 CR MATHS 101 No
ITCE 250 Digital Logic 3 2 3 MR ITCS 113 Yes
ITCS 254 Discrete Structures I 3 2 3 CR ITCS 113 & 
MATHS 101 Yes
Detailed Study Plan
3
Year 2 - Semester 4
Course Code Course Title
Course Hours Course 
Type
Pre
requisite
Major 
LEC PRAC CRD GPA
ITCS 255 Discrete Structures II 3 2 3 MR ITCS 254 Yes
GSE XXX Science Elective X X 4 GSE ------ No
ITCS 285 Database Management Systems 3 2 3 MR ITCS 214 Yes
ENGL 219 Technical Report Writing 3 0 3 CR ENGL 155 No
ITCS 316 Human-Computer Interaction 3 2 3 MR ITCS 214 Yes
Year 3 - Semester 5
Course Code Course Title
Course Hours Course 
Type
Pre
requisite
Major 
LEC PRAC CRD GPA
ITCS 347 Analysis and Design of Algorithms 3 2 3 MR ITCS 214 & 
ITCS 255 Yes
ITCS 321 Computer Organization and Assembly 
Language 3 2 3 MR ITCS 114 & 
ITCE 250 Yes
ITCS 333 Internet Software Development 3 2 3 MR ITCS 285 Yes
ITCS 389 Software Engineering I 3 2 3 MR ITCS 285 Yes
ITCS 396 Professional Issues and Ethics 3 2 3 MR ENGL 219 Yes
MATHS 211 Linear Algebra 3 0 3 MSR MATHS 101 No
Year 3 - Semester 6
Course Code Course Title
Course Hours Course 
Type
Pre
requisite
Major 
LEC PRAC CRD GPA
ITCS 317 Formal Languages and Automata 3 2 3 MR ITCS 214 & 
ITCS 255 Yes
ITCS 325 Operating Systems 3 2 3 MR ITCS 214 &
ITCS 321 Yes
HRLC 107 Human Rights 2 0 2 UR ------ No
ITCS 4XX ITCS Elective 1 3 2 3 ME As per ME 
list Yes
ITCE 314 Computer Networks I 3 2 3 MR ITCS 114 &
STAT 273 Yes
ITCS 489 Software Engineering II 3 2 3 MR ITCS 389 Yes
STAT 271* for college of Science students only
4
Training Requirement
Course Code Course Title
Course Hours Course 
Type
Pre
requisite
Major 
LEC PRAC CRD GPA
ITCS 481 Industrial Training 0 3 1
CRTraining 
Pass 85 
Credits Yes
Year 4 - Semester 7
Course Code Course Title
Course Hours Course 
Type
Pre
requisite
Major 
LEC PRAC CRD GPA
ITCS 440 Intelligent Systems 3 2 3 MR ITCS 347 Yes
GSE XXX Business Free Elective 3 0 3 GSE ------ No
ITCE 416 Computer Networks II 3 2 3 MR ITCE 314 Yes
ITCS 4XX ITCS Elective 2 3 2 3 ME As per ME 
list Yes
ITCS 498 Senior Project 0 6 3 MR
ENGL 219 & 
pass 85 
credits
Yes
Year 4 - Semester 8
Course Code Course Title
Course Hours Course 
Type
Pre
requisite
Major 
LEC PRAC CRD GPA
ITCS 411 Cryptography and Computer Security 3 2 3 MR ITCS 347 Yes
ITCS 4XX ITCS Elective 3 3 2 3 ME As per ME 
list Yes
ITCS 4XX ITCS Elective 4 3 2 3 ME As per ME 
list Yes
GSE XXX Humanities / Social Sciences 3 0 3 GSE ------ No
ITCS 441 Parallel and Distributed Computing 3 2 3 MR ITCS 325 Yes