nus-mtp/cs-modify

INSERT INTO studentPlans VALUES('D1000000A', TRUE, 'CS1010', 'AY 16/17 Sem 1');
INSERT INTO studentPlans VALUES('D1000001A', TRUE, 'CS1010', 'AY 16/17 Sem 1');
INSERT INTO studentPlans VALUES('D1000002A', TRUE, 'CS1010', 'AY 16/17 Sem 1');
INSERT INTO studentPlans VALUES('D1000003A', FALSE, 'CS1010', 'AY 16/17 Sem 2');
INSERT INTO studentPlans VALUES('D1000000A', FALSE, 'CS1020', 'AY 16/17 Sem 2');
INSERT INTO studentPlans VALUES('D1000001A', FALSE, 'CS1020', 'AY 16/17 Sem 2');
INSERT INTO studentPlans VALUES('D1000002A', FALSE, 'CS1020', 'AY 16/17 Sem 2');
INSERT INTO studentPlans VALUES('D1000000A', TRUE, 'CS1231', 'AY 16/17 Sem 1');
INSERT INTO studentPlans VALUES('D1000001A', TRUE, 'CS1231', 'AY 16/17 Sem 1');
INSERT INTO studentPlans VALUES('D1000002A', TRUE, 'CS1231', 'AY 16/17 Sem 1');
INSERT INTO studentPlans VALUES('D1000000A', TRUE, 'CS2105', 'AY 16/17 Sem 1');
INSERT INTO studentPlans VALUES('D1000001A', TRUE, 'CS2105', 'AY 16/17 Sem 1');
INSERT INTO studentPlans VALUES('D1000002A', TRUE, 'CS2106', 'AY 16/17 Sem 1');
INSERT INTO studentPlans VALUES('D1000000A', TRUE, 'CP3200', 'AY 17/18 Sem 1');
INSERT INTO studentPlans VALUES('D1000001A', TRUE, 'CP3200', 'AY 17/18 Sem 1');

INSERT INTO studentPlans VALUES('D2000000A', TRUE, 'CS2010', 'AY 16/17 Sem 1');
INSERT INTO studentPlans VALUES('D2000001A', TRUE, 'CS2010', 'AY 16/17 Sem 1');
INSERT INTO studentPlans VALUES('D2000002A', TRUE, 'CS2010', 'AY 16/17 Sem 1');
INSERT INTO studentPlans VALUES('D2000000A', FALSE, 'CS3230', 'AY 16/17 Sem 2');
INSERT INTO studentPlans VALUES('D2000001A', FALSE, 'CS3230', 'AY 16/17 Sem 2');
INSERT INTO studentPlans VALUES('D2000002A', FALSE, 'CS3230', 'AY 16/17 Sem 2');
INSERT INTO studentPlans VALUES('D2000002A', FALSE, 'CP3200', 'AY 17/18 Sem 1');

INSERT INTO studentPlans VALUES('D3000000A', TRUE, 'CS3244', 'AY 16/17 Sem 1');
INSERT INTO studentPlans VALUES('D3000000A', FALSE, 'CS3243', 'AY 16/17 Sem 2');
INSERT INTO studentPlans VALUES('D3000001A', TRUE, 'CS3241', 'AY 16/17 Sem 1');
INSERT INTO studentPlans VALUES('D3000001A', FALSE, 'CS3242', 'AY 16/17 Sem 2');
INSERT INTO studentPlans VALUES('D3000002A', TRUE, 'CS2102', 'AY 16/17 Sem 1');
INSERT INTO studentPlans VALUES('D3000002A', FALSE, 'CS3223', 'AY 16/17 Sem 2');
INSERT INTO studentPlans VALUES('D3000002A', FALSE, 'CP3200', 'AY 17/18 Sem 2');

INSERT INTO studentPlans VALUES('D4000000A', TRUE, 'BT5110', 'AY 16/17 Sem 1');
INSERT INTO studentPlans VALUES('D4000000A', TRUE, 'CS4246', 'AY 16/17 Sem 1');
INSERT INTO studentPlans VALUES('D4000000A', FALSE, 'CS4244', 'AY 16/17 Sem 2');
INSERT INTO studentPlans VALUES('D4000001A', TRUE, 'CS4350', 'AY 16/17 Sem 1');
INSERT INTO studentPlans VALUES('D4000001A', FALSE, 'CS3247', 'AY 16/17 Sem 2');
INSERT INTO studentPlans VALUES('D4000002A', TRUE, 'CS4224', 'AY 16/17 Sem 1');
INSERT INTO studentPlans VALUES('D4000002A', FALSE, 'CS4221', 'AY 16/17 Sem 2');
INSERT INTO studentPlans VALUES('D4000002A', FALSE, 'CP3880', 'AY 17/18 Sem 1');
INSERT INTO studentPlans VALUES('D4000001A', FALSE, 'CP3880', 'AY 17/18 Sem 2');

INSERT INTO studentPlans VALUES('D5000000A', TRUE, 'CS1010', 'AY 16/17 Sem 1');
INSERT INTO studentPlans VALUES('D5000001A', TRUE, 'CS1010', 'AY 16/17 Sem 1');
INSERT INTO studentPlans VALUES('D5000002A', TRUE, 'CS1010', 'AY 16/17 Sem 2');
INSERT INTO studentPlans VALUES('D5000000A', FALSE, 'CS3201', 'AY 17/18 Sem 1');
INSERT INTO studentPlans VALUES('D5000001A', FALSE, 'CS3201', 'AY 17/18 Sem 1');
INSERT INTO studentPlans VALUES('D5000002A', FALSE, 'CS3201', 'AY 17/18 Sem 1');
INSERT INTO studentPlans VALUES('D5000003A', FALSE, 'CS3201', 'AY 17/18 Sem 1');
INSERT INTO studentPlans VALUES('D5000004A', FALSE, 'CS3201', 'AY 17/18 Sem 1');