Back to selection
10909-01 - Lecture: Database Systems (6 CP)
| Semester | fall semester 2025 |
| Further events belonging to these CP |
10909-01 (Lecture) 10909-02 (Practical course) 10909-03 (Practical course) |
| Course frequency | Every fall sem. |
| Lecturers |
Ilir Fetai (ilir.fetai@unibas.ch, Assessor)
Heiko Schuldt (heiko.schuldt@unibas.ch) |
| Content | The course is a contiuation of the "Introduction of Databases" course. It features an in-depth presentation and discsusison of databases and database management systems. In particular, it will address the following topics: - Relation algebra and calculus - Advanced features of SQL - Data and information integration - Query processing in databases, index structures, query optimization - Transaction management A practical project will address topics from data integration and analysis. |
| Learning objectives | Students understand the internal structure and organization of database systems, in particular the internal processes and data structures for query processing, optimization, and transaction management. They possess both the theoretical knowledge and the practical skills to integrate several heterogeneous data sources. They will be able to apply these skills in a project. |
| Bibliography | Will be announced in the course. |
| Comments | 2021-09: removed - Computer Architecture and Operating Systems from the prerequisites |
| Weblink | Link to course web page |
| Admission requirements | You sucessfully completed the following courses or have the appropriate skills: Grundlagen der Programmierung / Erweiterte Grundlagen der Programmierung, Programmierprojekt, Algorithms and Data Structures, Introduction to Databases |
| Course application | Übung: via ADAM |
| Language of instruction | English |
| Use of digital media | No specific media used |
| Interval | Weekday | Time | Room |
|---|---|---|---|
| wöchentlich | Thursday | 14.15-16.00 | Kollegienhaus, Hörsaal 118 |
| wöchentlich | Friday | 14.15-16.00 | Alte Universität, Hörsaal -101 |
Dates
| Date | Time | Room |
|---|---|---|
| Thursday 18.09.2025 | 14.15-16.00 | Kollegienhaus, Hörsaal 118 |
| Friday 19.09.2025 | 14.15-16.00 | Alte Universität, Hörsaal -101 |
| Thursday 25.09.2025 | 14.15-16.00 | Kollegienhaus, Hörsaal 118 |
| Friday 26.09.2025 | 14.15-16.00 | Alte Universität, Hörsaal -101 |
| Thursday 02.10.2025 | 14.15-16.00 | Kollegienhaus, Hörsaal 118 |
| Friday 03.10.2025 | 14.15-16.00 | Alte Universität, Hörsaal -101 |
| Thursday 09.10.2025 | 14.15-16.00 | Kollegienhaus, Hörsaal 118 |
| Friday 10.10.2025 | 14.15-16.00 | Alte Universität, Hörsaal -101 |
| Thursday 16.10.2025 | 14.15-16.00 | Kollegienhaus, Hörsaal 118 |
| Friday 17.10.2025 | 14.15-16.00 | Alte Universität, Hörsaal -101 |
| Thursday 23.10.2025 | 14.15-16.00 | Kollegienhaus, Hörsaal 118 |
| Friday 24.10.2025 | 14.15-16.00 | Kollegienhaus, Hörsaal 120 |
| Thursday 30.10.2025 | 14.15-16.00 | Kollegienhaus, Hörsaal 118 |
| Friday 31.10.2025 | 14.15-16.00 | Alte Universität, Hörsaal -101 |
| Thursday 06.11.2025 | 14.15-16.00 | Kollegienhaus, Hörsaal 118 |
| Friday 07.11.2025 | 14.15-16.00 | Kollegienhaus, Hörsaal 001 |
| Thursday 13.11.2025 | 14.15-16.00 | Kollegienhaus, Hörsaal 118 |
| Friday 14.11.2025 | 14.15-16.00 | Alte Universität, Hörsaal -101 |
| Thursday 20.11.2025 | 14.15-16.00 | Kollegienhaus, Hörsaal 118 |
| Friday 21.11.2025 | 14.15-16.00 | Alte Universität, Hörsaal -101 |
| Thursday 27.11.2025 | 14.15-16.00 | Kollegienhaus, Hörsaal 118 |
| Friday 28.11.2025 | 14.15-16.00 | Dies Academicus |
| Thursday 04.12.2025 | 14.15-16.00 | Kollegienhaus, Hörsaal 118 |
| Friday 05.12.2025 | 14.15-16.00 | Alte Universität, Hörsaal -101 |
| Thursday 11.12.2025 | 14.15-16.00 | Kollegienhaus, Hörsaal 118 |
| Friday 12.12.2025 | 14.15-16.00 | Alte Universität, Hörsaal -101 |
| Thursday 18.12.2025 | 14.15-16.00 | Kollegienhaus, Hörsaal 118 |
| Friday 19.12.2025 | 14.15-16.00 | Alte Universität, Hörsaal -101 |
| Monday 12.01.2026 | 13.00-15.00 | Biozentrum, Maurice E. Müller Saal U1.111 |
| Friday 30.01.2026 | 08.00-18.00 | Biozentrum, Hörsaal U1.101 |
| Modules |
Modul: Computational Methods (Bachelor's Studies: Computational Sciences) Modul: Computational Methods (Bachelor's Studies: Computational Sciences) Modul: Computational Methods (Bachelor's Studies: Computational Sciences) Modul: Computational Methods (Bachelor's Studies: Computational Sciences) Modul: Computational Methods (Bachelor's Studies: Computational Sciences) Module: Applications and Related Topics (Bachelor's degree subject: Computer Science) Module: Computational Sciences II (Bachelor's Studies: Computational Sciences (Start of studies before 01.08.2023)) Module: Distributed Systems (Bachelor's Studies: Computer Science) Module: Technology Field (Master's Studies: Business and Technology) |
| Assessment format | continuous assessment |
| Assessment details | The final grade will be determined by a written exam (2/3) and the grade for the data integration project (1/3). Written examination: duration 120 min. Expected Date: Monday, January 12, 2026, 01:00 pm - 03:00 pm, Room: Bio-/PHarmazentrum, M.E. Müller Saal U1.111. Admission to the examination: at least 50% of the points from the exercises are required. Date of the final project presentations: Friday, January 30, 2026, room: Bio-/Pharmazentrum, Hörsaal U1.101. Further details on the data integration project and the final presentation will be given during the lecture. |
| Assessment registration/deregistration | Reg.: course registration, dereg: cancel course registration |
| Repeat examination | no repeat examination |
| Scale | 1-6 0,5 |
| Repeated registration | as often as necessary |
| Responsible faculty | Faculty of Science, studiendekanat-philnat@unibas.ch |
| Offered by | Fachbereich Informatik |