CMSC724: Database Management Systems

Prof. Amol Deshpande;    CSIC 3118;    Tue-Thur 11:00am-12:15pm


[Home] [Schedule] [Assignments] [Resources]

Programming Assignment 1 (SQL Assignment)

Due: February 8, 2013

The zip file below contains: a pdf file, an SQL script to populate the database, and a text file containing the questions (the same text file should be used for submission). Submission is through submit server.

SQL Assignment ZIP

Programming Assignment 2 (Query Processing/Optimization)

Due: March 8, 2013

Assignment 2 PDF
tpch.zip (the dataset, including the SQL scripts)

Submission: a single hardcopy containing everything would be preferred, but you can also send me a single email with the Java program, and any pdf or text files as separate attachments (please do not submit a zip file). You can slide hardcopies under my door and give it to me in class.

Any questions about the assignment should be asked in Piazza in the thread created.

Due date: March 8, 2013, Friday.


Wrriten Assignments

The tentative plan is a small written assignment every two weeks. We may revise depending on how things go in the early assignments.
Each assignment worth 5 points. I will pick the best 5 out of 6 scores. You can submit using the submit server or you can submit a hard copy before the deadline (you can slide it under my office door if I am not there). Approximate due dates (11:59pm):
  1. Homework 1 Due: Wednesday, February 13, 2013
  2. Homework 2 Due: Wednesday, February 27, 2013
  3. Homework 3 Due: Wednesday, March 13, 2013
  4. Homework 4 Due: Wednesday, April 3, 2013
  5. Homework 5 Due: Wednesday, April 17, 2013
  6. Homework 6 Due: Wednesday, May 1, 2013

Questions about Readings

For every week's assigned readings, you have to answer a few simple questions (online) before the class. This is to ensure that you at least open the paper PDFs. However, if you only read sufficiently to answer these questions, you are unlikely to get any of the class participation credit. Late submissions are not allowed, but you can miss one submission.


Class Project

The project will be a mini research project that will be conducted by groups.

There will be four major milestones. In an attempt to make the grading somewhat objective, this year each of the milestones will be separately graded with the split: 4 + 10 + 6 + 10 = 30 (however, I will consider extra credit for the later phases to make up for lost points earlier).

Group Members and the Project Idea/Proposal (Due: 2/15/13)

A one-page proposal stating and motivating the problem.

Literature survey (Due: 3/15/13 - 5pm)

A 3-4 page report that surveys the prior work, and puts your proposed work in context of the related prior work.

Oral presentation on the literature survey and project description (second half of the semester)

In the second half of the semester, we will devote some part of the each class to presentations by you about your project. The presentation should focus on the related prior work and a description of the problem that you are trying to solve, rather than your results or progress.

Intermediate Progress Report (Due: 4/5/13 - 5pm)

A 5-7 page progress report.

Final Report (Due: 5/10/13 - 5pm)

Final report (about 10-15 pages) should follow a research paper format. There may be a poster presentation.