🎓 University Curriculum & Practical Lab Manuals

Computer Science Practical Labs Catalog

Explore 14 standardized computer science practical laboratory categories. Every experiment includes formal Aims, Learning Objectives, Algorithms, Verified Source Code, Sample Inputs/Outputs, Test Cases, and Viva Voce Q&As.

Categories: 14 Subjects (A to N)
Format: 18-Point Standard
Execution: Client-Side & 100% Free
Direct: 1-Click Open in IDE
Syllabus Completion 0 / 84
Avg Quiz Score -
Bookmarked Labs 0
⚡
Microprocessor & Microcontroller (MPMC) Simulator 8085 â€ĸ 8086 â€ĸ 8051
Simulate assembly code, input data into memory, inspect live registers, flags, and step-by-step outputs.
Launch MPMC Simulator →
How to Use Curriculum Labs: Select your department and semester below to filter matching syllabus experiments. Click any lab card to open interactive theory, algorithm flowchart, and runnable in-browser code.
Department:
6 Academic Tracks â€ĸ 84 Experiments
Semester:

đŸ”Ŧ University Practical Laboratory Curriculum & Viva Voce Manual

Standardized undergraduate computer science and engineering laboratory syllabus reference. Includes rigorous algorithms, complete runnable source implementations, expected outputs, time complexity bounds, viva questions, and the official 18-point university lab record documentation format.

📋 Official 18-Point University Lab Record Standardization Format

Academic Compliance â€ĸ AICTE & ABET Guidelines

To ensure strict adherence to university academic grading criteria and accreditation bodies, every engineering practical laboratory experiment on VAB-CODE follows the standardized 18-point documentation structure:

Points 1 to 9: Formulation & Design

1. Experiment Title & Date: Clear curricular identifier.
2. Aim / Problem Statement: Concise statement of technical objective.
3. Apparatus & Software Environment: Compiler versions (GCC, Java 17, Python 3.11, MySQL).
4. Learning Objectives: Specific skills and competencies acquired.
5. Theoretical Background: Underlying mathematical or algorithmic foundations.
6. Mathematical Equations: Formal equations, asymptotic bounds, and formulas.
7. Architectural Flowchart: Logic diagram depicting program execution flow.
8. Step-by-Step Algorithm: Language-agnostic pseudocode steps.
9. Input Data Specifications: Domain constraints and variable ranges.

Points 10 to 18: Implementation & Evaluation

10. Complete Source Code: Syntactically verified and fully indented code.
11. Comments & Error Handling: Boundary safety and explanatory annotations.
12. Compilation & Build Commands: Exact terminal CLI invocation.
13. Sample Test Case (Nominal): Standard expected input and output.
14. Boundary Test Case (Edge): Zero, null, negative, or max-scale inputs.
15. Expected Terminal Output: Exact stdout transcript.
16. Result & Conclusion: Verification that the stated aim was fulfilled.
17. Viva Voce Questions & Model Answers: Oral examination preparation.
18. Academic References: Standard textbooks (Cormen, Silberschatz, Tanenbaum).

đŸ’ģ Academic Track 1: Programming Fundamentals & Data Structures

Pointers â€ĸ Dynamic Memory (malloc/free) â€ĸ Linear & Non-Linear Lists

Data structures establish memory layout models and access patterns for algorithmic processing. Linear data structures (arrays, linked lists, stacks, queues) enforce sequential predecessor-successor relationships, whereas non-linear structures (trees, graphs) represent hierarchical and arbitrary network topologies.

Experiment 1: Implementation of Singly Linked List Operations

Aim: To write a modular C program to implement dynamic singly linked list operations: insertion at beginning/end, deletion by value, reversal of nodes, and display.
Algorithm:
1. Define struct Node containing integer data and pointer struct Node* next.
2. Insert at Beginning: Allocate memory via malloc(sizeof(struct Node)). Set newNode->next = head; update head = newNode.
3. Reverse: Initialize three pointers: prev = NULL, curr = head, next = NULL. In a loop while curr != NULL: save next = curr->next; reverse pointer curr->next = prev; advance prev = curr; advance curr = next. Set head = prev.

#include <stdio.h> #include <stdlib.h> struct Node { int data; struct Node* next; }; struct Node* insertBeginning(struct Node* head, int val) { struct Node* newNode = (struct Node*)malloc(sizeof(struct Node)); if (!newNode) { printf("Memory allocation failed!\n"); exit(1); } newNode->data = val; newNode->next = head; return newNode; } struct Node* reverseList(struct Node* head) { struct Node *prev = NULL, *curr = head, *next = NULL; while (curr != NULL) { next = curr->next; curr->next = prev; prev = curr; curr = next; } return prev; } void printList(struct Node* head) { struct Node* temp = head; while (temp) { printf("%d -> ", temp->data); temp = temp->next; } printf("NULL\n"); }
Viva Voce Questions:
â€ĸ Q: Why is pointer reversal performed in $O(1)$ auxiliary space?
â€ĸ Answer: Three temporary pointer variables (prev, curr, next) are reused across all loop iterations without allocating new heap memory, bounding space to $O(1)$.

☕ Academic Track 2: Object-Oriented Programming & Multi-Threading (Java)

Encapsulation â€ĸ Polymorphism â€ĸ Synchronized Monitors â€ĸ Thread Safety

Object-oriented design organizes code around self-contained entities (objects) encapsulating state (attributes) and behavior (methods). Java implements concurrency using monitors and intrinsic thread locks.

Experiment 2: Inter-Thread Communication (Producer-Consumer Problem)

Aim: To demonstrate thread synchronization and inter-thread signaling in Java using a bounded buffer with synchronized methods, wait(), and notify().
Theory: When multiple concurrent threads access shared mutable state, race conditions emerge. Using intrinsic object monitors, the Producer thread waits when the buffer is full, and the Consumer thread waits when the buffer is empty.

import java.util.LinkedList; import java.util.Queue; class BoundedBuffer { private final Queue<Integer> queue = new LinkedList<>(); private final int CAPACITY = 5; public synchronized void produce(int item) throws InterruptedException { while (queue.size() == CAPACITY) { wait(); // Buffer full: release monitor and sleep } queue.add(item); System.out.println("Produced: " + item + " | Buffer size: " + queue.size()); notifyAll(); // Wake up waiting consumer threads } public synchronized int consume() throws InterruptedException { while (queue.isEmpty()) { wait(); // Buffer empty: release monitor and sleep } int item = queue.poll(); System.out.println("Consumed: " + item + " | Buffer size: " + queue.size()); notifyAll(); // Wake up waiting producer threads return item; } }
Viva Voce Questions:
â€ĸ Q: Why must wait() always be called inside a while loop instead of an if statement?
â€ĸ Answer: To guard against spurious wakeups, where a thread resumes execution without an explicit signal. The while loop re-checks the condition predicate before proceeding.

đŸ—„ī¸ Academic Track 3: Database Management Systems & SQL Lab

Relational Algebra â€ĸ Multi-Table Joins â€ĸ Triggers & Stored Procedures

Relational databases store structured schemas governed by foreign keys and integrity constraints. SQL provides declarative data definition (DDL) and manipulation (DML).

Experiment 3: SQL Relational Queries, Grouping & Triggers

Aim: Create a University database schema (Department, Student, Course, Enrollment) and execute nested queries with GROUP BY, HAVING, and an automated audit trigger.

-- Schema Definition CREATE TABLE Student ( student_id INT PRIMARY KEY, name VARCHAR(50) NOT NULL, dept_id INT, gpa DECIMAL(3,2) ); CREATE TABLE CourseEnrollment ( enrollment_id INT PRIMARY KEY, student_id INT, course_name VARCHAR(50), grade VARCHAR(2), FOREIGN KEY (student_id) REFERENCES Student(student_id) ); -- Advanced Aggregation Query: Students with above-average GPA per Department SELECT s.student_id, s.name, s.gpa, s.dept_id FROM Student s WHERE s.gpa > ( SELECT AVG(s2.gpa) FROM Student s2 WHERE s2.dept_id = s.dept_id );
Viva Voce Questions:
â€ĸ Q: What is the semantic difference between WHERE and HAVING in SQL?
â€ĸ Answer: The WHERE clause filters individual records before aggregation occurs; the HAVING clause filters aggregated groups produced by GROUP BY.

âš™ī¸ Academic Track 4: Operating Systems & POSIX Systems Programming

Process Management (fork/exec) â€ĸ CPU Scheduling â€ĸ Pipes & IPC

System programming interfaces directly with the operating system kernel via system calls to manage processes, file descriptors, and virtual memory.

Experiment 4: Round Robin CPU Scheduling Simulation in C

Aim: Implement Round Robin scheduling with a given time quantum $Q$ to compute turnaround times, waiting times, and average response metrics.

#include <stdio.h> void roundRobin(int n, int burst[], int quantum) { int rem_burst[n]; for (int i = 0; i < n; i++) rem_burst[i] = burst[i]; int t = 0; // Current time int wait_time[n]; for (int i = 0; i < n; i++) wait_time[i] = 0; while (1) { int done = 1; for (int i = 0; i < n; i++) { if (rem_burst[i] > 0) { done = 0; if (rem_burst[i] > quantum) { t += quantum; rem_burst[i] -= quantum; } else { t += rem_burst[i]; wait_time[i] = t - burst[i]; rem_burst[i] = 0; } } } if (done == 1) break; } printf("PID\tBurst\tWaiting\tTurnaround\n"); for (int i = 0; i < n; i++) { printf("P%d\t%d\t%d\t%d\n", i+1, burst[i], wait_time[i], wait_time[i] + burst[i]); } }
Viva Voce Questions:
â€ĸ Q: How does time quantum size affect Round Robin performance?
â€ĸ Answer: An excessively large time quantum reduces Round Robin to FCFS; an excessively small quantum causes high context-switching overhead, degrading CPU throughput.

🌐 Academic Track 5: Computer Networks & Socket Programming

TCP/IP Sockets â€ĸ Client-Server Model â€ĸ Packet Sniffing & Routing

Socket programming enables inter-process network communication across distributed machines using IP addressing and port numbers.

Experiment 5: Client-Server TCP Echo Socket in Python

Aim: Implement an iterative TCP echo server and client using the standard Python socket library.

# Python 3: TCP Echo Server Implementation import socket def run_server(): server_sock = socket.socket(socket.AF_INET, socket.SOCK_STREAM) server_sock.setsockopt(socket.SOL_SOCKET, socket.SO_REUSEADDR, 1) server_sock.bind(('127.0.0.1', 8080)) server_sock.listen(5) print("TCP Server listening on 127.0.0.1:8080...") while True: client_sock, client_addr = server_sock.accept() print(f"Connection established from {client_addr}") data = client_sock.recv(1024) if data: print(f"Received payload: {data.decode()}") client_sock.sendall(data) # Echo data back client_sock.close()
Viva Voce Questions:
â€ĸ Q: Why is SO_REUSEADDR recommended for TCP server sockets?
â€ĸ Answer: It allows the server to immediately re-bind to the port even if previously closed sockets remain in the kernel's TIME_WAIT state.

🤖 Academic Track 6: AI, Machine Learning & Computer Vision

Supervised Learning â€ĸ Feature Scaling â€ĸ Confusion Matrix â€ĸ Scikit-Learn

Machine learning builds predictive data-driven models by discovering functional mappings $f(X) \approx Y$ from empirical training sets.

Experiment 6: Supervised Classification with Decision Trees & Evaluation

Aim: Train a Decision Tree classifier, compute the Confusion Matrix, and calculate Accuracy, Precision, Recall, and F1-Score metrics.

from sklearn.datasets import load_iris from sklearn.model_selection import train_test_split from sklearn.tree import DecisionTreeClassifier from sklearn.metrics import classification_report, confusion_matrix # Load dataset and partition 80/20 iris = load_iris() X_train, X_test, y_train, y_test = train_test_split(iris.data, iris.target, test_size=0.2, random_state=42) # Train Decision Tree with Gini Impurity clf = DecisionTreeClassifier(criterion='gini', max_depth=3, random_state=42) clf.fit(X_train, y_train) # Evaluate model predictions y_pred = clf.predict(X_test) print("Confusion Matrix:\n", confusion_matrix(y_test, y_pred)) print("\nClassification Report:\n", classification_report(y_test, y_pred, target_names=iris.target_names))
Viva Voce Questions:
â€ĸ Q: Why is Precision preferred over Accuracy in imbalanced datasets?
â€ĸ Answer: Accuracy is deceptive when the majority class dominates (e.g. 99% negative cases); Precision ($TP / (TP + FP)$) measures exactness among positive predictions regardless of negative class volume.

đŸ”Ŧ Experiment 1: SQL Injection Exploitation & Defense via Parameterized Queries

Standardized university practical engineering curriculum manual across Computer Science and Information Technology degree programs.

📋 Experiment Overview & Curriculum Specifications

Cybersecurity & Defense â€ĸ Medium â€ĸ 30 mins

Aim / Objective: To simulate a classic SQL Injection authentication bypass attack and implement defense mechanisms using prepared parameterized statements in SQLite.

Prerequisites & Domain Concepts

SQL SELECT syntax, string concatenation risks, database cursors, basic security principles.

Asymptotic Complexity Bounds

â€ĸ Time Complexity: O(1) index lookup query execution time
â€ĸ Space Complexity: O(1) memory overhead for statement parameters

Step-by-Step Algorithm

  1. Step 1: Create an in-memory SQLite database (:memory:) and create a users table (id, username, password_hash, role).
  2. Step 2: Insert two mock user accounts: ("admin", "SuperSecretAdminPass#1", "Administrator") and ("alice", "alicePassword123", "User").
  3. Step 3: Define vulnerable_login(user, pass) using f-string string interpolation: f"SELECT * FROM users WHERE username='{user}' AND password='{pass}'".
  4. Step 4: Define secure_login(user, pass) using parameterized placeholders: cursor.execute("SELECT * FROM users WHERE username=? AND password=?", (user, pass)).
  5. Step 5: Test both functions with legitimate credentials and verify login success.
  6. Step 6: Inject malicious payload: username = "admin", password = "' OR '1'='1".
  7. Step 7: Verify that vulnerable_login grants unauthorized admin access, while secure_login blocks the attack.
  8. Step 8: Output security audit report.

Verified Academic Source Code (PYTHON)

import sqlite3

def setup_mock_database():
    conn = sqlite3.connect(':memory:')
    cursor = conn.cursor()
    cursor.execute('''
        CREATE TABLE users (
            id INTEGER PRIMARY KEY,
            username TEXT UNIQUE,
            password TEXT,
            role TEXT
        )
    ''')
    # Seed mock accounts
    cursor.execute("INSERT INTO users VALUES (1, 'admin', 'Secr3tP@ssword!', 'Administrator')")
    cursor.execute("INSERT INTO users VALUES (2, 'alice', 'Wonderland#2026', 'Staff')")
    conn.commit()
    return conn

def vulnerable_login(conn, username, password):
    """VULNERABLE: Direct string formatting concatenates untrusted input into query"""
    cursor = conn.cursor()
    raw_query = f"SELECT id, username, role FROM users WHERE username = '{username}' AND password = '{password}'"
    print(f"  [RAW SQL EXECUTED] {raw_query}")
    try:
        cursor.execute(raw_query)
        user = cursor.fetchone()
        return user
    except sqlite3.OperationalError as e:
        return f"Database Error: {e}"

def secure_login(conn, username, password):
    """SECURE: Uses parameterized query placeholders (?) ensuring input is treated as literal data"""
    cursor = conn.cursor()
    safe_query = "SELECT id, username, role FROM users WHERE username = ? AND password = ?"
    print(f"  [PARAMETERIZED SQL] {safe_query} | Params: ({username}, {password})")
    cursor.execute(safe_query, (username, password))
    user = cursor.fetchone()
    return user

# Execute Test Simulation
conn = setup_mock_database()

print("=== SQL Injection Exploitation & Defense Simulation ===\n")

# Scenario 1: Legitimate User Authentication
print("--- Test 1: Legitimate Login (alice, Wonderland#2026) ---")
res = vulnerable_login(conn, 'alice', 'Wonderland#2026')
print(f"  -> Result: Successfully authenticated as {res[1]} (Role: {res[2]})\n")

# Scenario 2: Attack against Vulnerable Query
print("--- Test 2: SQL Injection Attack against Vulnerable Endpoint ---")
attack_username = "admin"
attack_password = "' OR '1'='1"

vuln_res = vulnerable_login(conn, attack_username, attack_password)
if vuln_res and not isinstance(vuln_res, str):
    print(f"  -> [SECURITY BREACH!] Attacker bypassed login as: {vuln_res[1]} (Role: {vuln_res[2]})")
else:
    print("  -> Login rejected.")

# Scenario 3: Attack against Secure Parameterized Query
print("\n--- Test 3: Same SQL Injection Attack against Secure Parameterized Query ---")
sec_res = secure_login(conn, attack_username, attack_password)
if sec_res:
    print(f"  -> [BREACH] Login granted: {sec_res}")
else:
    print("  -> [DEFENSE SUCCESSFUL] Authentication rejected. Password treated as literal string.")

conn.close()
â–ļ Run in Online IDE

Sample Test Input

Legitimate login: (alice, Wonderland#2026); Attack payload: username="admin", password="' OR '1'='1"

Expected Terminal Output

=== SQL Injection Exploitation & Defense Simulation ===

--- Test 1: Legitimate Login (alice, Wonderland#2026) ---
  [RAW SQL EXECUTED] SELECT id, username, role FROM users WHERE username = 'alice' AND password = 'Wonderland#2026'
  -> Result: Successfully authenticated as alice (Role: Staff)

--- Test 2: SQL Injection Attack against Vulnerable Endpoint ---
  [RAW SQL EXECUTED] SELECT id, username, role FROM users WHERE username = 'admin' AND password = '' OR '1'='1'
  -> [SECURITY BREACH!] Attacker bypassed login as: admin (Role: Administrator)

--- Test 3: Same SQL Injection Attack against Secure Parameterized Query ---
  [PARAMETERIZED SQL] SELECT id, username, role FROM users WHERE username = ? AND password = ? | Params: (admin, ' OR '1'='1)
  -> [DEFENSE SUCCESSFUL] Authentication rejected. Password treated as literal string.
University Viva Voce Questions & Model Answers:

â€ĸ Q: What is the root cause of SQL Injection vulnerabilities?
â€ĸ Answer: Mixing executable code with untrusted data in the same string sent to the database query interpreter, allowing user data to alter query syntax and execution logic.

â€ĸ Q: Why do Parameterized Queries (Prepared Statements) completely prevent SQL Injection?
â€ĸ Answer: In a prepared statement, the database compiles the SQL syntax and execution plan first. When parameters are bound later, the database treats them strictly as literal scalar values, never interpreting parameter content as SQL commands.

â€ĸ Q: What are the main categories of SQL Injection attacks?
â€ĸ Answer: In-band SQLi (Error-based or UNION-based, where attacker sees results directly), Inferential / Blind SQLi (Boolean-based or Time-based, where attacker infers data through true/false behavior or sleep delays), and Out-of-Band SQLi (exfiltrating data via DNS/HTTP requests).

â€ĸ Q: Can input sanitization or regex filtering reliably replace prepared statements?
â€ĸ Answer: No. Attackers frequently bypass blacklists and sanitization filters using encoding tricks, null bytes, alternate comment syntax, or unicode variations. Parameterization is the only mathematically foolproof defense.

â€ĸ Q: What is Second-Order SQL Injection?
â€ĸ Answer: Second-order SQLi occurs when injected payload data is safely stored in the database without initial execution, but later retrieved and concatenated into a dynamic SQL query in a separate administrative background job or report.