 |
| Detailed information |
| Original study plan |
Bachelor's programme Computer Science 2025W |
| Learning Outcomes |
Competences |
| Students can independently analyze a given aspect of the real world with regard to the information it contains, create an ER diagram, derive correct relational database schemas and improve them so that they are redundancy-free and do not allow anomalies in the data. In addition, they are proficient in relational algebra as well as the database manipulation and query language SQL and understand data models in general, the structure of database management systems and how transactions are implemented in such systems.
|
|
| Skills |
Knowledge |
Students can
- Create and assess an ER diagram from a given real-world situation (K5, K6)
- Derive relational database schemas from an ER diagram (K3)
- Formulate queries to relational schemas in relational algebra (K6)
- Formulate data definitions, manipulations and complex queries in SQL (K3, K4, K5, K6)
- Recognize functional dependencies in a relational database schema and derive key candidates from them (K3, K4, K5)
- Recognize multi-valued dependencies in a relational database schema (K4)
- Evaluate a relational database schema and decompose it into better schemas (K5, K6)
- Apply the algorithms for decomposition into 3NF, BCNF and 4NF and evaluate the results (K3, K4, K5)
- Recognize potential errors in an unprotected multi-user operation (K5)
- Apply simple locking protocols (K3)
|
- Architecture and functionality of database management systems
- Overview of data models in conceptual and logical database design.
- Database design in general
- Entity-Relationship Model
- Relational data model
- Relational algebra
- SQL
- Relational database design: functional and multivalued dependencies, keys, normal forms (1NF, 2NF, 3NF, BCNF, 4NF), decomposition algorithms.
- Understanding of multi-user operation and transactions.
- Overview of NoSQL database management technologies and current research areas in the field of database and information systems
|
|
| Criteria for evaluation |
Written exam at the end of the semester.
|
| Methods |
Standard lectures with study materials (slides) provided via KUSSS.
|
| Language |
German |
| Study material |
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 |
| Further information |
This lecture and the corresponding exercise form an inseparable didactic unit. The learning outcomes described here are achieved through the interaction of the two courses.
|
| Corresponding lecture |
(*)INBIPVOIFS1: VL Informationssysteme 1 (3 ECTS)
|
|
