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