AI Assignment Grading
Submit your assignment and get instant AI feedback & score
Session 1 — Python
Read a CSV File
Write a Python script that reads a CSV file called `students.csv` and prints every row to the console. The CSV has columns: name, age, grade…
Count Records in a Dataset
Write a Python script that reads `employees.csv` (columns: id, name, department, salary) and prints: total records, number of unique departm…
Filter Data
Write a Python script that reads `employees.csv` (id, name, department, salary) and prints only employees from the Engineering department wi…
Convert Data to JSON
Write a Python script that reads `students.csv` (name, age, grade) and converts it to a JSON file called `students.json`. Each student shoul…
Session 2 — SQL
Orders + Customers JOIN Queries
Write SQL queries for an e-commerce schema with two tables: customers(id, name, email, city) orders(id, customer_id, product, amount, order…
Swiggy-Style Delivery Schema
Write SQL queries for a food delivery schema: restaurants(id, name, city, cuisine, rating) orders(id, customer_id, restaurant_id, total_amo…
Movie Database Queries
Write SQL queries for a movie database schema: movies(id, title, genre, release_year, rating, director_id) directors(id, name, country) act…
Session 2 — SQL (Advanced)
Top N Problems
Write SQL queries using window functions for: employees(id, name, department, salary) 1. Find the top 2 highest-paid employees in each dep…
Running Totals
Write SQL queries for running totals using window functions: sales(id, salesperson, region, amount, sale_date) 1. Calculate running total …
Duplicate Detection
Write SQL queries to find and handle duplicate data: customers(id, name, email, phone, city) 1. Find all duplicate emails (emails that app…
Session 3 — Data Modelling
Design a Library Management Schema
Design a relational database schema for a simple library management system. The system should handle: - Books (a book can have multiple cop…
College Attendance System Schema
Design a database schema for a college attendance system. Requirements: - Students belong to a batch (e.g. 'CSE 2024') - Multiple subjects …
Normalize a Flat E-Commerce Table
You are given a flat (badly designed) table with all order data in one place. Your job is to normalize it into proper 3NF tables. Flat tabl…
Session 4 — System Design (Intro)
Design a URL Shortener
Design a simple URL shortener system (like bit.ly). A user gives a long URL like: https://www.google.com/maps/place/some/very/long/address …
Design an Online Exam Portal
Design a simple online exam portal for your college. Features needed: - Students log in and take a multiple choice exam - Each exam has a t…
Session 5 — Data Pipelines (Intro)
Build a Data Cleaning Pipeline
Write a Python script that reads a messy CSV file `raw_employees.csv` and produces a cleaned version `clean_employees.csv`. The raw data ha…
JSON to SQLite Pipeline
Write a Python script that reads data from a JSON file `orders.json`, transforms it, and loads it into a SQLite database. The JSON has this…
Merge Multiple CSV Files
You have 3 monthly sales CSV files: `sales_jan.csv`, `sales_feb.csv`, `sales_mar.csv`. Each file has the same columns: salesperson, region,…