Assignments
ALL ASSIGNMENTS ARE DUE AT THE BEGINNING OF LECTURE
(1:30pm sharp!) ON THE DUE DATE
- NEW: 9/16: Due to G20 and GHC celebrations, there will be no Asn4 - it's weight is re-distributed to some of the remaining ones (marked in bold)
- 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.
- All assignments are to be done individually.
- Notice that the weights add up to 100%.
|
Asn. # |
Assignment Name |
Category |
Handout |
Weight |
Due Date |
TA |
1 |
Data Modeling |
pencil+paper |
Asn1; sqlite db, raw csv; Sol1 |
5% |
9/8
|
Aditya |
2 |
Formal Query Languages |
pencil+paper |
Asn2; sqlite db; Sol2 |
5% |
9/15
|
Aditya |
3 |
SQL |
DB-app |
Asn3, postgres info; Sol3 |
10% |
9/22 9/29
|
Aditya
|
4 |
Buffer Management |
DB-internals |
|
0% |
|
|
5 |
Indexing |
DB-internals |
Asn5, db_asn5.zip; db_asn5_sol.tar.gz |
20% |
10/8
|
Leman
|
6 |
Query Processing |
pencil+paper |
Asn6, Sol6 |
5% |
10/20
|
Aditya
|
7 |
Query Optimization |
DB-app |
Asn7, Sol7 |
15% |
10/27
|
Leman
|
8 |
Schema Refinement |
pencil+paper |
Asn8, Sol8 |
5% |
11/3
|
Aditya
|
9 |
Database Application |
DB-app |
Asn9 |
30% |
11/10, 11/19
|
Leman
|
10 |
Concurrency Control |
pencil+paper |
NEW ->Asn10, Sol10 |
5% |
12/1
|
Aditya
|
|
TOTAL |
|
|
100% |
|
|
Resources / Documentation