Back to selection
10909-01 - Lecture: Databases (8 CP)
| Semester | fall semester 2023 |
| Further events belonging to these CP |
10909-01 (Lecture) 10909-02 (Practical course) |
| Course frequency | Every fall sem. |
| Lecturers | Heiko Schuldt (heiko.schuldt@unibas.ch, Assessor) |
| Content | The course provides a in -depth presentation and discsusison of databases and database management systems. In particular, it will address the following topics: - Database design - Data models and 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 know how to create a database and how to query it. They 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, Algorithmen und Datenstrukturen |
| Course application | Übung: via ADAM |
| Language of instruction | English |
| Use of digital media | No specific media used |
| Interval | Weekday | Time | Room |
|---|---|---|---|
| wöchentlich | Wednesday | 10.15-12.00 | Alte Universität, Hörsaal -101 |
| wöchentlich | Thursday | 14.15-16.00 | Kollegienhaus, Hörsaal 115 |
Dates
| Date | Time | Room |
|---|---|---|
| Wednesday 20.09.2023 | 10.15-12.00 | Alte Universität, Hörsaal -101 |
| Thursday 21.09.2023 | 14.15-16.00 | Kollegienhaus, Hörsaal 115 |
| Wednesday 27.09.2023 | 10.15-12.00 | Alte Universität, Hörsaal -101 |
| Thursday 28.09.2023 | 14.15-16.00 | Kollegienhaus, Hörsaal 115 |
| Wednesday 04.10.2023 | 10.15-12.00 | Alte Universität, Hörsaal -101 |
| Thursday 05.10.2023 | 14.15-16.00 | Kollegienhaus, Hörsaal 115 |
| Wednesday 11.10.2023 | 10.15-12.00 | Alte Universität, Hörsaal -101 |
| Thursday 12.10.2023 | 14.15-16.00 | Kollegienhaus, Hörsaal 115 |
| Wednesday 18.10.2023 | 10.15-12.00 | Alte Universität, Hörsaal -101 |
| Thursday 19.10.2023 | 14.15-16.00 | Kollegienhaus, Hörsaal 115 |
| Wednesday 25.10.2023 | 10.15-12.00 | Alte Universität, Hörsaal -101 |
| Thursday 26.10.2023 | 14.15-16.00 | Kollegienhaus, Hörsaal 115 |
| Wednesday 01.11.2023 | 10.15-12.00 | Alte Universität, Hörsaal -101 |
| Thursday 02.11.2023 | 14.15-16.00 | Kollegienhaus, Hörsaal 115 |
| Wednesday 08.11.2023 | 10.15-12.00 | Alte Universität, Hörsaal -101 |
| Thursday 09.11.2023 | 14.15-16.00 | Kollegienhaus, Hörsaal 115 |
| Wednesday 15.11.2023 | 10.15-12.00 | Alte Universität, Hörsaal -101 |
| Thursday 16.11.2023 | 14.15-16.00 | Kollegienhaus, Hörsaal 115 |
| Wednesday 22.11.2023 | 10.15-12.00 | Alte Universität, Hörsaal -101 |
| Thursday 23.11.2023 | 14.15-16.00 | Kollegienhaus, Hörsaal 115 |
| Wednesday 29.11.2023 | 10.15-12.00 | Alte Universität, Hörsaal -101 |
| Thursday 30.11.2023 | 14.15-16.00 | Kollegienhaus, Hörsaal 115 |
| Wednesday 06.12.2023 | 10.15-12.00 | Alte Universität, Hörsaal -101 |
| Thursday 07.12.2023 | 14.15-16.00 | Kollegienhaus, Hörsaal 115 |
| Wednesday 13.12.2023 | 10.15-12.00 | Alte Universität, Hörsaal -101 |
| Thursday 14.12.2023 | 14.15-16.00 | Kollegienhaus, Hörsaal 115 |
| Wednesday 20.12.2023 | 10.15-12.00 | Alte Universität, Hörsaal -101 |
| Thursday 21.12.2023 | 14.15-16.00 | Kollegienhaus, Hörsaal 115 |
| Monday 05.02.2024 | 09.00-18.00 | Alte Universität, Hörsaal -101 |
| Modules |
Modul: Applications and Related Topics (Bachelor's degree subject: Computer Science) 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: 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 180 min. Tentative date and locaton: Tuesday, January 16, 2024, 01:00 pm - 04:00 pm, Biozentrum, Maurice E. Müller Saal. Admission to the examination: at least 50% of the points from the exercises are required. Tentative date/location of the final project presentations: Friday, February 5, 2024, Alte Uni, HS -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 |