Database Systems
Winter 2007-2008
Course Information
More details during the semester will be published in the course forum
There
are 2 homework assignments to submit (besides the project). Homework will be
submitted in pairs (2 students)
A third homework (not for submission) with its answers, will be given to help
in preparing for the exam for part of the material not covered by previous
assignments
Notes:
All homework should be submitted via Email to JackAssa@post.tau.ac.il before due
date. Please send emails with delivery receipt so that you’ll get
confirmation it was delivered.
|
Assignment |
Topic |
Distribution Date |
Due Date |
Answers |
|
SQL |
5/2 |
19/2 |
To be posted in the course forum |
|
|
Database design, Views |
11/3 |
25/3 |
To be posted in the course forum |
|
|
To be posted |
25/3 |
Not for submission |
To be posted in the course forum |
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.
Project subject will be disclosed on project distribution.
Projects will be developed by using one of the leading database management
systems (DBMS), which will be selected during the course.
Notes:
The project will be developed in groups of 4 students.
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).
|
Phase details |
Distribution |
Due |
|
26/2 |
25/3 |
Lecture Slides (more to be added)
· Introduction to Database Systems , basic SQL
· Introduction to DB programming
· Views(cont.), Constraint and Programming
· Database design, Design (cont.)
· Functional Dependencies, Relational algebra
· DB internals , Storage and indexing