All weekly homework assignments should be turned in via Gradescope. Homeworks are due at 2:59 p.m. on their In day. They will be graded and returned with solutions for certain problems.

We highly recommend that students complete their homework assignments using LaTeX. For more information, as well as helpful LaTeX tips, we've compiled a helpful page of goodies.

# Homework Out In Solutions
1 Homework 1 9/13/2017 9/20/2017 Solutions 1
2 Homework 2 9/20/2017 9/27/2017 Solutions 2
3 Homework 3 10/4/2017 10/11/2017 Solutions 3
4 Homework 4 10/18/2017 10/25/2017 Solutions 4
5 Homework 5 10/25/2017 11/1/2017 Solutions 5
6 Homework 6 11/13/2017 11/27/2017 Solutions 6
7 Homework 7 11/27/2017 12/1/2017 Solutions 7


Projects are due at 11:59 p.m. on the day they are marked as In.

The first two projects make use of SQLite, so some students may find this useful in testing/viewing their databases.

Project Out In
Yelp 9/27/2017 10/4/2017
ETL - Extract, Transform, Load 10/05/2017 10/26/2017
Query Optimization Part 1: B+ Tree 10/30/2017 11/06/2017
Query Optimization Part 2: Join Optimization 11/07/2017 11/18/2017
SimpleDB 11/19/2017 12/8/2017


Late assignments

You are not allowed to turn in homeworks late. We will count every homework and we will take off 20% per late day. You do not get any free late days.

For projects, each student gets 3 late days during the semester, in that they are not penalized for them. At the end of the semester, we will optimally distribute the three late days as needed on your projects. After your three late days, we will take off 25% per late day.

You will also receive grade reports via e-mail to keep you posted on your progress.