Database Systems (Spring 2011) - Assignments
Previous Tests
For your requests, here are the test from previous years:
Homework Assignments
- There are 2 homework assignments to submit (besides the project)
- Homework will be submitted in pairs (2 students)
- All homework should be submitted "HARD-COPY" (i.e. not by email) to Rubi's mailbox (370 on Schreiber's second floor) before due date
- A third assignment will be published with its solution near the end of the course
| Assignment | Topic | Distribution Date | Due Date | Solution |
|---|---|---|---|---|
| Homework 1 | SQL | 08/03 | 22/03 | -- |
| Homework 2 | Database design, Views | 03/05 | 17/05 | -- |
| Homework 3 | Execution, Optimization | -- | -- | -- |
Project
The project will include designing and coding of a database system. Its goal is to give a "hands on" experience to some of the topics discussed in class regarding design, development, management, and maintenance. It will be developed by using one of the leading database management systems (DBMS), which will be selected during the course.
- Project subject will be disclosed on project distribution
- The project will be developed in groups of 4 students
- The project will be constructed by
two phasesa single phase
| Phase | Distribution Date | Due Date | Files |
|---|---|---|---|
| Project Phase 1 | 29/03 | 10/06 | Project Presentation Project Details Project examination form Project grade guide |
Additional Notes
- In general, out-of-the-box thinking, originality and common-sense are key attributes in the project as well as the home assignments and the final exam, therefore they will be rewarded accordingly (bonus points)
- Assignments are due at midnight on the due date, unless otherwise announced. Barring usual circumstances, late homework will not be accepted
- Both the assignments and the project will have a 5 points penalty for each late day of submission!