utils/focusPrimaryElectivePopulator.sql
--Other Faculty Modules--
INSERT INTO module VALUES('IS2104', 'Other Faculty Module', 'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CP3101B', 'Other Faculty Module', 'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS5205', 'Other Faculty Module', 'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS5207', 'Other Faculty Module', 'Module belonging to other faculty', 4);
INSERT INTO module VALUES('IS4232', 'Other Faculty Module', 'Module belonging to other faculty', 4);
INSERT INTO module VALUES('IS4231', 'Other Faculty Module', 'Module belonging to other faculty', 4);
INSERT INTO module VALUES('IS3230', 'Other Faculty Module', 'Module belonging to other faculty', 4);
INSERT INTO module VALUES('IFS4101', 'Other Faculty Module', 'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS5247', 'Other Faculty Module', 'Module belonging to other faculty', 4);
INSERT INTO module VALUES('CS5209', 'Other Faculty Module', 'Module belonging to other faculty', 4);
--Algorithms & Theory--
--Primaries--
INSERT INTO belongsToFocus VALUES('CS3230', 'Algorithms & Theory', 'Primary');
INSERT INTO belongsToFocus VALUES('CS3236', 'Algorithms & Theory', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4231', 'Algorithms & Theory', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4232', 'Algorithms & Theory', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4234', 'Algorithms & Theory', 'Primary');
--Electives--
INSERT INTO belongsToFocus VALUES('CS3233', 'Algorithms & Theory', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5230', 'Algorithms & Theory', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5234', 'Algorithms & Theory', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5236', 'Algorithms & Theory', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5237', 'Algorithms & Theory', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5238', 'Algorithms & Theory', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5330', 'Algorithms & Theory', 'Elective');
--Artificial Intelligence--
--Primaries--
INSERT INTO belongsToFocus VALUES('CS3243', 'Artificial Intelligence', 'Primary');
INSERT INTO belongsToFocus VALUES('CS3244', 'Artificial Intelligence', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4244', 'Artificial Intelligence', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4246', 'Artificial Intelligence', 'Primary');
--Electives--
INSERT INTO belongsToFocus VALUES('CS4216', 'Artificial Intelligence', 'Elective');
INSERT INTO belongsToFocus VALUES('CS4220', 'Artificial Intelligence', 'Elective');
INSERT INTO belongsToFocus VALUES('CS4248', 'Artificial Intelligence', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5209', 'Artificial Intelligence', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5215', 'Artificial Intelligence', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5228', 'Artificial Intelligence', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5247', 'Artificial Intelligence', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5340', 'Artificial Intelligence', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5339', 'Artificial Intelligence', 'Elective');
--Computer Graphics and Games--
--Primaries--
INSERT INTO belongsToFocus VALUES('CS3241', 'Computer Graphics and Games', 'Primary');
INSERT INTO belongsToFocus VALUES('CS3242', 'Computer Graphics and Games', 'Primary');
INSERT INTO belongsToFocus VALUES('CS3247', 'Computer Graphics and Games', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4247', 'Computer Graphics and Games', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4350', 'Computer Graphics and Games', 'Primary');
--Electives--
INSERT INTO belongsToFocus VALUES('CS3218', 'Computer Graphics and Games', 'Elective');
INSERT INTO belongsToFocus VALUES('CS3240', 'Computer Graphics and Games', 'Elective');
INSERT INTO belongsToFocus VALUES('CS3249', 'Computer Graphics and Games', 'Elective');
INSERT INTO belongsToFocus VALUES('CS3343', 'Computer Graphics and Games', 'Elective');
INSERT INTO belongsToFocus VALUES('CS4243', 'Computer Graphics and Games', 'Elective');
INSERT INTO belongsToFocus VALUES('CS4249', 'Computer Graphics and Games', 'Elective');
INSERT INTO belongsToFocus VALUES('CS4340', 'Computer Graphics and Games', 'Elective');
INSERT INTO belongsToFocus VALUES('CS4344', 'Computer Graphics and Games', 'Elective');
INSERT INTO belongsToFocus VALUES('CS4345', 'Computer Graphics and Games', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5237', 'Computer Graphics and Games', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5240', 'Computer Graphics and Games', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5343', 'Computer Graphics and Games', 'Elective');
--Computer Security--
--Primaries--
INSERT INTO belongsToFocus VALUES('CS2107', 'Computer Security', 'Primary');
INSERT INTO belongsToFocus VALUES('CS3235', 'Computer Security', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4236', 'Computer Security', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4238', 'Computer Security', 'Primary');
--Electives--
INSERT INTO belongsToFocus VALUES('CS3221', 'Computer Security', 'Elective');
INSERT INTO belongsToFocus VALUES('CS4239', 'Computer Security', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5231', 'Computer Security', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5250', 'Computer Security', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5321', 'Computer Security', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5322', 'Computer Security', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5331', 'Computer Security', 'Elective');
INSERT INTO belongsToFocus VALUES('IFS4101', 'Computer Security', 'Elective');
--Unrestricted Electives--
INSERT INTO belongsToFocus VALUES('IS3230', 'Computer Security', 'Elective');
INSERT INTO belongsToFocus VALUES('IS4231', 'Computer Security', 'Elective');
INSERT INTO belongsToFocus VALUES('IS4232', 'Computer Security', 'Elective');
--Database Systems--
--Primaries--
INSERT INTO belongsToFocus VALUES('CS2102', 'Database Systems', 'Primary');
INSERT INTO belongsToFocus VALUES('CS3223', 'Database Systems', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4221', 'Database Systems', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4224', 'Database Systems', 'Primary');
--Electives--
INSERT INTO belongsToFocus VALUES('CS4220', 'Database Systems', 'Elective');
INSERT INTO belongsToFocus VALUES('CS4225', 'Database Systems', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5226', 'Database Systems', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5228', 'Database Systems', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5322', 'Database Systems', 'Elective');
--Multimedia Information Retrieval--
--Primaries--
INSERT INTO belongsToFocus VALUES('CS2108', 'Multimedia Information Retrieval', 'Primary');
INSERT INTO belongsToFocus VALUES('CS3245', 'Multimedia Information Retrieval', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4242', 'Multimedia Information Retrieval', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4248', 'Multimedia Information Retrieval', 'Primary');
--Electives--
INSERT INTO belongsToFocus VALUES('CS4347', 'Multimedia Information Retrieval', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5246', 'Multimedia Information Retrieval', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5241', 'Multimedia Information Retrieval', 'Elective');
INSERT INTO belongsToFocus VALUES('CS6242', 'Multimedia Information Retrieval', 'Elective');
--Interactive Media--
--Primaries--
INSERT INTO belongsToFocus VALUES('CS3241', 'Interactive Media', 'Primary');
INSERT INTO belongsToFocus VALUES('CS3242', 'Interactive Media', 'Primary');
INSERT INTO belongsToFocus VALUES('CS3247', 'Interactive Media', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4344', 'Interactive Media', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4350', 'Interactive Media', 'Primary');
INSERT INTO belongsToFocus VALUES('CS3240', 'Interactive Media', 'Primary');
INSERT INTO belongsToFocus VALUES('CS3249', 'Interactive Media', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4249', 'Interactive Media', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4347', 'Interactive Media', 'Primary');
--Electives--
INSERT INTO belongsToFocus VALUES('CS3218', 'Interactive Media', 'Elective');
INSERT INTO belongsToFocus VALUES('CS3343', 'Interactive Media', 'Elective');
INSERT INTO belongsToFocus VALUES('CS4340', 'Interactive Media', 'Elective');
INSERT INTO belongsToFocus VALUES('CS4243', 'Interactive Media', 'Elective');
INSERT INTO belongsToFocus VALUES('CS4247', 'Interactive Media', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5241', 'Interactive Media', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5342', 'Interactive Media', 'Elective');
--Networking and Distributed Systems--
--Primaries--
INSERT INTO belongsToFocus VALUES('CS2105', 'Networking and Distributed Systems', 'Primary');
INSERT INTO belongsToFocus VALUES('CS3103', 'Networking and Distributed Systems', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4222', 'Networking and Distributed Systems', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4226', 'Networking and Distributed Systems', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4247', 'Networking and Distributed Systems', 'Primary');
--Electives--
INSERT INTO belongsToFocus VALUES('CS4231', 'Networking and Distributed Systems', 'Elective');
INSERT INTO belongsToFocus VALUES('CS4344', 'Networking and Distributed Systems', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5223', 'Networking and Distributed Systems', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5229', 'Networking and Distributed Systems', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5248', 'Networking and Distributed Systems', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5321', 'Networking and Distributed Systems', 'Elective');
--Parallel Computing--
--Primaries--
INSERT INTO belongsToFocus VALUES('CS3210', 'Parallel Computing', 'Primary');
INSERT INTO belongsToFocus VALUES('CS3211', 'Parallel Computing', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4231', 'Parallel Computing', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4223', 'Parallel Computing', 'Primary');
--Electives--
INSERT INTO belongsToFocus VALUES('CS4237', 'Parallel Computing', 'Elective');
INSERT INTO belongsToFocus VALUES('CS4271', 'Parallel Computing', 'Elective');
INSERT INTO belongsToFocus VALUES('CS4345', 'Parallel Computing', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5207', 'Parallel Computing', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5222', 'Parallel Computing', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5223', 'Parallel Computing', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5239', 'Parallel Computing', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5250', 'Parallel Computing', 'Elective');
--Programming Languages--
--Primaries--
INSERT INTO belongsToFocus VALUES('CS2104', 'Programming Languages', 'Primary');
INSERT INTO belongsToFocus VALUES('CS3211', 'Programming Languages', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4215', 'Programming Languages', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4212', 'Programming Languages', 'Primary');
--Electives--
INSERT INTO belongsToFocus VALUES('CS3234', 'Programming Languages', 'Elective');
INSERT INTO belongsToFocus VALUES('CS4216', 'Programming Languages', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5205', 'Programming Languages', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5232', 'Programming Languages', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5214', 'Programming Languages', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5215', 'Programming Languages', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5218', 'Programming Languages', 'Elective');
--Software Engineering--
--Primaries--
INSERT INTO belongsToFocus VALUES('CS2103', 'Software Engineering', 'Primary');
INSERT INTO belongsToFocus VALUES('CS2103T', 'Software Engineering', 'Primary');
INSERT INTO belongsToFocus VALUES('CS3213', 'Software Engineering', 'Primary');
INSERT INTO belongsToFocus VALUES('CS3219', 'Software Engineering', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4211', 'Software Engineering', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4218', 'Software Engineering', 'Primary');
--Electives--
INSERT INTO belongsToFocus VALUES('CS3216', 'Software Engineering', 'Elective');
INSERT INTO belongsToFocus VALUES('CS3217', 'Software Engineering', 'Elective');
INSERT INTO belongsToFocus VALUES('CS3226', 'Software Engineering', 'Elective');
INSERT INTO belongsToFocus VALUES('CP3101B', 'Software Engineering', 'Elective');
INSERT INTO belongsToFocus VALUES('CS3234', 'Software Engineering', 'Elective');
INSERT INTO belongsToFocus VALUES('CS3882', 'Software Engineering', 'Elective');
INSERT INTO belongsToFocus VALUES('CS4217', 'Software Engineering', 'Elective');
INSERT INTO belongsToFocus VALUES('CS4271', 'Software Engineering', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5219', 'Software Engineering', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5232', 'Software Engineering', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5272', 'Software Engineering', 'Elective');
--Unrestricted Electives--
INSERT INTO belongsToFocus VALUES('IS2102', 'Software Engineering', 'Elective');
INSERT INTO belongsToFocus VALUES('IS2104', 'Software Engineering', 'Elective');
--Visual Computing--
--Primaries--
INSERT INTO belongsToFocus VALUES('CS3241', 'Visual Computing', 'Primary');
INSERT INTO belongsToFocus VALUES('CS3242', 'Visual Computing', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4243', 'Visual Computing', 'Primary');
INSERT INTO belongsToFocus VALUES('CS4247', 'Visual Computing', 'Primary');
--Electives--
INSERT INTO belongsToFocus VALUES('CS3218', 'Visual Computing', 'Elective');
INSERT INTO belongsToFocus VALUES('CS3343', 'Visual Computing', 'Elective');
INSERT INTO belongsToFocus VALUES('CS4340', 'Visual Computing', 'Elective');
INSERT INTO belongsToFocus VALUES('CS4345', 'Visual Computing', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5237', 'Visual Computing', 'Elective');
INSERT INTO belongsToFocus VALUES('CS5240', 'Visual Computing', 'Elective');
INSERT INTO belongsToFocus VALUES('CS6243', 'Visual Computing', 'Elective');
--## Belonging to nowhere, to delete? ##--
--INSERT INTO belongsToFocus VALUES('CS5233', 'To Remove?', 'Elective');