CMSC424: Database Design

Prof. Amol Deshpande;    CSIC 1121;    Tue-Thur 12:30pm-1:45pm


[Home] [Schedule] [Project/Assignments/Homeworks]

Programming Assignment:

Description     Due November 12, 2009; ToyRDBMS Code    

Test Queries and Outputs    
My HashJoinOperator Code    


Hints in Oracle    

Midterms:

Practice Midterm 1    
Practice Midterm 1 Solutions   


Midterm 1 Solutions   


Practice Midterm 2    
Practice Midterm 2 Solutions   


Midterm 2 Solutions   



Homeworks:

Homework 1    
Homework 1 Solutions   


Homework 2    
Homework 2 Solutions    


Homework 3     RAID-6 Discussion   
Homework 3 Solutions    

Project:

Project Description     Phase 1 Due Date - Oct 22, 2009

Project Resources    


SQL Assignment:

This assignment is to be done individually.

There are two parts to this assignment. First one is Due Sept 29 (the answers will be provided that day), and the second one is Due Oct 6.
Schema Information, Description of the Database, and Queries    

SQL Script to Populate the Database    
Perl Evaluation Script    



Part 1 Solutions    

Part 2 Solutions    

...