Submission
Please hand in a hardcopy of your solutions to the instructor before
class. Late submissions will not be accepted with exceptions such as
delays caused by illness or certain urgent matters. Please contact the
instructor before the deadline if you cannot complete an
assignment in time due to the reasons mentioned above.
Support Support
Information about using the PostgreSQL server can be found here.
Assignment 1 (due Feb 19)
- Topics: data models, relational algebra, SQL, language theory, normalization
- Assignment
- Dataset: student.txt, faculty.txt, class.txt, enrolled.txt
- [Solution]
Assignment 2 (due Mar 5)
- Topics: storage and indexing
- Assignment
- Scripts: create-yanlei.sql, load.sql, analyze.sql
- [Solution]
Assignment 3 (due Mar 26)
- Topics: query processing and optimization
- Assignment
- [Solution]
Assignment 4 (due April 7)
- Topics: concurrency control, recovery
- Assignment
- [Solution]
Midterm
Assignment 5 (due May 5)
- Topics: XML queries, stream processing
- Assignment