Students can access contents of previously taught courses below.
Lecture Notes
Lecture 1 (A: 25/08/2025, B: 21/08/2025)
Lecture 2 (A: 29/08/2025, B: 27/08/2025)
Lecture 3 (A: 01/09/2025, B: 28/08/2025)
Lecture 4 (A: 05/09/2025, B: 03/09/2025)
Lecture 5 (A: 08/09/2025, B: 10/09/2025)
Lecture 6 (A: 12/09/2025, B: 12/09/2025)
Lecture 7 (A: 15/09/2025 and 16/09/2025, B: 16/09/2025 and 17/09/2025)
Lecture 8 (A: 22/09/2025, B: 17/09/2025, 18/09/2025, 19/09/2025 and 22/09/2025)
Lecture 9 (A + B: 23/09/2025)
Lecture 10 (A + B: 24/09/2025 and 25/09/2025)
Lecture 11 (A + B: 26/09/2025)
Lecture 12 (A + B: 16/10/2025 and 17/10/2025)
Lecture 13 (A + B: 22/10/2025)
Lecture 14 (A: 24/10/2025, B: 23/10/2025)
Tutorial Handouts
Handout 1: Relational Algebraic Expressions Examples and Properties
Handout 2: Relational Calculus, Tuple Relational Calculus and Domain Relational Calculus
Handout 3: SQL Commands and Constructs
Handout 4: Relational Database Design Algorithms & Concepts
Handout 5: End-semester Examination Practice Questions
Assignments
Code: T01-03-10-25
Click above for instructions.
Selection form (Closed): Selections and groups (Green rows indicate approval, red rows indicate requirement of re-submission based on comment specified.)
Project Submission deadline: 25/11/2025
Project Submission link: LINK
Click for further instructions (26/10/2025).
Click for group-wise presentation schedule (16/11/2025).
Click for final instructions (23/11/2025).
Project Scores: LINK
Lab Modules
11/09/25 & 12/09/25: Relation schema, DB schema with keys for multi-branch library management system
18/09/25 & 19/09/25: Introduction to MySQL Workbench, introduction to definition, use and querying using SQL. Implementation: multi-branch library system from previous lab
16/10/25 & 17/10/25: Implement and complete all queries presented in the lab assignment. Refer to the Handouts section in Lecture Resources for references.
23/10/25 & 24/10/25: Completion of previous queries.
07/11/25: Querying existing database using intermediate SQL commands as given in slides.
Quizzes and Exams
Slides (These slides are original versions provided by author of the textbook (Deitel & Deitel) of the course.)
Tutorial Handouts
Tutorial Handout - 1: Sample questions and solutions in C programming
Assignments
Code: L01-23-09-25
Code: L02-28-10-25
Lab Modules
02/09/25: Printing a statement in C, adding two integers in C, print size and range of various data types in C.
09/09/25: Using if...else to print "pass" or "fail" based on input scores, using multiple/nested if_else to print grades based on input scores, pseudocode for problem to find and display type and values of roots of a quadratic equation and implementation in C.
16/09/25: Implement C program for counter-controlled and sentinel controlled while loops from Chapter-03 slides, pseudocode and C implementation of Digital Safe Lock problem.
30/09/25: Implement in C the various problems provided in the given problem set. Objective is to gain understanding on using various loops, conditionals, selections and arrays.
21/10/25: Complete previously pending lab-work, followed by full implementation of the University Exam Data Analyzer problem.
28/10/25: Complete previously pending lab-work followed by solving the problems in the given problem set.
04/11/25: Complete previously pending lab-work followed by solving the problems in the given problem set. Objective is to improve understanding of arrays and utilize user defined functions.
11/11/25: Complete all previously pending lab-work, followed by solving the problems in the given problem set. Objective is to improve understanding of arrays, user-defined functions, and recursive functions. Implement all problems only after finishing pseudocode, and one sample run of the problems in your notebooks!
18/11/25: Complete all previously pending assignments mandatorily, followed by solving the problems in the given problem set.
Quizzes and Exams
Quiz - 1: 29/09/2025 (Monday), 15:00-16:00
Question-bank
Mid Semester Examination: 10/10/25 (Friday), 11:00-13:00
Question-bank
Quiz - 2: 22/11/2025 (Saturday), 14:00-15:00
Question-bank
End Semester Lab Evaluation: 25/11/2025 (Tuesday), 14:00-17:30
Syllabus
Question-bank
End Semester Examination: 08/12/2025 (Monday), 10:30-13:30
Syllabus: All topics covered in class