nus-mtp/cs-modify

View on GitHub
utils/preclusionPopulator.sql

Summary

Maintainability
Test Coverage
INSERT INTO module VALUES('CG1102', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CG1101', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('DSC3211', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS4260', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS4264', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS4265', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS4349', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS4202', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS3109', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS3108A', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS4213', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS4204', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS3108B', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('EE3208', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('EE3304', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS1305', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS3209', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS4230', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS5245', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('EE3032', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS3881', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS3880', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('IS4260', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('EE4214', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CZ1102', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('ES2002', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS2305S', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS3266', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('IS2101', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('EG1413', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('ES2007S', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS4101', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS1010FC', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('ES2007D', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO module VALUES('GEM1501M', 'Other Faculty Module',  'Module belonging to other faculty', 4);
INSERT INTO precludes VALUES('CS2309', 'CS2305S');
INSERT INTO precludes VALUES('CS1102', 'CS1020');
INSERT INTO precludes VALUES('CS1010', 'CS1101');
INSERT INTO precludes VALUES('CG1102', 'CS1020');
INSERT INTO precludes VALUES('IT1002', 'CS1102');
INSERT INTO precludes VALUES('CS2020', 'CG1102');
INSERT INTO precludes VALUES('CS1102C', 'CS1102');
INSERT INTO precludes VALUES('CS3284', 'CS4201');
INSERT INTO precludes VALUES('CS2106', 'CG2271');
INSERT INTO precludes VALUES('IT1002', 'CS1010E');
INSERT INTO precludes VALUES('IT1005', 'IT1006');
INSERT INTO precludes VALUES('IT1005', 'CS1101S');
INSERT INTO precludes VALUES('CS1020', 'CS2020');
INSERT INTO precludes VALUES('IT1006', 'CS1010E');
INSERT INTO precludes VALUES('CS1102S', 'CS1020');
INSERT INTO precludes VALUES('CS2101', 'CG1413');
INSERT INTO precludes VALUES('CZ1102', 'IT1001');
INSERT INTO precludes VALUES('IT1001', 'GEK1511');
INSERT INTO precludes VALUES('CS1020', 'CG1102');
INSERT INTO precludes VALUES('CS1020', 'CS1020E');
INSERT INTO precludes VALUES('CS1010', 'CS1101C');
INSERT INTO precludes VALUES('CS2103T', 'IS2101');
INSERT INTO precludes VALUES('XFC4101', 'CS4101');
INSERT INTO precludes VALUES('IT1001', 'CS1101');
INSERT INTO precludes VALUES('IS2101', 'CS2103T');
INSERT INTO precludes VALUES('CS3202', 'CS3215');
INSERT INTO precludes VALUES('GEM1501', 'GEM1501M');
INSERT INTO precludes VALUES('CS1101C', 'CS1101S');
INSERT INTO precludes VALUES('CG1103', 'CS2020');
INSERT INTO precludes VALUES('CS1102S', 'CS2020');
INSERT INTO precludes VALUES('CS2020', 'CS1102');
INSERT INTO precludes VALUES('IT1002', 'CS1101');
INSERT INTO precludes VALUES('CS1020E', 'CG1103');
INSERT INTO precludes VALUES('CS3283', 'CS4203');
INSERT INTO precludes VALUES('CS1010', 'CS1010X');
INSERT INTO precludes VALUES('CS2010', 'CS1102S');
INSERT INTO precludes VALUES('IT1004', 'CS3266');
INSERT INTO precludes VALUES('XFC4101', 'CP4101');
INSERT INTO precludes VALUES('CP3108B', 'CS3108B');
INSERT INTO precludes VALUES('CS4350', 'CS4203');
INSERT INTO precludes VALUES('CS1101', 'IT1002');
INSERT INTO precludes VALUES('CG1413', 'CS2101');
INSERT INTO precludes VALUES('CP3208', 'CS3208');
INSERT INTO precludes VALUES('IS4260', 'IT1004');
INSERT INTO precludes VALUES('IT1002', 'IF2206');
INSERT INTO precludes VALUES('CS1102C', 'IT1002');
INSERT INTO precludes VALUES('CS4203', 'CS3283');
INSERT INTO precludes VALUES('CS2101', 'ES2007S');
INSERT INTO precludes VALUES('CS4341', 'CS3246');
INSERT INTO precludes VALUES('CS1102', 'CS1020E');
INSERT INTO precludes VALUES('CP3109', 'CS3109');
INSERT INTO precludes VALUES('CS3215', 'CS3202');
INSERT INTO precludes VALUES('CS1010E', 'IT1001');
INSERT INTO precludes VALUES('CS3103L', 'CG3204L');
INSERT INTO precludes VALUES('CS1020E', 'CS2020');
INSERT INTO precludes VALUES('CP3209', 'CS3209');
INSERT INTO precludes VALUES('IT2002', 'CS2102');
INSERT INTO precludes VALUES('CS1010', 'CS1010FC');
INSERT INTO precludes VALUES('CS2101', 'ES2007D');
INSERT INTO precludes VALUES('IT1002', 'CS1101S');
INSERT INTO precludes VALUES('IT1004', 'CS4264');
INSERT INTO precludes VALUES('IT1001', 'CS1101C');
INSERT INTO precludes VALUES('CS1102C', 'CS1020');
INSERT INTO precludes VALUES('CS4260', 'IT1004');
INSERT INTO precludes VALUES('CS3880', 'CP3880');
INSERT INTO precludes VALUES('CS2101', 'ES2002');
INSERT INTO precludes VALUES('CP4101', 'XFC4101');
INSERT INTO precludes VALUES('CS1101S', 'CS1010FC');
INSERT INTO precludes VALUES('CS3201', 'CS3215');
INSERT INTO precludes VALUES('CG1102', 'CS1020E');
INSERT INTO precludes VALUES('CS3283', 'CS4201');
INSERT INTO precludes VALUES('CS1102', 'CS1102C');
INSERT INTO precludes VALUES('CS1101S', 'CS1010E');
INSERT INTO precludes VALUES('IT1005', 'CG1101');
INSERT INTO precludes VALUES('CS2020', 'CS1102C');
INSERT INTO precludes VALUES('CS3283', 'CS4204');
INSERT INTO precludes VALUES('IF2206', 'IT1002');
INSERT INTO precludes VALUES('IT1006', 'CS1101S');
INSERT INTO precludes VALUES('CS1010FC', 'IT1006');
INSERT INTO precludes VALUES('CS1102', 'CS1102S');
INSERT INTO precludes VALUES('GEK1511', 'IT1001');
INSERT INTO precludes VALUES('CS4342', 'CS3242');
INSERT INTO precludes VALUES('CS2103', 'CS2103T');
INSERT INTO precludes VALUES('CS2105', 'EE3204');
INSERT INTO precludes VALUES('CS2105', 'EE4210');
INSERT INTO precludes VALUES('CP3880', 'CS3880');
INSERT INTO precludes VALUES('CS2102S', 'IT2002');
INSERT INTO precludes VALUES('EG1413', 'CS2101');
INSERT INTO precludes VALUES('CS1010S', 'CS1010');
INSERT INTO precludes VALUES('CS1101S', 'IT1001');
INSERT INTO precludes VALUES('CS3209', 'CP3209');
INSERT INTO precludes VALUES('CS4203', 'CS4350');
INSERT INTO precludes VALUES('CS3219', 'CS3213');
INSERT INTO precludes VALUES('CP3108A', 'CS3108A');
INSERT INTO precludes VALUES('IT1004', 'CS4260');
INSERT INTO precludes VALUES('IT1004', 'DSC3211');
INSERT INTO precludes VALUES('ES2007D', 'CS2101');
INSERT INTO precludes VALUES('IT1002', 'CS1101C');
INSERT INTO precludes VALUES('IT1001', 'CZ1102');
INSERT INTO precludes VALUES('CS1102S', 'CS1102');
INSERT INTO precludes VALUES('CG3204L', 'CS3103');
INSERT INTO precludes VALUES('CS1010S', 'IT1006');
INSERT INTO precludes VALUES('CS2100', 'CS1104');
INSERT INTO precludes VALUES('CG3204L', 'CS3103L');
INSERT INTO precludes VALUES('CS2020', 'CS1020E');
INSERT INTO precludes VALUES('CS4203', 'CS3284');
INSERT INTO precludes VALUES('CS4340', 'CS5245');
INSERT INTO precludes VALUES('EE3208', 'CG3002');
INSERT INTO precludes VALUES('IT1005', 'IT1002');
INSERT INTO precludes VALUES('GEM1501', 'CS1305');
INSERT INTO precludes VALUES('IT2001', 'EE4210');
INSERT INTO precludes VALUES('CS4204', 'CS3283');
INSERT INTO precludes VALUES('CS1101', 'CS1010');
INSERT INTO precludes VALUES('CS2020', 'CS1020');
INSERT INTO precludes VALUES('CS1010FC', 'CS1010');
INSERT INTO precludes VALUES('CS2106', 'EE4214');
INSERT INTO precludes VALUES('IT1005', 'CZ1102');
INSERT INTO precludes VALUES('CG1102', 'CS2010');
INSERT INTO precludes VALUES('CS1102C', 'CS1102S');
INSERT INTO precludes VALUES('EE3204', 'CS2105');
INSERT INTO precludes VALUES('CS4204', 'CS4350');
INSERT INTO precludes VALUES('CS3246', 'CS4341');
INSERT INTO precludes VALUES('CS1102', 'CS2020');
INSERT INTO precludes VALUES('CG1103', 'CS1020E');
INSERT INTO precludes VALUES('CS3108B', 'CP3108B');
INSERT INTO precludes VALUES('CS2010', 'CS1102C');
INSERT INTO precludes VALUES('CS1101C', 'IT1002');
INSERT INTO precludes VALUES('IT2002', 'CS2102S');
INSERT INTO precludes VALUES('CS4265', 'IT1004');
INSERT INTO precludes VALUES('CS5230', 'CS4230');
INSERT INTO precludes VALUES('CS1020E', 'CS1020');
INSERT INTO precludes VALUES('CS1101S', 'CS1101');
INSERT INTO precludes VALUES('EE4210', 'IT2001');
INSERT INTO precludes VALUES('CG1103', 'CS1020');
INSERT INTO precludes VALUES('CS1020', 'CS1102');
INSERT INTO precludes VALUES('CS2102S', 'CS2102');
INSERT INTO precludes VALUES('IT1001', 'CS1010E');
INSERT INTO precludes VALUES('CS1305', 'GEM1501');
INSERT INTO precludes VALUES('CS1020E', 'CS1102C');
INSERT INTO precludes VALUES('ES2002', 'CS2101');
INSERT INTO precludes VALUES('CS2010', 'CS2020');
INSERT INTO precludes VALUES('CS1101S', 'IT1002');
INSERT INTO precludes VALUES('CG3002', 'EE3208');
INSERT INTO precludes VALUES('CS1010X', 'CS1010');
INSERT INTO precludes VALUES('EE3032', 'CG3002');
INSERT INTO precludes VALUES('CS2305S', 'CS2309');
INSERT INTO precludes VALUES('CG3002', 'EE3032');
INSERT INTO precludes VALUES('CS1020', 'CS1102C');
INSERT INTO precludes VALUES('IT1002', 'CS1102C');
INSERT INTO precludes VALUES('IT1006', 'CS1010FC');
INSERT INTO precludes VALUES('CG1102', 'CS2020');
INSERT INTO precludes VALUES('CS3108A', 'CP3108A');
INSERT INTO precludes VALUES('CS4101', 'XFC4101');
INSERT INTO precludes VALUES('CS3208', 'CP3208');
INSERT INTO precludes VALUES('IT1006', 'CS1010S');
INSERT INTO precludes VALUES('IT1005', 'CS1010');
INSERT INTO precludes VALUES('CS1101S', 'CS1010');
INSERT INTO precludes VALUES('CS1102C', 'CS1020E');
INSERT INTO precludes VALUES('IT2001', 'CS2105');
INSERT INTO precludes VALUES('CS1104', 'CS2100');
INSERT INTO precludes VALUES('CS1020', 'CG1103');
INSERT INTO precludes VALUES('CS1102S', 'CS1020E');
INSERT INTO precludes VALUES('CS1101S', 'CS1101C');
INSERT INTO precludes VALUES('CG3204L', 'CS2105');
INSERT INTO precludes VALUES('CS4264', 'IT1004');
INSERT INTO precludes VALUES('ES2007S', 'CS2101');
INSERT INTO precludes VALUES('CS2102', 'IT2002');
INSERT INTO precludes VALUES('CG2271', 'CS2106');
INSERT INTO precludes VALUES('GEM1501M', 'GEM1501');
INSERT INTO precludes VALUES('CS3109', 'CP3109');
INSERT INTO precludes VALUES('IT2001', 'EE3204');
INSERT INTO precludes VALUES('DSC3211', 'IT1004');
INSERT INTO precludes VALUES('CS3213', 'CS3219');
INSERT INTO precludes VALUES('IT1004', 'CS4265');
INSERT INTO precludes VALUES('CS1101C', 'IT1001');
INSERT INTO precludes VALUES('CS3266', 'IT1004');
INSERT INTO precludes VALUES('CS2101', 'EG1413');
INSERT INTO precludes VALUES('CS1010', 'CS1010J');
INSERT INTO precludes VALUES('CS4202', 'CS3283');
INSERT INTO precludes VALUES('CS2101', 'IS2101');
INSERT INTO precludes VALUES('CS2103T', 'CS2103');
INSERT INTO precludes VALUES('CS1010', 'CS1101S');
INSERT INTO precludes VALUES('CS1102C', 'CS2010');
INSERT INTO precludes VALUES('CS2105', 'CG3204L');
INSERT INTO precludes VALUES('CG1101', 'IT1005');
INSERT INTO precludes VALUES('CS1101S', 'IT1005');
INSERT INTO precludes VALUES('CS4204', 'CS3284');
INSERT INTO precludes VALUES('CS3284', 'CS4202');
INSERT INTO precludes VALUES('CS2102', 'CS2102S');
INSERT INTO precludes VALUES('CS1101S', 'IT1006');
INSERT INTO precludes VALUES('CS1010E', 'IT1006');
INSERT INTO precludes VALUES('CS1010', 'IT1005');
INSERT INTO precludes VALUES('CS1101', 'CS1101S');
INSERT INTO precludes VALUES('CS1101C', 'CS1010');
INSERT INTO precludes VALUES('CS4201', 'CS3284');
INSERT INTO precludes VALUES('IT1006', 'IT1005');
INSERT INTO precludes VALUES('CS1010FC', 'CS1101S');
INSERT INTO precludes VALUES('CZ1102', 'IT1005');
INSERT INTO precludes VALUES('CS5245', 'CS4340');
INSERT INTO precludes VALUES('CS1102', 'IT1002');
INSERT INTO precludes VALUES('CS1010', 'IT1002');
INSERT INTO precludes VALUES('CS1010E', 'CS1101S');
INSERT INTO precludes VALUES('CS3284', 'CS4203');
INSERT INTO precludes VALUES('EE4210', 'CS2105');
INSERT INTO precludes VALUES('IT1001', 'CS1010');
INSERT INTO precludes VALUES('CS1102S', 'CS1102C');
INSERT INTO precludes VALUES('CS2010', 'CS1102');
INSERT INTO precludes VALUES('EE3204', 'IT2001');
INSERT INTO precludes VALUES('CS2020', 'CS1102S');
INSERT INTO precludes VALUES('CS3283', 'CS4202');
INSERT INTO precludes VALUES('CS1010E', 'IT1002');
INSERT INTO precludes VALUES('CS3215', 'CS3201');
INSERT INTO precludes VALUES('IT1004', 'IS4260');
INSERT INTO precludes VALUES('CS4230', 'CS5230');
INSERT INTO precludes VALUES('CS2105', 'IT2001');
INSERT INTO precludes VALUES('CS2020', 'CS2010');
INSERT INTO precludes VALUES('IT1006', 'CS1010');
INSERT INTO precludes VALUES('CS1010', 'CG1101');
INSERT INTO precludes VALUES('CS1010', 'IT1006');
INSERT INTO precludes VALUES('CS1010E', 'IT1005');
INSERT INTO precludes VALUES('CS4202', 'CS3284');
INSERT INTO precludes VALUES('CS4213', 'CS3247');
INSERT INTO precludes VALUES('CS3103', 'CG3204L');
INSERT INTO precludes VALUES('CG1101', 'IT1006');
INSERT INTO precludes VALUES('EE3304', 'CS3271');
INSERT INTO precludes VALUES('CS3242', 'CS4342');
INSERT INTO precludes VALUES('CS1010E', 'CS1010');
INSERT INTO precludes VALUES('CS3881', 'CP3881');
INSERT INTO precludes VALUES('IT1002', 'CS1010');
INSERT INTO precludes VALUES('CS3271', 'EE3304');
INSERT INTO precludes VALUES('CS4350', 'CS4204');
INSERT INTO precludes VALUES('CS1020E', 'CS1102S');
INSERT INTO precludes VALUES('CS3284', 'CS4204');
INSERT INTO precludes VALUES('IS2101', 'CS2101');
INSERT INTO precludes VALUES('CS1010', 'CS1010S');
INSERT INTO precludes VALUES('CG1101', 'CS1010');
INSERT INTO precludes VALUES('IT1001', 'CS1101S');
INSERT INTO precludes VALUES('CS1101', 'IT1001');
INSERT INTO precludes VALUES('IT1006', 'CG1101');
INSERT INTO precludes VALUES('IT1002', 'IT1005');
INSERT INTO precludes VALUES('CS1020E', 'CS1102');
INSERT INTO precludes VALUES('CS1102', 'CS2010');
INSERT INTO precludes VALUES('CS4201', 'CS3283');
INSERT INTO precludes VALUES('CS1102S', 'CS2010');
INSERT INTO precludes VALUES('CS1010', 'CS1010E');
INSERT INTO precludes VALUES('CS4349', 'XFC4101');
INSERT INTO precludes VALUES('MA1100', 'CS1231');
INSERT INTO precludes VALUES('CS1102C', 'CS2020');
INSERT INTO precludes VALUES('CS2010', 'CG1102');
INSERT INTO precludes VALUES('XFC4101', 'CS4349');
INSERT INTO precludes VALUES('CS1010', 'IT1001');
INSERT INTO precludes VALUES('IT1005', 'CS1010E');
INSERT INTO precludes VALUES('CS1231', 'MA1100');
INSERT INTO precludes VALUES('EE4214', 'CS2106');
INSERT INTO precludes VALUES('CS1020E', 'CG1102');
INSERT INTO precludes VALUES('CS3247', 'CS4213');
INSERT INTO precludes VALUES('CS2020', 'CG1103');
INSERT INTO precludes VALUES('CP3881', 'CS3881');
INSERT INTO precludes VALUES('CS1010J', 'CS1010');
INSERT INTO precludes VALUES('CS1020', 'CS1102S');