Foundations of Information Systems

B-IT: Bonn-Aachen International Center for Information Technology
Life Science Informatics 2005, 1st semester

Description

Databases systems are at the heart of modern commercial application development. Their use extends beyond this to many applications and environments where large amounts of data must be stored for efficient update and retrieval. The purpose of this course is to provide an introduction to the design and use of database systems, as well as an appreciation of the key issues in building such systems in heterogeneous and Web environments.

We begin by covering the relational model and the SQL language. We then study methods for database design, covering the entity relationship model. Finally, we touch on some advanced topics on the implementation of database systems, such as transactions and indexing.

Credits: 9
Oral exam: There will be one oral exam for the two lecture parts (foundations => bio-databases).
Time and Place: to be confirmed (most likely during 4th week of Februrary)

Prerequisites

None

Lecturers

Andreas Behrend	http://www.cs.uni-bonn.de/~behrend/
Martin Hofmann	http://www.scai.fhg.de/146.0.html?&L=0

Exercises

All exercises for the lecture part "Foundations of Information Systems" are done individually.

Lecture Schedule

Date	Slides/Homeworks Title	Remarks
24.10.05	Introduction (pdf)
26.10.05	Relational Database Systems: Part 1(pdf)
31.10.05	Relational Database Systems: Part 2(pdf)
02.11.05	Exercise Lecture
07.11.05	Mathematical Foundations: Part 1 (pdf)
09.11.05	dropped out
14.11.05	Mathematical Foundations: Part 2 (pdf)
16.11.05	Mathematical Foundations: Part 3 (pdf)	Exercise (pdf)
21.11.05	Exercise Lecture (pdf)
23.11.05	SQL (pdf)
28.11.05	Database Design (pdf)
30.11.05	Database Management Systems (pdf)

Downloads

database example for MS Access: europe.mdb
examination topics: exam_topics.pdf

Web sources

SQL for Web Nerds, by Philip Greenspun, http://philip.greenspun.com/sql/
MS Access Tuturials:
1. Michael Brydon's tutorial
  http://www.sfubusiness.ca/motmba/courses/bus756/shared/pages/tutorials.html
2. Maggie Strapland's Access page
  http://www.bris.ac.uk/is/services/software/packages/access/
3. Jakob Lindenmeyer's Access
  http://old.weboffice.ethz.ch/jl/publications/access/AccessTutorial.pdf
MS Access Homepage http://www.microsoft.com/office/access/default.asp

Literature

Abraham Silberschatz, Henry F. Korth, S. Sudarshan: "Database System Concepts", 4th edition, McGraw-Hill

Attendance

The attendance of every lecture is required for getting the permission to take the exam at the end of the course. Attendance is checked with a attendance list which students have to sign at least 5 min after the begin of a lecture. In case a lecture is missed by a student, the student is required to hand in a meaningsful excuse.