Database Management Systems

Messages

 

DBMS Resources and Links

SQL tutorial in hebrew a minimal requirement for the course.
practice SQL on an interactive site using JAVA SQL interpreter.
Sybase SQL Anywhere developer edition free download.
mySQL site where you may download the most popular free relational DBMS.

Lectures

These are the slides (Hebrew!!!) and Exercises (Hebrew!!!) for the course. Solutions are released as we go along.

 Lecture  Slides (ppt)  Exercises (doc)   Due 1   Due 2   Solution
 Introduction  Introduction        
 ER Model  ER model  exercise 1   2/3/2010   3/3/2010  sol 1
 Relational Model  Relational Model  exercise 2   16/3/2010   17/3/2010  sol 2
 SQL  SQL  exercise 3
 exercise 4
  23/3/2010
  13/4/2010
  24/3/2010
  13/4/2010
 sol 3
 sol 4
 Integrity Constraints  Integrity Constraints  exercise 5      sol 5
 Database Design  Database Design  exercise 6      sol 6
 Indexing and Hashing  Indexing and Hashing  exercise 7      sol 7
 Concurrency Control  Concurrency Control  exercise 8      sol 8
 Recovery  Recovery  exercise 9       sol 9
 Query Processing  Query Processing          

Further exercises

may be downloaded here

Exams

(the coding is year-semester-moed)

gideon dror