Assignments and Homeworks

All assignments (homeworks and project) must be submitted electronically via the class homework submission site: Submission site

Assignment #1: Sample Submission
Due Date: 8:00 pm, Monday, January 24, 2022
Handout: in PDF   (released on January 14)

Assignment #2: SQL Review
Due Date: 8:00 pm, Wednesday, February 2, 2022
Handout: HW2 in PDF   (released on January 21)
Sample Data: sample-data.sql in SQL   (released on January 21)
PostgreSQL: pgSQL Review in HTML/PDF   (released on January 23)
Quick Starting Guide: QuickGuide.pdf in PDF   (released on January 23)
Sample solution: hw2-db.sql (released on Feb. 14)
hw2-query.sql (released on Feb. 14)

Assignment #3: Theory of Recovery & Serializability
Due Date: 8:00 pm, Thursday, February 18, 2022
Handout: in PDF   (released on Febr. 9)
Sample Solution: hw3-sol.pdf in PDF,   (posted on Mar. 3)

Assignment #4: Physical Storage & Indexing
Due Date: 8:00 pm, Saturday, March 5, 2022
Handout: in PDF   (released on Feb. 22)
Sample Solution: hw4-sol.pdf in PDF,   (posted on Mar. 8)

Term Project
Due Date: TD: Team declaration, 8:00 pm, Thursday, March 24, 2022
P1: Phase #1, 8:00 pm, Wednesday, April 13, 2022
P2: Phase #2 , 8:00 pm, Sunday, April 26, 2022 < Updated >
Handout: in PDF   (released on Mar. 19)
Sample Data: sample-data.zip in ZIP,   (released on Mar. 20)
Sample Code: Deadlock detector code DeadlockDetector.py in Python.   (released on Mar. 29)

Assignment #5: Query Processing & Optimization
Due Date: 8:00 pm, Wednesday, April 20, 2022
Handout: in PDF   (released on April 5)
Sample Solution: hw5-sol.pdf in PDF,   (posted on April 22) < New >