Assignments and Homeworks

All assignments (homeworks and project) must be submitted electronically via the class homework submission site: Submission site

Assignment #0: Sample Submission
Due Date: noon, Tuesday, Jan 17, 2012
Handout: Assignment in PDF   (released on Jan 12)

Assignment #1: SQL
Due Date: 11:59 pm, Tuesday, Feb. 14, 2012
Handouts: Assignment in PDF   (released on Jan. 31)
Starting with Oracle in PDF   (released on Jan. 31)
Sample data: in plain text   (released on Jan. 31)
ticketGen: ticket generator script in perl   (released on Jan. 31)
Sample Solution: in hw1-db.sql   and hw1-query.sql   (posted on Feb. 17)

Assignment #2: Physical Storage & Indexing
Due Date: 1:00 pm, Saturday Feb. 25, 2012
Handouts: Assignment in PDF   (released on Feb. 17)
Sample Solution: in PDF   (posted on Feb. 26)

Assignment #3: Term Project
Due Date 1 (team formation): 11:59 pm, Thursday, March 17, 2012
Due Date 2 (Design): 11:59 pm, Thursday, March 29, 2012 (New)
Due Date 3 (Prototype): 11:59 pm, Monday, April 23, 2012 (New)
Handouts: Assignment in PDF   (released on Mar. 19)                        
Sample data files: in ZIP   (released on Mar. 19)

Assignment #3: Serializability
Due Date: 11:59 pm, Thursday Mar. 29, 2012
Handouts: Assignment in PDF   (released on Mar. 20)
Sample Solution: in PDF   (posted Apr. 16, 2012)