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 > |
|