Written Assignments
| Title | Due Date | Material |
|---|---|---|
| Assignment 1 | Jan 28, 2026 @ 23:59 | ER-Model |
| Assignment 2 | Feb 11, 2026 @ 23:59 | Relational Algebra & SQL |
| Assignment 3 | Feb 24, 2026 @ 23:59 | File Organization & Page Replacement Policies |
| Assignment 4 | Mar 23, 2026 @ 23:59 | B+-trees & Hash Indexing |
Project Assignments
| Title | Due Date | Material |
|---|---|---|
| Programming Assignment 1.1 | Feb 26, 2026 @ 23:59 | Programming Assignment doc |
| Programming Assignment 1.2 | Mar 19, 2026 @ 23:59 | Programming Assignment doc |
Programming Assignment 1.1
In this assignment, you will extend your work from Problem 3 of Written Assignment 1, where you designed an Entity-Relationship Diagram (ER Diagram) for an IMDb-like movie database. Now, you will focus on implementing the database and building a functional website that connects to a MySQL database. More details on the project, including guidelines and requirements, can be found here. Please review the document carefully and start early to ensure smooth progress.
Programming Assignment 1.2
For the final task of Project 1, update the queries.py file for 18 queries so that it executes a series of queries from the front end to the database, displaying the results in the UI. To get started, read the project document file from the Piazza resource page by clicking here. Please read the accompanying document carefully and begin your work as soon as possible.