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, Friday, February 5, 2021
Handout: in PDF   (released on January 24)

Assignment #2: SQL Review
Due Date: 8:00 pm, Wednesday, February 10, 2021
Handout: HW2 in PDF   (released on January 30)
Sample Data: sample-data.csv in TXT   (released on January 30)
PostgreSQL: pgSQL Review in HTML/PDF   (released on February 2)
Quick Starting Guide: QuickGuide.pdf in PDF   (released on February 10)
Sample Solution: db.sql in TXT, query.sql in TXT   (posted on February 12)

Assignment #3: Theory of Recovery & Serializability
Due Date: 8:00 pm, Saturday, February 27, 2021 /td>
Handout: in PDF   (released on February 17)
Sample Solution: hw3-sol.pdf in PDF,   (posted on March 5)

Assignment #4: Physical Storage & Indexing
Due Date: 8:00 pm, Friday, March 12, 2021
Handout: in PDF   (released on March 2)
Sample Solution: hw4-sol.pdf in PDF,   (posted on March 14)

Term Project
Due Date: TD: Team declaration, 8:00 pm, Tuesday, March 30, 2021
DP (Optional): Design, 8:00 pm, Thursday, April 15, 2021
FI: Full Implementation, 11:59 pm, Thursday, April 29, 2021
Handout: in PDF   (released on March 27)
Sample Data: sample-data.zip in ZIP,   (released on March 27)

Assignment #5: Query Processing & Optimization
Due Date: 8:00 pm, Wednesday, April 21, 2021
Handout: in PDF   (released on April 5)
Sample Solution: hw5-sol.pdf in PDF,   (posted on April 27th) New