CMSC424: Database Design

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


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

Homeworks:

Homework 1    
Homework 1 Solutions   


Homework 2    
Homework 2 Solutions    


Homework 3     RAID-6 Discussion   
Homework 3 Solutions    


Homework 4    
Homework 4 Solutions   



Midterms:

Practice Midterm 1    
Practice Midterm 1 Solutions   


Midterm 1 Solutions   


Practice Midterm 2    
Practice Midterm 2 Solutions   


Midterm 2 Solutions   


Practice Final    
Practice Final Solutions   



Project:

Project Description     Phase 1 Due Date - Oct 22, 2009

Project Resources    

Programming Assignment:

Description     Due November 12, 2009; ToyRDBMS Code    

Hints in Oracle    


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    

...