Written Assignments
| Title | Due Date | Material |
|---|---|---|
| Assignment 1 | Jan 27, 2024 @ 23:59 | ER-Model |
| Assignment 2 | Feb 03, 2024 @ 23:59 | Relational Algebra |
| Assignment 3 | Feb 10, 2024 @ 23:59 | SQL |
| Assignment 4 | Feb 26, 2024 @ 23:59 | Normalization |
| Assignment 5A | Mar 05, 2024 @ 23:59 | File Organization |
| Assignment 5B | Mar 23, 2024 @ 23:59 | Indexing And Sorting |
| Assignment 6 | Apr 05, 2024 @ 23:59 | Query Optimization |
Project Assignments
| Title | Due Date | Material |
|---|---|---|
| Project 1.1 | Feb 8, 2024 @ 23:59 | Project doc |
| Project 1.2 | Mar 1, 2024 @ 23:59 | Project doc |
| Project 1.3 | Mar 21, 2024 @ 23:59 | Project doc |
| Project 2 | Apr 4, 2024 @ 23:59 | Project doc |
Project 1.1
In the first project, you have to design an Entity-Relationship Diagram (ER Diagram) for a movie like application. This application will have a simple user interface that is connected to a MySQL database. More information on the project can be found here. Please go through the document carefully and start it as soon as possible.
Project 1.2
In the first deliverable, you have already submitted an Entity-Relationship Diagram (ER Diagram) for the application, along with a relational schema. For this next deliverable, you will create a simple UI that connects to the back-end (i.e., database). More information on the project can be found here. Again, please read the document carefully and start working on it as soon as possible.
Project 1.3
For your final task of Project 1, update your application to execute a series of queries from the front end to the database, displaying the query results in the UI. Use the PA_1_3_data.zip file from the Piazza resource page for database setup. A helpful video demonstrating how to load your tables using PhpMyAdmin is also available on Piazza. For comprehensive project details, refer to the project information document here. Please read the document carefully and begin your work as soon as possible.
Project 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.