Assignments and Homeworks

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

Assignment #1: Sample Submission
Due Date: 11:59 pm, Friday, January 13, 2017
Handout: in PDF   (released on Jan. 6)

Assignment #2: SQL
Due Date: 11:59 pm, Tuesday January 31, 2017
Handouts: Assignment in PDF  
Starting with Oracle in PDF   (released on Jan. 21) Updated
Sample data: in plain text   (released on Jan. 17)
ticketGen: ticket generator script in perl script text   (released on Jan. 17)
Sample Solution: part 1 (Schema) in Text, part 2 (Queries) in Text   (released Feb. 6)

Participation HW #1 (Optional)
Due Date: 11:59 pm, Thursday February 2, 2017
Handouts: Assignment in PDF  

Assignment #3: Physical Organization & Relational Algebra Review
Due Date: 11:59 pm, Friday February 17, 2017
Handouts: in PDF   (released on Feb. 9)
Sample Solution: in PDF   (released Feb. 21)

Assignment #4: Query Processing & Optimization
Due Date: 11:59 pm, Tuesday March 28, 2017 New
Handouts: Assignment in PDF   (released on Mar. 13)

Term Project
Due Date 1 (team formation): 5:00 pm, Tuesday, Mar 21, 2017
Due Date 2 (Design): 11:59 pm, Friday, Apr 7, 2017 New
Due Date 3 (Prototype): 11:59 pm, Thursday, Apr. 27, 2017
Demos: 9:00am-5:00pm, Friday, Apr. 28, 2017
Handouts: in PDF   (released on Mar. 18)
Sample data files: in ZIP   (release Mar. 18)

Assignment #5: Recovery & Concurrency Control
Due Date: 11:59 pm, Sunday April 23, 2017
Handouts: Assignment in PDF   (released on Apr. 11)
Sample Solution: in PDF   (released Apr. 24)