| Detailed information |
| Original study plan |
Bachelor's programme Computer Science 2022W |
| Objectives |
Students are able to apply the content taught in the lecture Databases and Information Systems 1. They have gotten experience to use lecture’s content in examples that mostly are from real world. Students are well prepared for the lecture exam.
|
| Subject |
The same as in lecture Databases and Information Systems 1:
- General aspects on architecture of database systems and data models
- general steps of a database design
- ER-Model
- Relational Model including transformation of a ER-diagram into relational schemata
- Relational Algebra and SQL
- Relational Database Design
- Transactions and Multi-user-synchronization
|
| Criteria for evaluation |
Homework quality and quality of homework presentations. No exam at the end of the semester.
|
| Methods |
Students have to do homework on a weekly basis. In the class, selected students have to present their solution and this will be discussed with the whole group. Additionally, important topics from the lecture will be repeated and a look-ahead to the next homework will be given.
|
| Language |
German |
| Study material |
Presentation material form lecture Databases and Information Systems 1.
Recommended reading (will not be needed if the lectures are attended on a regular basis):
A. Kemper, A. Eickler: Datenbanksysteme Eine Einführung. 10. aktualisierte und erweiterte Auflage. Oldenbourg Verlag, 2015.
R. Elmasri, S.B. Navathe: Fundamentals of Database Systems, 7. Edition, Pearson, 2016.
|
| Changing subject? |
No |
| Corresponding lecture |
(*)INBIPUEIFS1: UE Informationssysteme 1 (3 ECTS)
|
