CMSC424: Database Design

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

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


Homework 1    
Homework 1 Solutions   

Homework 2    
Homework 2 Solutions    

Homework 3     RAID-6 Discussion   
Homework 3 Solutions    

Homework 4    
Homework 4 Solutions   


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 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