CMU-CS 15-415/615 - Assignments


All assignments are due at the beginning of the lecture (3:00pm sharp), on the due date.

All assignments are to be done individually.


There are three categories of assignments: Pencil+Paper, DB-app, and DB-internals.

  • Pencil+Paper means that a computer need not be involved.
  • DB-app means you will design some queries/software that interfaces with a database management system (treating it as a "black box").
  • DB-internals means you will write code that implements some internal module of a database management system.

The weights add up to 100% of the total assignment weight, which is 30% of the total course weight. That is, a person that obtains perfect grades in all assignments, will have 30 points for his/her final course grade.


By Name Category Solutions Weight
A1 CF ER + Formal Q.L. Pencil+Paper Assignment1-solution 5%
A2 CF SQL: data + setup info, and pdf DB-app Assignment2-solution (pdf, sql queries) 15%
A3 CF Indexing (with code, data, and info slides) DB-internals Assignment 3 - Solutions 20%
A4 CF Query Processing Pencil+Paper Assignment 4-solutions 5%
A5 AP Query Optimization DB-app Assignment 5-solutions 15%
A6 CF Query Optimization+Schema Refinement Pencil+Paper Assignment 6-solutions 5%
A7 AP Database Application; and info foils DB-app - 30%
A8 AP Concurrency Control Pencil+Paper Assignment 8 - solutions 5%
TOTAL 100%