252-0060-00L Introduction to Database Systems
NEWS:
- 10. September - Repeated Exam Grades are available here.
- Exams can be reviewed on Wednesday, 16. Sept. and Monday 21 Sept. (Please note the new date) between 2 - 4 pm in CAB F 56.2.
- 11. June - Exam Grades are available here.
- Exams can be reviewed on Wednesday, 17. June; Friday, 19. June; and Thursday, 2. July, between 2 - 4 pm in CAB F 56.2.
Contents
This lecture presents the basic tools required for the development of database applications. The focus is on relational database systems and applications that can be built using relational database technology.
The following topics will be covered: E/R and UML modelling, the relational data model, relational design theory (normal forms), SQL, database intregrity, security, a brief introduction to transactions and data warehousing (OLAP).
Schedule (2V1U)
Lecture:
Wednesday 10-12 HG E 3
Exercise Groups:| Monday | 1pm-2pm | HG F 26.1 |
| 1pm-2pm | IFW A 34 |
|
| 1pm-2pm | RZ F 21 |
|
| 4pm-5pm |
CAB G 52 |
|
| Tuesday | 4pm-5pm | IFW A 34 |
| Wednesday | 1pm-2pm | CHN G 22 |
Exam
Date: 10.06.2009Time: 10.00-11.00
Place: HG D 1.1 / D 1.2
It is a closed book exam
Course Material
Lecture Notes
- Introduction [PPT] [PDF]
- Daten Modellierung [PPT] [PDF]
- Relationales Modell [PPT] [PDF]
- SQL [PPT] [PDF]
- Constraints [PPT] [PDF]
- Entwurfstheorie [PPT] [PDF]
- Transaktionen [PPT] [PDF]
- Sicherheit
[PPT] [PDF]
Exercise Sheets
- Find your exercise group here
- Exercise 1
- Exercise 2
- Exercise 3
- Exercise 4
- Easter Exercise
- Exercise 5
- Exercise 6
- Exercise 7 and 8
Project
- Project description
- Produktgruppen specification
(Produktgruppen.xls)
- Some
sample data (big! >10MB)
- An JSP project example to get started
- An alternative servlet project example
- For those who like to work with tools: Receive a free SQL Manager license for this course.
- An OpenSource alternative to SQL Manager: SQuirreL
- Links to OpenSource-DB's: MySQL or PostgreSQL
Goal
Good understanding of relational database systems. Ability to use database systems to develop database applications.
Lecturer
Language
German
Literature
Kemper, Eickler: Datenbanksysteme: Eine Einführung. Oldenbourg Verlag, 6. Auflage, 2006
Elmasri, Navathe: Grundlagen von Datenbanksystemen (Ausgabe Grundstudium). Pearson Studium, 3. Auflage, 2005.



