orbital.sql

-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jul 17, 2016 at 01:45 PM
-- Server version: 10.1.13-MariaDB
-- PHP Version: 5.6.21

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `orbital`
--

-- --------------------------------------------------------

--
-- Table structure for table `courses`
--

CREATE TABLE `courses` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `details` text NOT NULL,
  `faculty` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `courses`
--

INSERT INTO `courses` (`id`, `name`, `details`, `faculty`) VALUES
(1, 'Business Analytics', 'The Bachelor of Science (Business Analytics) degree programme is an inter-disciplinary undergraduate degree programme offered by the School of Computing with participation from the Business School, Faculty of Engineering, Faculty of Science, and Faculty of Arts and Social Sciences. This is a four-year direct honours programme which offers a common two-year broad-based inter-disciplinary curriculum where all students will read modules in Mathematics, Statistics, Economics, Accounting, Marketing, Decision Science, Industrial and Systems Engineering, Computer Science and Information Systems. Students in their third and fourth years of study may choose elective modules from two lists of either functional or methodological elective modules. Functional elective modules span business functions or sectors of marketing, retailing, logistics, healthcare, etc. Methodological elective modules include those related to big data techniques, statistics, text mining, data mining, social network analysis, econometrics, forecasting, operations research, etc. In sum, these elective modules span the most exciting and challenging areas of business analytics practice in the industry today.', 'soc'),
(2, 'Computer Engineering', 'The Computer Engineering programme (CEG) at NUS prepares its graduates to embark on a lifelong journey in designing computing systems for a smarter world – hence our theme “Designing Intelligence”.\r\n\r\nA sophisticated piece of hardware is useless without the software that brings it to life. Computer engineers introduce intelligence into every conceivable device --- from the smart phone that you cannot live without, to massive industrial control systems that power economies. They create the electronic systems in a modern car containing dozens of computing systems communicating through a network. They connect the physical world with cyberspace to enhance everything from entertainment to healthcare and the environment. CEG gives you the skills and knowledge to engineer exciting solutions that move as well as change the world.\r\n\r\nA uniquely multi-disciplinary programme, CEG transcends the traditional boundary of computer science and electrical engineering. You will enjoy the resources and opportunities offered by both the host departments: Computer Science and Electrical & Computer Engineering. The curriculum aims to bring real-world problems, solutions, and experiences into the university environment. You will have the opportunity to consolidate your knowledge through a unique Full-Year industrial attachment, and through overseas work or learning experience. With the solid fundamentals that the NUS Computer Engineering degree will give you, only imagination and ambition will be your limits.', 'soc'),
(3, 'Computer Science(Algorithms and Theory)', 'Algorithms and Theory provide foundations for computer science. A theoretical study of machines allows us to determine what in principle can be done by computers and how much resources (for example, time or space) are needed to do a particular task. Algorithm building underlies all computational tasks, and without a proper study and analysis of algorithms, programming efficiently would be next to impossible. This area also provides students knowledge about different models of computation, and how they relate to each other. For example, does availability of random bits help in completing a task faster? There are also various famous open problems, which have received a lot of public attention. For example Clay foundation has announced a million dollar prize for solving the question whether P=NP (see http://www.claymath.org/millennium/).', 'soc'),
(4, 'Computer Science(Artificial Intelligence)', 'Artificial Intelligence (AI) is the branch of computer science that aims to create intelligent machines. It is important because it affects us in many aspects of our lives: smart appliances (refrigerators, washing machines, ovens, etc), smart web search and commerce like Amazon.com, smart stock trading using AI, cool games and toys (remember the chess-playing program Deep Blue that beat the world champion Garry Kasparov in 1997), help desks, friendly avatars, etc. Bill Gates once said this:', 'soc'),
(5, 'Computer Science(Computer Graphics and Games)', 'Computer-generated images and videos now permeate our daily life. From the entertainment industry (e.g., movies and video games) to the healthcare industry (e.g., 3D ultrasound imaging); from your computing desktop (e.g., displaying a window) to graphing calculator (e.g., plotting a line), computer graphics algorithms are in action to decide what pixel value to display onto the screen, based on the underlying model of the "world" and the mathematics and science of geometry, light, color, and mechanics.', 'soc'),
(6, 'Computer Science(Computer Security)', 'As computing systems become increasingly interconnected and more data are available online, the job of securing computer systems and protecting data becomes increasingly challenging. Computer security is growing into the cornerstone of almost every industry, which heavily relies on networked computing systems for communication and management.', 'soc'),
(7, 'Computer Science(Database Systems)', 'Database programming, design, management and administration are among the most promising specialties in an uncertain job market in times of challenges for the economy. The demand for computer scientists and engineers specialised in the database field is high and growing.', 'soc'),
(8, 'Computer Science(Multimedia Information Retrieval)', 'With the proliferation of text and multimedia information, users are now able to find answers to almost any questions on the Web. However, they are often bewildered by the huge amount of information available to them. Information retrieval (IR) involves the processing and analysis of such unstructured information in order to return the most relevant set of information in answer to user''s queries. In the early days, IR deals only with text and the associated metadata, and successful text-based search engines have been developed and routinely used, such as Google, Yahoo and Bing. Recently more media contents are being shared on the Web such as the images in Flickr and video in Youtube. For effective retrieval of such contents, IR needs to be extended to deal with audio visual contents. As the size of information grows, users are also looking for systems that can provide concise and precise answers to their information needs, and question-answering (QA) is naturally evolved to address this needs. With the widespread use of mobile devices and sensors, we are looking into a future world where huge amount of interconnected information is available, often in real time. As the needs for information evolves, more advanced techniques are needed to analyse text, images and videos. Thus the field cover text processing, natural language processing, multimedia content analysis and retrieval, question-answering, as well as location and live search. SOC faculty members are among world leaders in multimedia information retrieval, and we are researching into next generation of live media search.', 'soc'),
(9, 'Computer Science(Interactive Media)', '(applicable to cohorts admitted before AY2015-16 only)', 'soc'),
(10, 'Computer Science(Networking and Distributed Systems)', 'The Internet has become an indispensable part of modern life. Whether we are checking the latest news, communicating with friends, or entertaining ourselves with musics and videos, we cannot get away from accessing and interacting with information and applications over the Internet. The Internet has grown explosively into a network interconnection billions of devices.\r\n\r\nThe Networking and Distributed Systems focus area focuses on how such a large scale interconnection of computing devices can be achieved and how these computing devices can work together, often in a distributed manner, to perform computations and disseminate information from one device to another.', 'soc'),
(11, 'Computer Science(Parallel Computing)', 'Microprocessors have enjoyed a period of tremendous advance in terms of speed and design. The famous Moore''s Law: "Transistor density doubles in 18 months" results in a similar improvement in computing speed. The exponential growth of computing speed is almost unmatched by any other techonology in human history. Consider this: "Computing power increase by an order of magnitude (10x) every _five_ years"! and the strange fact that "Today''s microprocessors sitting in everyone''s desktops are far more powerful than the most powerful computing 10 years ago."', 'soc'),
(12, 'Computer Science(Programming Languages)', 'Programming languages are artificial languages designed to make it easy to create "programs" which are the concrete algorithms which the computer executes.', 'soc'),
(13, 'Computer Science(Software Engineering)', 'While programming languages is about how one instructs the computer, software engineering is about methods of designing programs. It is about the craft and science of programming so that the resulting software is correct and reliable. Software engineering is concerned about developing and maintaining software in a systematic, disciplined, and economic way, in short, an engineering approach to the building and maintenance of software. If we consider the complexity of all human created artifacts, for example, one of the greatest technological achievements of the 20th century is considered to be the Apollo 11 Mission to the moon, the complexity of modern day software such as Microsoft Windows dwarfs that of Apollo 11. The more complex a system is, the greater its potential to fail. Software engineering plays a key role to ensure that such software systems are designed to be robust against failure. Given the prevalence of software in all aspects of modern life, from mobile phones to flight control systems to electricity grid control, the practice of software engineering practices have an important impact on our daily life.', 'soc'),
(14, 'Computer Science(Visual Computing)', '(applicable to cohorts admitted before AY2015-16 only)\r\n\r\nVisual Computing encompasses many aspects of images, videos and graphics, including their creation, manipulation, storage, distribution, analysis, and search. Humans are visual creatures; a large part of our brains is devoted to processing images that our eyes (sensors) pick up. Visual Computing is thus important because it amplifies and aids our natural human ability to understand images and to communicate with them. When you use a digital camera, or watch a YouTube video, or edit your picture with Photoshop, you are reaping the fruits of Visual Computing. When you are immersed in a computer game, or mesmerized by a movie special effect, you are being entertained by Visual Computing. In fact, this field will continue to gain prominence in our daily lives, not only because we produce a tremendous amount of images, videos and graphics everyday, but also because the visual medium is a natural way for humans to interact with other humans, and with computers. SoC offers more than ten modules in Visual Computing. SoC faculty members are among the world leaders in Visual Computing, and their research has generated commercial spin-offs and patents.', 'soc'),
(15, 'Information Security', 'The Bachelor of Computing in Information Security aims to:\r\n\r\nTo provide a broad-based, inter-disciplinary information security undergraduate programme within NUS.\r\n\r\nTo contribute to the national focus on growing the pool of cyber security professionals in Singapore.\r\n\r\nTo produce graduates who are able to understand information security issues and practices from both technical and organisational points of view.\r\n', 'soc'),
(16, 'Information System', 'The four-year IS programme provides a stimulating education that equips students with the ability to integrate infocomm technology fundamentals with domain expertise to develop innovative solutions for organisations. Through projects and case studies that are aligned with industry best practices, students will develop an in-depth understanding of the strategic exploitation of infocomm technology in emerging organisational forms. Students become proficient in the design and development of infocomm solutions and the management of infocomm projects. Such skills are vital in helping students develop careers that are being emphasised in the iN2015 plan, such as techno-strategist, solution architect, and infocomm project manager.\r\n\r\nStudents can also take a specialisation in Electronic Commerce.', 'soc');

-- --------------------------------------------------------

--
-- Table structure for table `modules`
--

CREATE TABLE `modules` (
  `code` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `credit` int(11) NOT NULL,
  `prerequisite` text,
  `preclusion` text,
  `corequisite` text,
  `semAvailability` varchar(255) NOT NULL,
  `course` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `modules`
--

INSERT INTO `modules` (`code`, `title`, `credit`, `prerequisite`, `preclusion`, `corequisite`, `semAvailability`, `course`, `type`) VALUES
('ACC1002X', 'Financial Accounting', 4, NULL, 'CS1304 or EC3212 or BK1003 or BZ1002 or BH1002 or BZ1002E or BH1002E or FNA1002E or FNA1002X', NULL, '1, 2', 'BZA /ISYS', 'C'),
('BSP4513', 'Econometrics: Theory And Practical Business Application', 4, 'BSP1005 or IS3240', 'EC3304', NULL, '1, 2', 'BZA', 'PE'),
('BT1101', 'Introduction to Business Analytics', 4, NULL, 'DSC1007 or DSC1007X', NULL, '1', 'BZA', 'C'),
('BT2101', 'IT and Decision Making', 4, '(MA1521 or MA1102R) and CS1010S and (IS1112 or BT2102)', NULL, NULL, '1', 'BZA', 'C'),
('BT2102', 'Data Management and Visualisation', 4, 'CS1010 or CS1010E or CS1010FC or CS1010S or CS1010X or CS1101 or CS1101C or CS1101S and BT1101', NULL, NULL, '2', 'BZA', 'C'),
('BT3101', 'Business Analytics Capstone Project', 4, 'Completed 64 MCs and ST3131 and IS2101', NULL, NULL, '1', 'BZA', 'C'),
('BT3102', 'Computational Methods for Business Analytics', 4, 'Completed 64 MCs and CS1020 and (MA1521 or MA1102R)', NULL, NULL, '1', 'BZA', 'C'),
('BT3103', 'Application Systems Development for Business Analytics', 4, 'BT2102', NULL, NULL, '1', 'BZA', 'C'),
('BT4211', 'Data-Driven Marketing', 4, 'Completed 80 MCs and ST3131', NULL, NULL, '2', 'BZA', 'PE'),
('BT4212', 'Search Engine Optimization and Analytics', 4, 'Completed 80 MCs', NULL, NULL, '1', 'BZA', 'PE'),
('BT4221', 'Big Data Techniques and Technologies', 4, 'Complete 80 MCs and (IS1112 or BT2102) and ST3131', NULL, NULL, '1', 'BZA', 'PE'),
('BT4222', 'Mining Web Data for Business Insights', 4, 'Completed 80 MCs and CS1020', NULL, NULL, '2', 'BZA', 'PE'),
('CG1001', 'Introduction to Computer Engineering', 2, NULL, NULL, NULL, '1', 'CEG', 'C'),
('CG1108', 'Electrical Engineering', 4, 'H1 Physics or H2 Physics or `A` Level Physics or PC1222', 'EG1108 or EE1002', NULL, '2', 'CEG', 'C'),
('CG2023', 'Signals and Systems', 4, 'MA1506', 'EE2009 and EE2010 and EE2023', NULL, '1, 2', 'CEG', 'C'),
('CG2271', 'Real-Time Operating Systems', 4, 'CS1020 or CS1020E', 'CS2106', NULL, '1, 2', 'CEG', 'C'),
('CG3002', 'Embedded Systems Design Project', 6, 'EE2024 and CG2271 and CS2103', 'EE3032 or EE3208', NULL, '1', 'CEG', 'C'),
('CG3207', 'Computer Architecture', 4, 'CG2007 or EE2024', 'EE3207', NULL, '1', 'CEG', 'C'),
('CG4001', 'B. Eng. Dissertation', 12, 'Level 4', 'EE4001 or CP4101', NULL, '1, 2, 4', 'CEG', 'C'),
('CM1101', 'PRINCIPLES OF MODERN CHEMISTRY ', 4, NULL, NULL, NULL, '', 'CS(ALL)', 'PE'),
('CM1111', 'Inorganic Chemistry 1', 4, '`A` level or H2 pass in Chemistry or equivalent', NULL, NULL, '1', 'CS(ALL)', 'PE'),
('CM1121', 'Organic Chemistry 1', 4, '`A` level or H2 pass in Chemistry or equivalent or CM1417/CM1417X', 'CM1501 or CM1503 or CM1401', NULL, '2', 'CS(ALL)', 'PE'),
('CM1131', 'Physical Chemistry 1', 4, '`A` level or H2 pass in Chemistry or equivalent', NULL, NULL, '1', 'CS(ALL)', 'PE'),
('CM1161', 'PRINCIPLES OF CHEMICAL PROCESS I', 4, NULL, NULL, NULL, '', 'CS(ALL)', 'PE'),
('CM1191', 'Experiments in Chemistry 1', 4, 'H2/ `A`level Chemistry or its equivalent or by permission', NULL, NULL, '1, 2', 'CS(ALL)', 'PE'),
('CM1401', 'Chemistry for Life Sciences', 4, 'GCE `A` level or H2 pass in Chemistry or equivalent or CM1417 or CM1417X', NULL, NULL, '2', 'CS(ALL)', 'PE'),
('CM1402', 'General Chemistry', 4, 'GCE `A` level or H2 pass in Chemistry or equivalent or CM1417 or CM1417X', 'CM1401', NULL, '2', 'CS(ALL)', 'PE'),
('CM1417', 'Fundamentals of Chemistry', 4, '`O` Level pass in Chemistry or equivalent', '`A` level or H2 Chemistry or equivalent or CM1417X', NULL, '1', 'CS(ALL)', 'PE'),
('CM1501', 'Organic Chemistry for Engineers', 4, '`A` level or H2 pass in Chemistry, or equivalent or CM1417 or CM1417X', 'CM1121 or CM1503 or CM1401', NULL, '1', 'CS(ALL)', 'PE'),
('CM1502', 'General and Physical Chemistry for Engineers', 4, '`A` level or H2 pass in Chemistry or equivalent or CM1417 or CM1417X', 'Chemistry majors or CM1502FC or CM1502X', NULL, '2', 'CS(ALL)', 'PE'),
('CP3880', 'Advanced Technology Attachment Programme', 12, '(IS2101 or CS2101 or their equivalents) and (CS2103/CS2103T or IS2103 or IS2150 or BT2101)', 'EG3601', NULL, '1, 2', 'CEG', 'C'),
('CP3880', 'Advanced Technology Attachment Programme', 12, '(IS2101 or CS2101 or their equivalents) and (CS2103/CS2103T or IS2103 or IS2150 or BT2101)', 'EG3601', NULL, '1, 2', 'CS(ALL)/ ISEC', 'PE'),
('CP4101', 'B.Comp. Dissertation', 12, 'Attain at least 70% of the MCs requirement for the respective degree', 'CS4101', NULL, '1, 2', 'CS(ALL)/ ISEC/ ISYS', 'PE'),
('CS1010', 'Programming Methodology', 4, NULL, 'CG1101 or CS1010E or CS1010FC or CS1010S or CS1101 or CS1101C or CS1101S. Engineering and Science students who require this module for their majors/minors are not allowed to read it as ULR-Breadth.', NULL, '1, 2', 'CEG/ CS(ALL)/ ISEC', 'C'),
('CS1010J', 'Programming Methodology', 4, NULL, 'CG1101 or CS1010E or CS1010FC or CS1010S or CS1101 or CS1101C or CS1101S', NULL, '1', 'ISYS', 'C'),
('CS1010S', 'Programming Methodology', 4, NULL, 'CG1101 or CS1010 or CS1010E or CS1010FC or CS1101 or CS1101C or CS1101S', NULL, '1, 2', 'BZA', 'C'),
('CS1020', 'Data Structures and Algorithms I', 4, 'CS1010 or CS1010J or CS1010S', 'CG1102 or CG1103 or CS1020E or CS1102 or CS1102C or CS1102S or CS2020', NULL, '1, 2, 4', 'BZA/ CS(ALL)/ ISEC', 'PE'),
('CS1020', 'Data Structures and Algorithms I', 4, 'CS1010 or CS1010J or CS1010S', 'CG1102 or CG1103 or CS1020E or CS1102 or CS1102C or CS1102S or CS2020', NULL, '1, 2, 4', 'CEG/ ISYS', 'C'),
('CS1101S', 'Programming Methodology', 5, '`A` level Mathematics or H2 Mathematics or MA1301 or MA1301FC or MA1301X', 'CG1101 or CS1010 or CS1010E or CS1010FC or CS1010S or CS1010X or CS1101 or CS1101C or Engineering students', NULL, '1', '', ''),
('CS1231', 'Discrete Structures', 4, '`A` level Mathematics or H2 Mathematics or MA1301 or MA1301FC or MA1301X', 'MA1100', NULL, '1, 2', 'CEG/ CS(ALL)/ ISEC/ ISYS', 'C'),
('CS2010', 'Data Structures and Algorithms II', 4, 'CS1020 or CS1020E or CG1103 ', 'CG1102 or CS1102 or CS1102C or CS1102S or CS2020', NULL, '1, 2, 4', 'BZA/ CS(ALL)/ ISEC', 'PE'),
('CS2020', 'Data Structures and Algorithms Accelerated', 6, 'Obtain a grade of at least A- in either CS1010 or CS1101S or CS1010S or CS1010J or CS1010FC or their equivalents', 'CG1102 or CG1103 or CS1020 or CS1020E or CS2010 or CS1102 or CS1102C or CS1102S', NULL, '2', 'BZA/ CS(ALL)/ ISEC', 'PE'),
('CS2100', 'Computer Organisation', 4, 'CS1010 or CS1010J or CS1010S', 'CS1104 or Students from Department of ECE', NULL, '1, 2', 'CS(ALL)/ ISEC/ ISYS', 'C'),
('CS2101', 'Effective Communication for Computing Professionals', 4, 'Students have to complete ES1000 or ES1102 (if required to take the modules) before reading this module', 'CS2103 or IS2101 or its equivalent, or ES2002 or ES2007S or ES2007D or CG1413 or EG1413 or ES1601', 'CS2103T', '1, 2', 'CEG/ CS(ALL)/ ISEC', 'C'),
('CS2102', 'Database Systems', 4, '(CS1020 or CS2020) and (CS1231 or MA1100)', 'CS2102S or IT2002', NULL, '1, 2', 'CS(DS)/ ISEC/ ISYS', 'C'),
('CS2103', 'Software Engineering', 4, '(CS1020 or CS2020)', 'Science students majoring in Computational Finance are not allowed to read it as CFM/Breadth. EEE and CPE students can only take this module as a technical elective to satisfy the program requirements or UEM but not CFM/ULR-Breadth', NULL, '1, 2', 'CS', 'PE'),
('CS2103T', 'Software Engineering', 4, 'For SoC students only. CS1020 or CS2020.', 'CS2103 or IS2101 or its equivalent', 'CS2101', '1, 2', 'CEG/ ISEC/ CS(ALL)', 'C'),
('CS2104', 'Programming Language Concepts', 4, 'CS1020 or CS2020', NULL, NULL, '1', 'CS(PL)', 'C'),
('CS2105', 'Introduction to Computer Networks', 4, 'CS1020 or CS2020', 'IT2001 or EE3204 or EE3204E or EE4210. CEG, CPE and EEE students are not allowed to take this module.', NULL, '1, 2', 'CS/ ISEC/ ISYS/ CS(NDS)', 'C'),
('CS2106', 'Introduction to Operating Systems', 4, 'CS2100 or EE2007 or EE2024', 'CG2271 or EE4214. CEG students are not allowed to take this module.', NULL, '1, 2', 'CS/ ISEC', 'C'),
('CS2106', 'Introduction to Operating Systems', 4, 'CS2100 or EE2007 or EE2024', 'CG2271 or EE4214. CEG students are not allowed to take this module.', NULL, '1, 2', 'ISYS', 'PE'),
('CS2107', 'Introduction to Information Security', 4, 'CS1010 or CS1010J or CS1010S or CS1101S or its equivalent', NULL, NULL, '1, 2', 'CS(CS)', 'C'),
('CS2107', 'Introduction to Information Security', 4, 'CS1010 or CS1010J or CS1010S or CS1101S or its equivalent', NULL, NULL, '1, 2', 'ISEC', 'C'),
('CS2108', 'Introduction to Media Computing', 4, 'CS1020 or CS2020', 'CS3246', NULL, '1', 'CS(MIR)', 'C'),
('CS3103', 'Computer Networks Practice', 4, 'CS2105 or EE3204 or EE3204E', 'EE4210', NULL, '1', 'CS(NDS)', 'C'),
('CS3201', 'Software Engineering Project I', 4, 'CS2103 or CS2103T or its equivalent', 'CS3215', 'CS3202', '1, 2', 'CS(ALL)', 'PE'),
('CS3202', 'Software Engineering Project II', 4, 'CS2103 or CS2103T or its equivalent', 'CS3215', 'CS3201', '1, 2', 'CS(ALL)', 'PE'),
('CS3205', 'Information Security Capstone Project', 8, 'CS3235', NULL, NULL, '1', 'ISEC', 'C'),
('CS3210', 'Parallel Computing', 4, 'CS2100 or CG2007 or EE2024', NULL, NULL, '1', 'CS(PC)', 'C'),
('CS3211', 'Parallel and Concurrent Programming', 4, 'CS2106 or CG2271', NULL, NULL, '2', 'CS(PC)/ CS(PL)', 'C'),
('CS3213', 'Software Systems Design', 4, NULL, NULL, NULL, '', 'CS(SE)', 'C'),
('CS3216', 'Software Development on Evolving Platforms', 5, 'CS2103/CS2103T or with special approval from instructor. Students will submit personal statements to apply for a place in the course instead of bidding through the CORS system.', NULL, NULL, '1', 'CS(ALL)/ CS(SE)', 'PE'),
('CS3217', 'Software Engineering on Modern Application Platforms', 5, 'CS2103 or with special approval from instructor. Students will submit personal statements to apply for a place in the course instead of bidding through the CORS system.', NULL, NULL, '2', 'CS(ALL)/ CS(SE)', 'PE'),
('CS3218', 'Multimodal Processing in Mobile Platforms', 4, '(MA1521 or MA1505 or MA1102R) and (MA1101R or MA1506) and (CS2108 or EE3206)', NULL, NULL, '2', 'CS(CGG)/ CS(IM)/ CS(VC)', 'PE'),
('CS3219', 'Software Engineering Principles and Patterns', 4, 'CS2103/CS2103T', 'CS3213', NULL, '1', 'CS(SE)', 'C'),
('CS3221', 'Operating Systems Design and Pragmatics', 4, NULL, NULL, NULL, '', 'CS(CS)', 'PE'),
('CS3223', 'Database Systems Implementation', 4, '(CS2010 or CS2020) and (CS2102 or CS2102S)', NULL, NULL, '2', 'CS(DS)', 'C'),
('CS3226', 'Web Programming and Applications', 4, 'CS1020 or CS2020', 'CP3101B', NULL, '2', 'CS(SE)', 'PE'),
('CS3230', 'Design and Analysis of Algorithms', 4, '(CS2010 or CS2020) and (CS1231 or MA1100)', 'EEE and CPE students can only take this module as a technical elective to satisfy the program requirements or UEM but not CFM/ULR-Breadth.', NULL, '1, 2', 'CS(ALL)', 'C'),
('CS3233', 'Competitive Programming', 4, 'At least grade A- in (CS2010 or CS2020) or special permission.', NULL, NULL, '2', 'CS(AT)', 'PE'),
('CS3234', 'Logic and Formal Systems', 4, 'CS1231 or MA1100; Programming experience is preferred.', NULL, NULL, '2', 'CS(PL)/ CS(SE)', 'PE'),
('CS3235', 'Computer Security', 4, '(CS2105 or  EE3204) and (CS2106 or CG2271 ) and CS2107', NULL, NULL, '1, 2', 'ISEC/ CS(CS)', 'C'),
('CS3235', 'Computer Security', 4, '(CS2105 or  EE3204) and (CS2106 or CG2271 ) and CS2107', NULL, NULL, '1, 2', 'ISYS', 'PE'),
('CS3236', 'Introduction to Information Theory', 4, 'MA1521 and ST2334 and their equivalents', NULL, NULL, '2', 'CS(AT)', 'C'),
('CS3240', 'Interaction Design', 4, 'SOC students: CS1020 or CS2020; Other students: NM2217 or NM3209 or the prerequisites for SoC students', NULL, NULL, '2', 'CS(IM)', 'C'),
('CS3240', 'Interaction Design', 4, 'SOC students: CS1020 or CS2020; Other students: NM2217 or NM3209 or the prerequisites for SoC students', NULL, NULL, '2', 'ISYS/ CS(CGG)', 'PE'),
('CS3241', 'Computer Graphics', 4, 'CS1020 or CS2020', 'EEE and CPE students can only take this module as a technical elective to satisfy the program requirements or UEM but not CFM/ULR-Breadth.', NULL, '1, 2', 'CS(CGG)/ CS(IM)/ CS(VC)', 'C'),
('CS3242', '3D Modeling and Animation', 4, 'CS3241 and PC1221 and MA1521 and MA1101R', 'CS4342', NULL, '2', 'CS(CGG)/ CS(IM)/ CS(VC)', 'C'),
('CS3243', 'Introduction to Artificial Intelligence', 4, '(CS2010 or CS2020) and (CS1231 or MA1100)', 'EEE and CPE students can only take this module as a technical elective to satisfy the program requirements or UEM but not CFM/ULR-Breadth.', NULL, '2', 'CS(AI)', 'C'),
('CS3244', 'Machine Learning', 4, '(CS2010 or CS2020) and (ST1232 or ST2131 or ST2132 or ST2334)and (MA1101R or MA1311 or MA1506) and (MA1102R or MA1505 or MA1521)', NULL, NULL, '1', 'BZA', 'PE'),
('CS3244', 'Machine Learning', 4, '(CS2010 or CS2020) and (ST1232 or ST2131 or ST2132 or ST2334)and (MA1101R or MA1311 or MA1506) and (MA1102R or MA1505 or MA1521)', NULL, NULL, '1', 'CS(AI)', 'C'),
('CS3245', 'Information Retrieval', 4, 'CS2010 or CS2020', NULL, NULL, '2', 'CS(MIR)', 'C'),
('CS3247', 'Game Development', 4, 'CS3241 and PC1221', 'CS4213', NULL, '2', 'CS(CGG)/ CS(IM)', 'C'),
('CS3249', 'User Interface Development', 4, 'CS2103 or CS2103T', NULL, NULL, '2', 'CS(CGG)', 'PE'),
('CS3249', 'User Interface Development', 4, 'CS2103 or CS2103T', NULL, NULL, '2', 'CS(IM)', 'C'),
('CS3281', 'Thematic Systems Project I', 4, 'CS2103 & passed at least one primary module in a CS focus area. Student selection process will be enforced.', NULL, NULL, '2', 'CS(ALL)', 'PE'),
('CS3282', 'Thematic Systems Project II', 4, 'CS3281 & passed at least two primary modules in a CS focus area. Student selection process will be enforced.', NULL, NULL, '2', 'CS(ALL)', 'PE'),
('CS3283', 'Media Technology Project I', 4, 'SoC students: (CS2103 or CS2103T) and (CS3218 or CS3240 or CS3241 or CS3242 or CS3245 or CS3246 or CS3247 or CS3249 or module approved by Department of Computer Science); Other students: NM3216 or NM3221 or NM3226 or NM3227 or NM3231 or the prerequisites for SoC students', 'CS4201 or CS4202 or CS4203 or CS4204', NULL, '2', 'CS(ALL)', 'PE'),
('CS3284', 'Media Technology Project II', 4, 'CS3283', 'CS4201 or CS4202 or CS4203 or CS4204', NULL, '2', 'CS(ALL)', 'PE'),
('CS3343', 'Digital Media Production', 4, NULL, NULL, NULL, '', 'CS(CGG)/ CS(IM)/ CS(VC)', 'PE'),
('CS3882', 'Breakthrough Ideas for Digital Markets', 4, NULL, NULL, NULL, '', 'CS(ALL)/ CS(SE)', 'PE'),
('CS4211', 'Formal Methods for Software Engineering', 4, NULL, NULL, NULL, '', 'CS(SE)', 'C'),
('CS4212', 'Compiler Design', 4, 'CS2104', NULL, NULL, '1', 'CS(PC)', 'C'),
('CS4215', 'Programming Language Implementation', 4, '(CS2010 or CS2020) and CS2104 ', NULL, NULL, '2', 'CS', 'PE'),
('CS4215', 'Programming Language Implementation', 4, '(CS2010 or CS2020) and CS2104 ', NULL, NULL, '2', 'CS(PC)', 'C'),
('CS4216', 'Constraint Logic Programming', 4, NULL, NULL, NULL, '', 'CS/ CS(AI)/ CS(PL)', 'PE'),
('CS4217', 'Software Development Technologies', 4, NULL, NULL, NULL, '', 'CS/ CS(SE)', 'PE'),
('CS4218', 'Software Testing', 4, 'CS3219', NULL, NULL, '2', 'CS', 'PE'),
('CS4218', 'Software Testing', 4, 'CS3219', NULL, NULL, '2', 'CS(SE)', 'C'),
('CS4220', 'Knowledge Discovery Methods in Bioinformatics', 4, 'CS2220 or LSM2104', NULL, NULL, '2', 'CS/ CS(AI)/ CS(DS)', 'PE'),
('CS4221', 'Database Applications Design and Tuning', 4, 'CS3223', NULL, NULL, '2', 'CS(DS)', 'C'),
('CS4222', 'Wireless Networking', 4, '(CS2105 or EE3204 or EE3204E) and (ST2334 or ST2131)', NULL, NULL, '2', 'CS(NDS)', 'C'),
('CS4223', 'Multi-core Architectures', 4, '(CS2106 or CG2271) and (CS3210 or CS3220 or CG3207)', NULL, NULL, '1', 'CS(PC)', 'C'),
('CS4224', 'Distributed Databases', 4, 'CS3223', NULL, NULL, '1', 'CS(DS)', 'C'),
('CS4225', 'Massive Data Processing Techniques in Data Science', 4, 'CS3223', NULL, NULL, '2', 'CS(DS)', 'PE'),
('CS4226', 'Internet Architecture', 4, '(CS2105 or EE3204) and (ST2334 or ST2131)', NULL, NULL, '1', 'CS(NDS)', 'C'),
('CS4231', 'Parallel and Distributed Algorithms', 4, 'CS3230 or CS3210', NULL, NULL, '2', 'CS(AT)/ CS(PC)', 'C'),
('CS4231', 'Parallel and Distributed Algorithms', 4, 'CS3230 or CS3210', NULL, NULL, '2', 'CS(NDS)', 'PE'),
('CS4232', 'Theory of Computation', 4, 'CS1231 or CS1231S or any level-2 MA module', NULL, NULL, '1', 'CS(AT)', 'C'),
('CS4234', 'Optimisation Algorithms', 4, 'MA1101R and CS3230 ', NULL, NULL, '1', 'CS(AT)', 'C'),
('CS4236', 'Cryptography Theory and Practice', 4, 'CS1231 and (CS2010 or CS2020) and CS2107 ', NULL, NULL, '1', 'CS(CS)', 'C'),
('CS4236', 'Cryptography Theory and Practice', 4, 'CS1231 and (CS2010 or CS2020) and CS2107 ', NULL, NULL, '1', 'ISEC', 'PE'),
('CS4237', 'Systems Modelling and Simulation', 4, NULL, NULL, NULL, '', 'CS(PC)', 'PE'),
('CS4238', 'Computer Security Practice', 4, 'CS3235', NULL, NULL, '2', 'CS(CS)', 'C'),
('CS4238', 'Computer Security Practice', 4, 'CS3235', NULL, NULL, '2', 'ISEC', 'PE'),
('CS4239', 'Software Security', 4, 'CS3235 and (CS2103T or CS2103)', NULL, NULL, '1', 'ISEC/ CS(CS)', 'PE'),
('CS4242', 'Social Media Computing', 4, 'CS2108 and CS3245', NULL, NULL, '2', 'CS(MIR)', 'C'),
('CS4243', 'Computer Vision and Pattern Recognition', 4, '(CS1020 or CS2020) and (MA1101R or MA1506) and (MA1102R or MA1505C or MA1505 or MA1521) and (ST1232 or ST2131 or ST2334)', NULL, NULL, '1', 'CS(VC)', 'C'),
('CS4243', 'Computer Vision and Pattern Recognition', 4, '(CS1020 or CS2020) and (MA1101R or MA1506) and (MA1102R or MA1505C or MA1505 or MA1521) and (ST1232 or ST2131 or ST2334)', NULL, NULL, '1', 'CS/ CS(CGG)/ CS(IM)', 'PE'),
('CS4244', 'Knowledge-Based Systems', 4, 'CS3243', NULL, NULL, '2', 'CS', 'PE'),
('CS4244', 'Knowledge-Based Systems', 4, 'CS3243', NULL, NULL, '2', 'CS(AI)', 'C'),
('CS4246', 'AI Planning and Decision Making', 4, '(MA2216 or ST2131 or ST2334) and CS3243', NULL, NULL, '1', 'CS', 'PE'),
('CS4246', 'AI Planning and Decision Making', 4, '(MA2216 or ST2131 or ST2334) and CS3243', NULL, NULL, '1', 'CS(AI)', 'C'),
('CS4247', 'Graphics Rendering Techniques', 4, 'CS3241', NULL, NULL, '2', 'CS(CGG)/ CS(VC)', 'C'),
('CS4247', 'Graphics Rendering Techniques', 4, 'CS3241', NULL, NULL, '2', 'CS/ CS(IM)', 'PE'),
('CS4248', 'Natural Language Processing', 4, '(CS3243 or CS3245) and (ST1232 or ST2131 or ST2334)', NULL, NULL, '1', 'CS(AI)', 'PE'),
('CS4248', 'Natural Language Processing', 4, '(CS3243 or CS3245) and (ST1232 or ST2131 or ST2334)', NULL, NULL, '1', 'CS(MIR)', 'C'),
('CS4249', 'Phenomena and Theories of Human-Computer Interaction', 4, 'CS3240 or NM2213 or NM2216', NULL, NULL, '1', 'CS(CGG)', 'PE'),
('CS4249', 'Phenomena and Theories of Human-Computer Interaction', 4, 'CS3240 or NM2213 or NM2216', NULL, NULL, '1', 'CS(IM)', 'C'),
('CS4271', 'Critical Systems and Their Verification', 4, NULL, NULL, NULL, '', 'CS(PC)/ CS(SE)', 'PE'),
('CS4274', 'Mobile and Multimedia Networking', 4, NULL, NULL, NULL, '', 'CS(NDS)', 'C'),
('CS4340', 'Digital Special Effects', 4, NULL, NULL, NULL, '', 'CS(CGG)/ CS(IM)/ CS(VC)', 'PE'),
('CS4344', 'Network and Mobile Gaming', 4, NULL, NULL, NULL, '', 'CS(CGG)/ CS(NDS)', 'PE'),
('CS4344', 'Network and Mobile Gaming', 4, NULL, NULL, NULL, '', 'CS(IM)', 'C'),
('CS4345', 'General-Purpose Computation on GPU', 4, 'CS3241', NULL, NULL, '1', 'CS(CGG)/ CS(PC)/ CS(VC)', 'PE'),
('CS4347', 'Sound and Music Computing', 4, '(MA1521 or MA1505 or MA1102R) and (MA1101R or MA1506) and CS2108', NULL, NULL, '2', 'CS(IM)', 'C'),
('CS4347', 'Sound and Music Computing', 4, '(MA1521 or MA1505 or MA1102R) and (MA1101R or MA1506) and CS2108', NULL, NULL, '2', 'CS(MIR)', 'PE'),
('CS4350', 'Game Development Project', 4, 'CS3247. Priority is given to students who have not completed game development projects in CS3283 + CS3284.', 'CS4203 or CS4204', NULL, '1', 'CS(CGG)/ CS(IM)', 'C'),
('CS4880', 'Digital Entrepreneurship', 4, NULL, NULL, NULL, '', 'ISYS', 'PE'),
('CS5205', 'Foundation in Programming Languages', 4, NULL, NULL, NULL, '', 'CS(PL)', 'PE'),
('CS5207', 'Foundation in Operating Systems', 4, NULL, NULL, NULL, '', 'CS(PC)', 'PE'),
('CS5209', 'Foundation in Logic & AI', 4, NULL, NULL, NULL, '', 'CS(AI)', 'PE'),
('CS5214', 'Design of Optimising Compilers', 4, NULL, NULL, NULL, '', 'CS(PL)', 'PE'),
('CS5215', 'Constrained Programming', 4, NULL, NULL, NULL, '', 'CS(AI)/ CS(PL)', 'PE'),
('CS5218', 'Principles of Program Analysis', 4, 'CS4212 or CS4215', NULL, NULL, '2', 'CS(PL)', 'PE'),
('CS5219', 'Automatic Software Validation', 4, 'CS2104', NULL, NULL, '2', 'CS(SE)', 'PE'),
('CS5222', 'Advanced Computer Architecture', 4, NULL, NULL, NULL, '', 'CS(PC)', 'PE'),
('CS5223', 'Distributed Systems', 4, 'CS3211', NULL, NULL, '1', 'CS(NDS)/ CS(PC)', 'PE'),
('CS5226', 'Database Tuning', 4, NULL, NULL, NULL, '', 'CS/ CS(DS)', 'PE'),
('CS5228', 'Knowledge Discovery and Data Mining', 4, 'CS2102 and (ST1232 or ST2131 or ST2334) and CS3243', NULL, NULL, '1', 'CS/ CS(AI)/ CS(DS)', 'PE'),
('CS5229', 'Advanced Computer Networks', 4, 'CS4226 or EE4210', NULL, NULL, '1', 'CS(NDS)', 'PE'),
('CS5230', 'Computational Complexity', 4, NULL, NULL, NULL, '', 'CS(AT)', 'PE'),
('CS5231', 'Systems Security', 4, 'CS3235', NULL, NULL, '1', 'ISEC/ CS(CS)', 'PE'),
('CS5232', 'Formal Specification and Design Techniques', 4, '(CS1231 or MA1100) and CS2103', NULL, NULL, '2', 'CS(PL)/ CS(SE)', 'PE'),
('CS5234', 'Combinatorial and Graph Algorithms', 4, 'CS3230', 'CS4234', NULL, '1', 'CS(AT)', 'PE'),
('CS5237', 'Computational Geometry and Applications', 4, NULL, NULL, NULL, '', 'CS(AT)/ CS(CGG)/ CS(VC)', 'PE'),
('CS5238', 'Advanced Combinatorial Methods in Bioinformatics', 4, 'CS3230', NULL, NULL, '1', 'CS(AT)', 'PE'),
('CS5239', 'Computer System Performance Analysis', 4, 'CS1020 or CS2020', NULL, NULL, '1', 'CS(PC)', 'PE'),
('CS5240', 'Theoretical Foundations in MultiMedia', 4, '(CS1020 or CS2020) and (MA1102R or MA1505 or MA1505C or MA1521) and (MA1101R or MA1506) and (ST1232 or ST2131 or ST2334)', NULL, NULL, '1', 'CS(CGG)/ CS(VC)', 'PE'),
('CS5241', 'Speech Processing', 4, NULL, NULL, NULL, '', 'CS(MIR)/ CS(IM)', 'PE'),
('CS5246', 'Text Processing on the Web', 4, NULL, NULL, NULL, '', 'CS(MIR)', 'PE'),
('CS5247', 'Motion Planning and Applications', 4, NULL, NULL, NULL, '', 'CS(AI)', 'PE'),
('CS5248', 'Systems Support for Continuous Media', 4, 'CS2106 and CS4226', NULL, NULL, '1', 'CS(NDS)', 'PE'),
('CS5272', 'Embedded Software Design', 4, NULL, NULL, NULL, '', 'CS(SE)', 'PE'),
('CS5321', 'Network Security', 4, 'CS3235', NULL, NULL, '2', 'ISEC/ CS(CS)/ CS(NDS)', 'PE'),
('CS5322', 'Database Security', 4, NULL, NULL, NULL, '', 'ISEC/ CS(CS)/ CS(DS)', 'PE'),
('CS5331', 'Web Security', 4, 'CS3235', NULL, NULL, '2', 'ISEC/ CS(CS)', 'PE'),
('CS5340', 'Uncertainty Modelling in AI', 4, '(ST1232 or ST2131 or ST2334) and CS3243', NULL, NULL, '1', 'CS(AI)', 'PE'),
('CS5342', 'Multimedia Computing and Applications', 4, NULL, NULL, NULL, '', 'CS(IM)', 'PE'),
('CS6242', 'Digital Libraries', 4, NULL, NULL, NULL, '', 'CS(MIR)', 'PE'),
('CS6243', 'Computational Photography', 4, NULL, NULL, NULL, '', 'CS(VC)', 'PE'),
('DSC3214', 'Introduction To Optimisation', 4, 'DSC1007 or [(MA1101R or MA1311) and (MA1521 or MA1102R)]', 'IE2110', NULL, '1, 2', 'BZA', 'PE'),
('DSC3216', 'Forecasting For Managerial Decisions', 4, 'ST1131A or ST1131 or ST1232 or MA2216 or ST2131 or ST2334 or EE2003 or ME2491', 'BH3216 or BZ3405 or BK3509 or BK3519. All Industrial & Systems Engineering (ISE) students', NULL, '2', 'BZA', 'PE'),
('DSC3224', 'Dynamic Pricing & Revenue Management', 4, 'DSC1007 or IE2110 or DSC3214', NULL, NULL, '2', 'BZA', 'PE'),
('DSC4213', 'Analytical Tools for Consulting', 4, 'DSC1007 or IE2110 or DSC3214', NULL, NULL, '1', 'BZA', 'PE'),
('EC1301', 'Principles of Economics', 4, NULL, 'EC1101E or BH1005 or BSP1005 or USE2301. All BBA, BAC, BBA(Hons) and BAC(Hons) students are not allowed to take EC1301.', NULL, '1, 2', 'BZA', 'C'),
('EE2020', 'Digital Fundamentals","Department":"Electrical & Computer Engineering', 5, 'EE1002 or CG1108 or EG1108', NULL, 'CS1010E', '1, 2', 'CEG', 'C'),
('EE2021', 'Devices and Circuits', 4, 'EE1002 or EG1108 or CG1108', 'EE2004 or EE2005', NULL, '1, 2', 'CEG', 'C'),
('EE2024', 'Programming for Computer Interfaces', 5, 'EE2020 and CS1010E', NULL, NULL, '1, 2', 'CEG', 'C'),
('EE3031', 'Innovation & Enterprise I', 4, NULL, 'TR3001 or EE3001 or MT4003', NULL, '1, 2', 'CEG', 'C'),
('EE3131C', 'Communication Systems', 4, 'EE2023', 'EE3103', NULL, '1, 2', '', ''),
('EE3204', 'Computer Communication Networks I', 4, NULL, 'CS2105', 'EE2023', '1, 2', 'CEG', 'C'),
('EE3206', 'Intro To Comp Vision & Image Processing', 4, 'EE2023', 'CS4243', NULL, '1', '', ''),
('EE3331C', 'Feedback Control Systems', 4, 'EE2023', 'EE2010', NULL, '1, 2', '', ''),
('EE3407', 'Analog Electronics', 4, 'EE2021', NULL, NULL, '2', '', ''),
('EE3408C', 'Integrated Analog Design', 4, 'EE2005 or EE2021', 'EE3408', NULL, '1', '', ''),
('EE3701', 'Digital Media Technologies', 4, NULL, NULL, NULL, '', '', ''),
('EE3731C', 'Signal Processing Methods', 4, '(EE2012 or ST2334) and EE2023', NULL, NULL, '1', '', ''),
('EE4113', 'Digital Communications & Coding', 4, '(EE2012 or ST2334) and EE3131C', 'EE4102 or EE4103', NULL, '1', '', ''),
('EE4114', 'Optical Communications', 4, NULL, NULL, NULL, '', '', ''),
('EE4210', 'Computer Communication Networks II', 4, 'EE3204 or CS2105', 'CS3103', NULL, '2', '', ''),
('EE4212', 'Computer Vision', 4, 'EE3206 or EE3731C', 'CS4243', NULL, '2', '', ''),
('EE4213', 'Image & Video Processing', 4, NULL, NULL, NULL, '', '', ''),
('EE4214', 'Real-Time Embedded Systems', 4, 'CG2007 or EE2024', NULL, NULL, '2', '', ''),
('EE4218', 'Embedded Hardware System Design', 4, 'EE2020', NULL, NULL, '1', '', ''),
('EE4305', 'Introduction To Fuzzy / Neural Systems', 4, 'EE2023', NULL, NULL, '1', '', ''),
('EE4306', 'Distributed Autonomous Robotic Systems', 4, NULL, NULL, NULL, '', '', ''),
('EE4307', 'Control Systems Design And Simulation', 4, 'EE3331C', NULL, NULL, '2', '', ''),
('EE4415', 'Integrated Digital Design', 4, 'EE2020', NULL, NULL, '2', '', ''),
('EE4505', 'Power Semiconductor Devices & ICs', 4, NULL, NULL, NULL, '', '', ''),
('EE4604', 'Biological Perception in Digital Media', 4, NULL, NULL, NULL, '', '', ''),
('EG2401', 'Engineering Professionalism', 3, 'ES1501A and ES1501B and ES1501C and EG1413/ES1531 and Year 2 status', NULL, NULL, '1, 2', 'CEG', 'C'),
('EG3601', 'Industrial Attachment Programme', 12, NULL, NULL, NULL, '1, 2, 3', 'CEG', 'C'),
('ES2660', 'Communicating in the Information Age', 4, NULL, NULL, NULL, '', 'BZA/ CS(ALL)/ ISEC/ ISYS', 'C'),
('GEM 1', 'General Education Module', 4, NULL, NULL, NULL, '1, 2', '', 'GEM'),
('GEM 2', 'General Education Module', 4, NULL, NULL, NULL, '1, 2', '', 'GEM'),
('GEM 3', 'General Education Module', 4, NULL, NULL, NULL, '1, 2', '', 'GEM'),
('GEM 4', 'General Education Module', 4, NULL, NULL, NULL, '1, 2', '', 'GEM'),
('GEM 5', 'General Education Module', 4, NULL, NULL, NULL, '1, 2', '', 'GEM'),
('HR2002', 'Human Capital in Organizations', 3, 'For Engineering students only', 'HR2001 or HR2101 or HR3111', NULL, '1, 2', 'CEG', 'C'),
('IE2110', 'Operations Research I', 4, '(MA1102R or MA1505 or MA1521) and (MA1101R or MA1311 or MA1506)', 'DSC3214 or MA2215 or MA3236', NULL, '1', 'BZA', 'C'),
('IE3120', 'Manufacturing Logistics', 4, 'IE2100 or DSC3215', NULL, NULL, '1', 'BZA', 'PE'),
('IE4210', 'Operations Research II', 4, 'IE2110', NULL, NULL, '1', 'BZA', 'PE'),
('IER', 'Industrial Experience Requirement', 12, NULL, NULL, NULL, '', '', ''),
('IFS4101', 'Legal Aspects of Information Security', 4, '(CS2107 or IS3230) and passed 80 MCs', NULL, NULL, '2', 'ISEC/ CS(CS)', 'PE'),
('IS1103', 'Computing and Society', 4, NULL, 'CS1105 or CS1105A or IS1103X or IS1103FC', NULL, '1, 2', 'BZA', 'C'),
('IS1103', 'Computing and Society', 4, NULL, 'CS1105 or CS1105A or IS1103X or IS1103FC', NULL, '1, 2', 'CS(ALL)/ ISEC/ ISYS', 'PE'),
('IS1103FC', 'Computing and Society', 4, NULL, 'CS1105 or CS1105A or IS1103 or IS1103X', NULL, '2', 'CS(ALL)/ ISEC', 'PE'),
('IS1103X', 'Computing and Society', 4, NULL, 'CS1105 or CS1105A or IS1103 or IS1103FC', NULL, '2', 'CS(ALL)/ ISEC/ ISYS', 'PE'),
('IS1105', 'Strategic IT Applications', 4, NULL, 'CS2250', NULL, '1, 2', 'BZA/ ISEC/ ISYS', 'C'),
('IS2101', 'Business and Technical Communication', 4, 'Students who are required to read ES1000 or ES1102 must pass it/them before taking IS2101.', 'ES2002 or ES2007D or ES2007S or CS2101 or CG1413 or CS2103T or ES1601', NULL, '1, 2', 'BZA/ ISYS', 'C'),
('IS2102', 'Requirements Analysis and Design', 4, 'CS1010 or CS1010J or CS1010S or CS1101S or its equivalent', NULL, NULL, '1, 2', 'CS(SE)', 'UEM'),
('IS2102', 'Requirements Analysis and Design', 4, 'CS1010 or CS1010J or CS1010S or CS1101S or its equivalent', NULL, NULL, '1, 2', 'ISEC', 'C'),
('IS2103', 'Enterprise Systems Development Concepts', 4, 'CS1020 or CS2020 or CS1102 or CS1102C or CS1102S', 'CS2261', NULL, '1, 2', 'ISEC', 'C'),
('IS2104', 'Software Team Dynamics', 4, 'Completed 40 MCs', NULL, NULL, '1, 2', 'CS', 'PE'),
('IS2104', 'Software Team Dynamics', 4, 'Completed 40 MCs', NULL, NULL, '1, 2', 'CS(SE)', 'UEM'),
('IS2104', 'Software Team Dynamics', 4, 'Completed 40 MCs', NULL, NULL, '1, 2', 'ISEC', 'C'),
('IS3101', 'Management of Information Systems', 4, 'CS2250 or (IS1103 or IS1103FC or IS1103X and IS1105)', 'CS3253', NULL, '1, 2', 'ISEC', 'C'),
('IS3102', 'Enterprise Systems Development Project', 8, '(CS2261 or IS2103) and (CS2301 or IS2101)', 'CS3214', NULL, '1, 2', 'ISEC', 'C'),
('IS3150', 'Digital and New Media Marketing', 4, 'Completed 60 MCs and IS1105 and IS1112', NULL, NULL, '1', 'ISYS', 'PE'),
('IS3220', 'Service Design and Innovation', 4, 'Completed 60 MCs and (IS1103 or IS1103FC) and IS1105', NULL, NULL, '1, 2', 'ISYS', 'PE'),
('IS3221', 'Enterprise Resource Planning Systems', 4, '(IS1103 or IS1103FC or IS1103X) and IS1105', NULL, NULL, '2', 'ISYS', 'PE'),
('IS3222', 'IT and Customer Relationship Management', 4, 'Completed 60 MCs and [CS2250 or (IS1103 and IS1105)]', 'CS4266', NULL, '2', 'ISYS', 'PE'),
('IS3223', 'IT and Supply Chain Management', 4, 'Completed 60 MCs and [CS2250 or (IS1103 and IS1105)]', 'CS4267', NULL, '2', 'ISYS', 'PE'),
('IS3230', 'Principles of Information Security', 4, 'Completed 60 MCs and [(IS1103 and IS1105) and (CS2105 or IS1112)]', 'CS3254', NULL, '2', 'CS(CS)', 'UEM'),
('IS3230', 'Principles of Information Security', 4, 'Completed 60 MCs and [(IS1103 and IS1105) and (CS2105 or IS1112)]', 'CS3254', NULL, '2', 'CS/ ISYS', 'PE'),
('IS3240', 'Economics of E-Business', 4, 'Completed 60 MCs and [EC1101 or EC1101E or EC1301 or EC1310 or EC1311 or GCE `A` Level Economics or BSP1005]', 'CS3265', NULL, '2', 'BZA/ ISYS', 'PE'),
('IS3241', 'Enterprise Social Systems', 4, NULL, NULL, NULL, '', 'ISYS', 'PE'),
('IS3242', 'Software Quality Management', 4, 'Completed 60 MCs and [CS2250 or IS1105]', NULL, NULL, '1', 'ISYS', 'PE'),
('IS3243', 'Technology Strategy and Management', 4, 'Completed 60 MCs and [CS2250 or IS1105]', 'CS3251', NULL, '1', 'ISYS', 'PE'),
('IS3250', 'Health Informatics', 4, 'Students must have completed 60 MCs.', NULL, NULL, '2', 'ISYS', 'PE'),
('IS3251', 'Principles of Technology Entrepreneurship', 4, 'Completed 40 MCs', NULL, NULL, '2', 'ISYS', 'PE'),
('IS3260', 'Gamification for Organisations and Individuals', 4, NULL, NULL, NULL, '', 'ISYS', 'PE'),
('IS3261', 'Mobile Apps Development for Enterprise', 4, 'CS1020 or CS2020', NULL, NULL, '1', 'ISYS', 'PE'),
('IS4010', 'Industry Internship Programme', 12, 'At least 80 MCs fulfilled and IS2101 & IS2103 for IS programme students or IS2150 for EC programme students or BT2101 for BA programme students', NULL, NULL, '1', 'BZA', 'C'),
('IS4010', 'Industry Internship Programme', 12, 'At least 80 MCs fulfilled and IS2101 & IS2103 for IS programme students or IS2150 for EC programme students or BT2101 for BA programme students', NULL, NULL, '1', 'CS(ALL)', 'PE'),
('IS4010', 'Industry Internship Programme', 12, 'At least 80 MCs fulfilled and IS2101 & IS2103 for IS programme students or IS2150 for EC programme students or BT2101 for BA programme students', NULL, NULL, '1', 'ISEC', 'PE'),
('IS4010', 'Industry Internship Programme', 12, 'At least 80 MCs fulfilled and IS2101 & IS2103 for IS programme students or IS2150 for EC programme students or BT2101 for BA programme students', NULL, NULL, '1', 'ISYS', 'C'),
('IS4100', 'IT Project Management', 4, 'Completed 80 MCs and [CS2250 or (IS1103 or IS1103FC or IS1103X and IS1105)] and (CS2261 or IS2103)', 'IS5110 or CS5212(old code for IS5110)', NULL, '1, 2', 'ISEC', 'C'),
('IS4150', 'Mobile and Ubiquitous Commerce', 4, 'Completed 80 MCs and IS2150', NULL, NULL, '2', 'ISYS', 'PE'),
('IS4202', 'Global Virtual Project', 4, NULL, NULL, NULL, '', 'ISYS', 'PE'),
('IS4203', 'IT Adoption and Change Management', 4, NULL, NULL, NULL, '', 'ISYS', 'PE'),
('IS4204', 'IT Governance', 4, 'Completed 80 MCs', NULL, NULL, '1', 'ISEC/ ISYS', 'PE'),
('IS4224', 'Service Systems', 4, 'Completed 80 MCs and [CS3361 or IS3220]', 'CS4361', NULL, '1', 'ISYS', 'PE'),
('IS4225', 'Strategic IS Planning', 4, 'Completed 80 MCs and [CS2250 or (IS1103 and IS1105)]', 'CS4251; Arts and social sciences students reading CNM as a subjec/concentration are not allowed to read this module as CFM/ULR-Breadth', NULL, '1', 'ISYS', 'PE'),
('IS4226', 'IT Outsourcing and Offshoring Management', 4, 'Completed 80 MCs and [CS2250 or (IS1103 and IS1105)]', 'CS4255', NULL, '2', 'ISYS', 'PE'),
('IS4227', 'Enterprise Service-Oriented Architecture', 4, 'Completed 80 MCs and [CS3361 or IS3220]', 'CS4258', NULL, '2', 'ISYS', 'PE'),
('IS4228', 'Information Technologies in Financial Services', 4, 'Completed 80 MCs', NULL, NULL, '1', 'ISYS', 'PE'),
('IS4231', 'Information Security Management', 4, 'Completed 80 MCs and (CS2107 or IS3230)', NULL, NULL, '1', 'CS(CS)', 'UEM'),
('IS4231', 'Information Security Management', 4, 'Completed 80 MCs and (CS2107 or IS3230)', NULL, NULL, '1', 'ISEC', 'C'),
('IS4231', 'Information Security Management', 4, 'Completed 80 MCs and (CS2107 or IS3230)', NULL, NULL, '1', 'ISYS', 'PE'),
('IS4232', 'Topics in Information Security Management', 4, NULL, NULL, NULL, '', 'CS(CS)', 'UEM'),
('IS4232', 'Topics in Information Security Management', 4, NULL, NULL, NULL, '', 'ISEC/ ISYS', 'PE'),
('IS4233', 'Legal Aspects of Information Technology', 4, 'Completed 80 MCs and [CS2250 or (IS1103 or IS1103FC or IS1103X and IS1105)]', 'CS4259', NULL, '1', 'ISEC/ ISYS', 'PE'),
('IS4234', 'Control and Audit of Information Systems', 4, 'Completed 80 MCs and [CS3254 or IS4231]', 'CS4252', NULL, '2', 'ISEC/ ISYS', 'PE'),
('IS4240', 'Business Intelligence Systems', 4, 'Completed 80 MCs and [(IS1112 or IS1112FC or CS2102) and (IS1103 or IS1103FC) and IS1105 and (ST1131 or ST2334 or ST2132)]', NULL, NULL, '1', 'ISYS', 'PE'),
('IS4241', 'Social Media Network Analysis', 4, 'Completed 80 MCs and CS1020 or CS2020', NULL, NULL, '1', 'BZA/ ISYS', 'PE'),
('IS4243', 'Information Systems Consulting', 4, 'Completed 80 MCs and [CS2250 or (IS1103 and IS1105)]', 'CS4253', NULL, '2', 'ISYS', 'PE'),
('IS4250', 'Healthcare Analytics', 4, NULL, NULL, NULL, '', 'BZA/ ISYS', 'PE'),
('IS4260', 'E-Commerce Business Models', 4, 'Completed 80 MCs and [CS2250 or (IS1103 and IS1105)]', 'CS4260', NULL, '2', 'ISYS', 'PE'),
('LSM1301', 'General Biology', 4, NULL, 'MUST NOT HAVE GCE `A` LEVEL OR H2 BIOLOGY OR EQUIVALENT. CANNOT READ CONCURRENTLY WITH LSM1101 or LSM1102 or LSM1103 or LSM1104 or LSM1202. STUDENT MUST NOT HAVE PASSED LSM1301FC or LSM1301X.', NULL, '1, 2', 'CS(ALL)', 'PE'),
('LSM1302', 'Genes and Society', 4, NULL, NULL, NULL, '', 'CS(ALL)', 'PE'),
('LSM1303', 'Animal Behaviour', 4, NULL, 'Life Sciences major/minor and student from Bachelor of Environmental Studies Programme', NULL, '2', 'CS(ALL)', 'PE'),
('MA1101R', 'Linear Algebra I', 4, 'GCE `A` LEVEL MATHEMATICS OR H2 MATHEMATICS OR MA1301 OR MA1301FC OR MA1301X', 'EG1401 or EG1402 or MA1101 or MA1311 or MA1506 or MA1508 or FOE students', NULL, '1, 2', 'BZA/ CS(ALL)/ ISEC', 'C'),
('MA1102R', 'Calculus', 4, 'GCE `A` LEVEL MATHEMATICS OR H2 MATHEMATICS OR MA1301 OR MA1301FC OR MA1301X', 'EE1401 or EE1461 or EG1401 or EG1402 or CE1402 or MA1102 or MA1312 or MA1505 or MA1505C or MA1507 or MA1521 or CEC students or COM students who matriculated on and after 2002 (including poly 2002 intake) or FoE students', NULL, '1, 2', 'BZA', 'C'),
('MA1104', 'Multivariable Calculus', 4, 'MA1102 or MA1102R or MA1505 or MA1505C or MA1521 or EE1401 or EE1461 or EG1402', 'MA1104S or MA2207 or MA2221 or MA2311 or MA3208 or GM2301 or MQ2202 or MQ2102 or MQ2203 or PC1134 or PC2201 or MA1507 or MPE students', NULL, '1, 2', 'CS(ALL)', 'PE'),
('MA1301', 'Introductory Mathematics', 4, 'Pass in `O` level Additional Mathematics or AO-level or H1 Mathematics', 'A-LEVEL OR H2 PASSES IN MATHEMATICS or MA1101R or MA1102R or MA1301FC or MA1301X or MA1505 or MA1506 or MA1507 or MA1508 or MA1521 or MA1311 or MA1312 or MA1421 or MPE STUDENTS', NULL, '1, 2', 'CS(ALL)', 'PE'),
('MA1301', 'Introductory Mathematics', 4, 'Pass in `O` level Additional Mathematics or AO-level or H1 Mathematics', 'A-LEVEL OR H2 PASSES IN MATHEMATICS or MA1101R or MA1102R or MA1301FC or MA1301X or MA1505 or MA1506 or MA1507 or MA1508 or MA1521 or MA1311 or MA1312 or MA1421 or MPE STUDENTS', NULL, '1, 2', 'ISYS', 'C'),
('MA1301X', 'Introductory Mathematics', 4, 'Pass in `O` level Additional Mathematics or AO-level or H1 Mathematics', 'A-level or H2 passes in Mathematics or MA1301 or MA1301FC', NULL, '2, 3', 'CS(ALL)', 'PE'),
('MA1311', 'Matrix Algebra', 4, 'AO-LEVEL MATHEMATICS OR H1 MATHEMATICS OR MA1301 OR MA1301FC or MA1301X', 'MA1101R or MA1506 or MA1508 or FoE students', NULL, '1', 'BZA', 'C'),
('MA1312', 'Calculus with Applications', 4, 'AO-LEVEL MATHEMATICS OR H1 MATHEMATICS OR MA1301 OR MA1301FC or MA1301X', 'MA1102R or MA1505 or MA1505C or MA1521 or FoE students', NULL, '2', 'ISYS', 'PE'),
('MA1505', 'Mathematics I', 4, 'GCE `A` LEVEL MATHEMATICS OR H2 MATHEMATICS OR MA1301 OR MA1301FC OR MA1301X', 'MA1102R or MA1312 or MA1507 or MA1521 or MA2311 or MA2501 or EE1461 or PC2174', NULL, '1, 2', 'CEG', 'C'),
('MA1506', 'Mathematics II', 4, 'MA1102R or MA1505 or MA1521', 'MA1101R or MA1311 or MA2312 or MA1508 or MA2501 or EE1461 or PC2174', NULL, '1, 2', 'CEG', 'C'),
('MA1521', 'Calculus for Computing', 4, 'GCE `A` LEVEL MATHEMATICS OR H2 MATHEMATICS OR MA1301 OR MA1301FC OR MA1301X', 'MA1102R or MA1312 or MA1505 or MA1507 or MA2501 or FoE students', NULL, '1, 2', 'BZA/ CS(ALL)/ ISEC', 'C'),
('MA1521', 'Calculus for Computing', 4, 'GCE `A` LEVEL MATHEMATICS OR H2 MATHEMATICS OR MA1301 OR MA1301FC OR MA1301X', 'MA1102R or MA1312 or MA1505 or MA1507 or MA2501 or FoE students', NULL, '1, 2', 'ISYS', 'PE'),
('MA2101', 'Linear Algebra II', 4, 'MA1101 or MA1101R or MA1506 or MA1508 or GM1302 or GM1308', 'MA2101S or MA2101H or MA2201 or MA2203 or MQ2201 or MQ2101 or MQ2203', NULL, '1, 2', 'CS(ALL)', 'PE'),
('MA2108', 'Mathematical Analysis I', 4, 'MA1102 or MA1102R or MA1505 or MA1505C or MA1507 or MA1521', 'MA2108S or MA2206 or MA2208 or MA2221 or MA2311 or MQ2202 or MQ2102 or MQ2203 or CN2401 or EE2401 or ME2492', NULL, '1, 2', 'CS(ALL)', 'PE'),
('MA2213', 'Numerical Analysis I', 4, '(MA1102R or MA1312 or MA1507 or MA1505 or MA1521 or EG1402 or EE1401 or EE1461) and (MA1101R or MA1311 or MA1508 or MA1506)', 'CE2407 or ME3291 or CN3421 or CN3411 or CHE students (for breadth requirements) or EVE students (for breadth requirements)', NULL, '1, 2', 'CS(ALL)', 'PE'),
('MA2214', 'Combinatorics and Graphs I', 4, 'MA1100 or MA1101R or MA1311 or MA1506 or MA1508 or CS1231 or CS1231S', NULL, NULL, '1', 'CS(ALL)', 'PE'),
('MA2501', 'Differential Equations and Systems', 4, 'MA1507 and MA1508', 'MA1505 or MA1505C or MA1521 or MA1506 or MA2210 or MA2312', NULL, '1', 'CS(ALL)', 'PE'),
('ME4245', 'Robot Mechanics and Control', 4, 'MA1506/ME2142 for ME students EE2010 / EE3331C for ECE students', NULL, NULL, '1', '', ''),
('MKT1003X', 'Marketing', 4, NULL, 'EC3230 or EC2210 or CS3261 or IC3243 or PR4201 or BK2003 or BZ1003 or BH1003', NULL, '1, 2', 'BZA', 'C'),
('MKT4415C', 'SIM: Marketing Analytics', 4, 'MKT2401', NULL, NULL, '1, 2', 'BZA', 'PE'),
('PC1141', 'Introduction to Classical Mechanics', 4, '`A` LEVEL OR H2 PASS IN PHYSICS OR PC1221/PC1221FC/ PC1221X & PC1222/PC1222X', 'PC1431 or PC1431FC or PC1431X or PC1433', NULL, '1', 'CS(ALL)', 'PE'),
('PC1142', 'Introduction to Thermodynamics and Optics', 4, '`A` LEVEL OR H2 PASS IN PHYSICS OR PC1221/PC1221FC/ PC1221X & PC1222/PC1222X', 'PC1431 or PC1431FC or PC1431X', NULL, '1', 'CS(ALL)', 'PE'),
('PC1143', 'Introduction to Electricity & Magnetism', 4, '`A` level or H2 pass in Physics or PC1221/PC1221FC/PC1221X & PC1222/PC1222X', 'PC1432 or PC1432X', NULL, '2', 'CS(ALL)', 'PE'),
('PC1144', 'Introduction to Modern Physics', 4, '`A` level or H2 pass in Physics or PC1221/PC1221FC/PC1221X & PC1222/PC1222X', 'PC1432 or PC1432X', NULL, '2', 'CS(ALL)', 'PE'),
('PC1221', 'Fundamentals of Physics I', 4, '`O` level pass in Physics or Combined Science (Physics & Chemistry OR Physics & Biology).', '`A` LEVEL OR H2 PASS IN PHYSICS or PC1141 or PC1142 or PC1431 or PC1431FC or PC1431X or PC1221FC or PC1221X', NULL, '1, 2', 'CS(ALL)', 'PE'),
('PC1221X', 'Fundamentals of Physics 1', 4, '`O` level pass in Physics or Combined Science (Physics & Chemistry OR Physics & Biology) or its equivalent', '`A` level or H2 pass in Physics or PC1141 or PC1142 or PC1431 or PC1431FC or PC1431X or PC1221 or PC1221FC', NULL, '2, 3', 'CS(ALL)', 'PE'),
('PC1222', 'Fundamentals of Physics II', 4, '`O` level pass in Physics or Combined Science (Physics & Chemistry OR Physics & Biology).', '`A` level or H2 pass in Physics or PC1143 or PC1144 or PC1432/PC1432X', NULL, '1, 2', 'CS(ALL)', 'PE'),
('PC1222X', 'Fundamentals of Physics II', 4, '`O` level pass in Physics or Combined Science (Physics & Chemistry OR Physics & Biology) or its equivalent', '`A` level or H2 pass in Physics or PC1222 or PC1143 or PC1144 or PC1432 or PC1432X', NULL, '2, 3', 'CS(ALL)', 'PE'),
('PC1421', 'Physics for Life Sciences', 4, 'Life-sciences majors who have at least an `O` Level pass in Physics', NULL, NULL, '1', 'CS(ALL)', 'PE'),
('PC1431', 'Physics IE', 4, 'Students from FOE with `A` level or H2 pass in Physics; or `A` level or H2 pass in Physics or PC1221/PC1221FC/PC1221X and (PC1222 or PC1222X)', 'Students majoring in Physics or PC1141 or PC1142 or PC1433 or PC1431FC or PC1431X ', NULL, '1, 2', 'CS(ALL)', 'PE'),
('PC1432', 'Physics IIE', 4, 'Students from FOE with `A` level or H2 pass in Physics; or `A` level or H2 pass in Physics or PC1221/PC1221FC/PC1221X & PC1222/PC1222X', 'Students majoring in Physics or PC1143 or PC1144 or PC1432X', NULL, '1, 2', 'CEG', 'C'),
('PC1432', 'Physics IIE', 4, 'Students from FOE with `A` level or H2 pass in Physics; or `A` level or H2 pass in Physics or PC1221/PC1221FC/PC1221X & PC1222/PC1222X', 'Students majoring in Physics or PC1143 or PC1144 or PC1432X', NULL, '1, 2', 'CS(ALL)', 'PE'),
('PC1433', 'Mechanics and Waves', 4, '`A` Level or H2 Physics. This module is only for ESP students.', 'PC1141 or PC1431 or PC1431FC or PC1431X', NULL, '1', 'CS(ALL)', 'PE'),
('ST2131', 'Probability', 4, 'MA1102 or MA1102R or MA1312 or MA1507 or MA1505 or MA1505C or MA1521', 'MA2216 or ST2334 or CE2407', NULL, '1, 2', 'CS(ALL)', 'PE'),
('ST2132', 'Mathematical Statistics', 4, 'MA2216 or ST2131 or ST2334', NULL, NULL, '1, 2', 'CS(ALL)', 'PE'),
('ST2137', 'Computer Aided Data Analysis', 4, 'ST1131 or ST1131A or ST1232 or ST2334 or ST2131 or MA2216', NULL, NULL, '1, 2', 'CS(ALL)', 'PE'),
('ST2334', 'Probability and Statistics', 4, 'MA1102R or MA1312 or MA1505 or MA1507 or MA1521', 'ST1131 or ST1131A or ST1232 or ST2131 or MA2216 or CE2407 or EC2231 or EC2303 or PR2103 or DSC2008. ME students taking or having taken ME4273. All ISE students.', NULL, '1, 2', 'BZA/ CEG/ ISEC/ ISYS', 'C'),
('ST2334', 'Probability and Statistics', 4, 'MA1102R or MA1312 or MA1505 or MA1507 or MA1521', 'ST1131 or ST1131A or ST1232 or ST2131 or MA2216 or CE2407 or EC2231 or EC2303 or PR2103 or DSC2008. ME students taking or having taken ME4273. All ISE students.', NULL, '1, 2', 'CS(ALL)', 'PE'),
('ST3131', 'Regression Analysis', 4, 'ST2131 or MA2216 or ST2334', 'ST2335 or EC3303', NULL, '1, 2', 'BZA', 'C'),
('ST4240', 'Data Mining', 4, 'ST3131', NULL, NULL, '2', 'BZA', 'PE'),
('ST4245', 'Statistical Methods for Finance', 4, 'ST3131', NULL, NULL, '2', 'BZA', 'PE'),
('UE 1', 'Unrestricted Electives', 4, NULL, NULL, NULL, '1, 2', '', 'UEM'),
('UE 2', 'Unrestricted Electives', 4, NULL, NULL, NULL, '1, 2', '', 'UEM'),
('UE 3', 'Unrestricted Electives', 4, NULL, NULL, NULL, '1, 2', '', 'UEM'),
('UE 4', 'Unrestricted Electives', 4, NULL, NULL, NULL, '1, 2', '', 'UEM'),
('UE 5', 'Unrestricted Electives', 4, NULL, NULL, NULL, '1, 2', '', 'UEM');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `courses`
--
ALTER TABLE `courses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `modules`
--
ALTER TABLE `modules`
  ADD PRIMARY KEY (`code`,`title`,`course`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `courses`
--
ALTER TABLE `courses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;