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