Department of Computer Science

In this course the we will cover some of the data models and database languages used in databases today. Relational algebra and database design will be covered to give a basis for database work. In order to better understand the functionality of database systems concurrency management and distributed databases will be looked at. The exercises will use Java (and possibly PHP) as the programming language to create database applications.

Schedule

The lectures will be held on Wednesdays and Thursdays in room T/2D106 from 14-16. The lectures begin on the 11.9.2002. The lectures are held by Ramin Miraftabi.

The exercises will begin on the following week. The exersises are held by Petri Gerdt. The times and places are as follows:

• Wednesday 12-14 T/B180 (in English)
• Thursday 12-14 T/B179 (in Finnish)
• Tuesday 16-18 T/B2D106/2 (in Finnish, held by Ramin) begins at 16.00 exactly (because of the locks).

No lecture on 17.10.!

The final scores are now available.

The exam dates are listed below and are held during lecture times in a room that will be announced later.:

• 16.10. in T/B2D106 from 14.00 to 16.00, results (intranet only)
• 27.11. in T/B2D106 from 14.00 to 16.00, results (intranet only)

Exercises

• Exercise 1
• Exercise 2, Answers
• Exercise 3
• Exercise 4, Example Data, Results
• Exercise 5
• Exercise 6
• Exercise 7, Results
• Exercise 8, Results
• Exercise 9
• Exercise 10

The final lab scores are finally available (intranet only). Contact Ramin or Petri if you have any questions.

References

• Entity-Relationship diagrams
• SQL Tutorial
• The eXtensible Markup Language (XML)

Last modified 11.12.2002/ramin