//year 1 sem 1
INSERT INTO software_morning
 VALUES (10003, 4, 1, 1)

INSERT INTO software_morning
 VALUES (10035, 3.5, 1, 1)

INSERT INTO software_morning
 VALUES (10088, 4, 1, 1)

INSERT INTO software_morning
 VALUES (91014, 0, 1, 1)

INSERT INTO software_morning
 VALUES (10028, 5, 1, 1)

INSERT INTO software_morning
 VALUES (10078, 2.5, 1, 1)


//year 1 sem 2
INSERT INTO software_morning
 VALUES (10004, 4, 1, 2, 10003)

INSERT INTO software_morning
 VALUES (10017, 5, 1, 2, 10088)

INSERT INTO software_morning
 VALUES (10031, 3.5, 1, 2, 10028)

INSERT INTO software_morning
 VALUES (10071, 3.5, 1, 2, NULL, NULL, NULL, 10017)

INSERT INTO software_morning
 VALUES (10058, 3, 1, 2, 10028)

INSERT INTO software_morning
 VALUES (10074, 2.5, 1, 2, 10078)


//year 2 sem 1
INSERT INTO software_morning
 VALUES (10007, 3.5, 2, 1, 10004, 10031)

INSERT INTO software_morning
 VALUES (10018, 5, 2, 1, 10017)

INSERT INTO software_morning
 VALUES (10019, 3.5, 2, 1, 10074, 10003)

INSERT INTO software_morning
 VALUES (10024, 3, 2, 1)

INSERT INTO software_morning
 VALUES (10072, 3.5, 2, 1, 10071)

INSERT INTO software_morning
 VALUES (10057, 3, 2, 1, 10058)


//Year 2 sem 2
INSERT INTO software_morning
 VALUES (10008, 3.5, 2, 2, 10007)

INSERT INTO software_morning
 VALUES (10015, 2.5, 2, 2, 10074, 10018)

INSERT INTO software_morning
 VALUES (10036, 3.5, 2, 2, 10019, 10031)

INSERT INTO software_morning
 VALUES (10040, 4.5, 2, 2, 10057, 10031)

INSERT INTO software_morning
 VALUES (10046, 3.5, 2, 2, 10018, 10004)

INSERT INTO software_morning
 VALUES (91004, 2, 2, 2)

INSERT INTO software_morning
 VALUES (10030, 2.5, 2, 2, 10035)


//Year 3 sem 1
INSERT INTO software_morning
 VALUES (10001, 4.5, 3, 1, 10046, 10072)

INSERT INTO software_morning
 VALUES (10077, 3.5, 3, 1, 10018, 10004)

INSERT INTO software_morning
 VALUES (10014, 3.5, 3, 1, 10057, 10040)

INSERT INTO software_morning
 VALUES (10016, 2.5, 3, 1, 10015)

INSERT INTO software_morning
 VALUES (10032, 3.5, 3, 1, 10031)

INSERT INTO software_morning
 VALUES (10061, 3.5, 3, 1, 10040)

INSERT INTO software_morning
 VALUES (10039, 2.5, 3, 1, null, null, null, 10061)


//Year 3 sem 2
INSERT INTO software_morning
 VALUES (10034, 4, 3, 2, 10030, 10035)

INSERT INTO software_morning
 VALUES (10041, 3.5, 3, 2, 10061)

INSERT INTO software_morning
 VALUES (10049, 3.5, 3, 2, 10001)

INSERT INTO software_morning
 VALUES (10054, 3.5, 3, 2, 10057)

INSERT INTO software_morning
 VALUES (10083, 5, 3, 2, 10058, 10032)


//Year 4 sem 1
INSERT INTO software_morning
 VALUES (10043, 2.5, 4, 1, 10014)

INSERT INTO software_morning
 VALUES (10042, 4, 4, 1, 10040)

INSERT INTO software_morning
 VALUES (10051, 5, 4, 1)

//Year 4 sem 2

INSERT INTO software_morning
 VALUES (10070, 2.5, 4, 2, 10036)

INSERT INTO software_morning
 VALUES (10048, 3, 4, 2, 10024)

INSERT INTO software_morning
 VALUES ()