Written Assignments
| Title | Due Date | Material |
|---|---|---|
| Assignment 1 | Feb 5, 2025 @ 23:59 | ER-Model |
| Assignment 2 | Feb 12, 2025 @ 23:59 | Relational Algebra & SQL |
| Assignment 3 | Feb 26, 2025 @ 23:59 | File Organization |
| Assignment 4 | Mar 5, 2025 @ 23:59 | Indexing |
| Assignment 5 | Mar 22, 2025 @ 23:59 | Hash Index & Sorting |
| Assignment 6 | Apr 4, 2025 @ 23:59 | Query Optimization |
| Assignment 7 | Apr 12, 2025 @ 23:59 | Transaction & Locks |
| Assignment 8 | -- | Normalization |
Project Assignments
| Title | Due Date | Material |
|---|---|---|
| Programming Assignment 1.1 | Mar 1, 2025 @ 23:59 | Programming Assignment doc |
| Programming Assignment 1.2 | Mar 21, 2025 @ 23:59 | Programming Assignment doc |
| Programming Assignment 2 | Apr 22, 2025 @ 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 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.
Programming Assignment 2
In this task, you will carry out several exercises involving the optimization of relational queries using the PostgreSQL query optimizer and the visualization command EXPLAIN. You need to read parts of the PostgreSQL documentation to be able to complete this task. Use the Azure Support Manual file from the Piazza resource page for Azure Virtual Machine setup. Please read the document carefully and begin your work as soon as possible.