CMPSCI 645: Database Design and Implementation


Submission

Unless otherwise indicated, assignment solutions will need to be submitted through Gradescope. Please follow the submission instructions for each assignment. You are required to work alone for all homework assignments, unless otherwise noted.

Late policy

The cutoff for on-time submission of homework assignments is 5 pm on the due date. Late days are counted in 24-hour periods. Submitting one minute past 5 pm until 5 pm of the next day is one day late, and so on. You are given 3 "grace days" (self-granted extensions) which you can use to give yourself extra time without penalty. Grace days work only on individual homework assignments, not on the course project. Late work handed in when you have run out of grace days is discounted 10% for each day you are late.


System Support

Information about using the PostgreSQL server can be found here.


Assignment 1 (due Friday, Feb 7 at 5 pm)


Assignment 2 (due Friday, Feb 28 at 5 pm)

  • Topics: normalization theory, disks and files, B+ tree indexes, query processing
  • Assignment
  • Lab-slides

Assignment 3 (due Friday, March 13 at 5 pm)

  • Topics: query processing, query optimization, concurrency, recovery

Assignment 4 (due Friday, April 10 at 5 pm)

  • Topics: OLAP and data visualization

Assignment 5 (due Friday, May 1st at 5 pm)

  • Topics: parallel processing, Spark