Computer Science (COMS)
2 units: Database Management System, Foundation of Artificial Intelligence.
Detailed syllabus
Unit 1: Database Management System (50 hours, 20 marks)
Advantages of DBMS, layered architecture, data independence, data models, schemas and instances, database languages and users, DBA, data dictionary; ER modelling (entities, attributes, relationships, keys, weak entities, specialisation, generalisation, aggregation); relational model and relational algebra; integrity constraints and views; SQL: DDL and DML, data types, constraints, table operations, select with where, in, between, order by, like, null handling, update, delete, aggregate functions, group by, having, joins (cartesian, equi and natural).
Unit 2: Foundation of Artificial Intelligence (30 hours, 15 marks)
Definition, scope and history of AI; machine learning (supervised, unsupervised, reinforcement), deep learning and neural networks, NLP and computer vision; state-space search, data- and goal-driven search, heuristic search, BFS, DFS, A*; AI in finance, customer service and education; bias, fairness, employment and social impact of AI.
Source: official document