 |
| Detailed information |
| Pre-requisites |
(*)Erwartete Vorkenntnisse: Modul Einführung in die Softwareentwicklung aus Fach Grundlagen der Informatik ODER Modul Einführung in die Software Entwicklung mit Python
|
| Original study plan |
Bachelor's programme Business Informatics 2025W |
| Learning Outcomes |
Competences |
| Students are familiar with the basics of data modeling and can design and use database systems using scientific methods.
|
|
| Skills |
Knowledge |
- LO2: Students can explain architectural concepts of database systems and justify their use (K2).
- LO3: They understand the basic concepts for the design process of database systems and can implement database systems on the basis of a requirements specification (K3).
- LO4: They are able to carry out the design process with concrete data models (K3).
- LO5: They are proficient in query languages in order to define, query and manipulate data interactively and from (web) applications (K3).
- LO6: They can explain problems and techniques of access protection (K2).
|
LO1: Reasons for using database systems, architecture of database management systems; database design process: conceptual, logical and physical design; conceptual data models: entity-relationship model and UML; logical data models: relational and object-relational data model; physical data organization: index structures; database definition and database access with interactive query languages, database access from (web) applications, access protection in database systems.
|
|
| Criteria for evaluation |
Midterm- and final exam
|
| Methods |
The topics covered in the lecture are deepened by working on practical examples in the exercise. In the case of SQL, JDBC and WebML, the examples are worked on by the students under the guidance of the instructor using suitable tools in the laboratory or via the Internet. Exercises are assigned for each subject area, which are completed by the students in self-study. The exercises are completed online with the help of the electronic tutoring system "eTutor". The eTutor system assists students in finding and correcting errors in the editing process and automatically evaluates the solution. In addition, the automatic assessments are checked by student assistants. The final assessment is carried out by the course instructor.
|
| Language |
German |
| Study material |
Basic literature:
- Ceri, S.; Fraternali, P.; Bongio, A.; Brambilla, M.; Comai, S.; Matera, M.: Designing Data-Intensive Web Applications. Morgan Kaufmann Publishers, 2003.
- Elmasri, R.; Navathe, S.: Grundlagen von Datenbanksystemen. Pearson Studium, in der aktuellen Auflage.
- Garcia-Molina, H.; Ullman, J. D.; Widom, J.: Database Systems: The Complete Book. Prentice Hall, in der aktuellen Auflage.
- Kemper, S.; Eickler, A.: Datenbank Systeme: Eine Einführung. Oldenbourg Verlag, in der aktuellen Auflage.
- Pernul, G.; Unland, R.: Datenbanken im Unternehmen. Analyse, Modellbildung und Einsatz. Oldenbourg Verlag, 2003.
- Rumbaugh, J.; Jacobson, I.; Booch, G.: The Unified Modeling Language Reference Manual. Addison-Wesley, in der aktuellen Auflage.
- Saake, G.; Sattler, K.: Datenbank & Java. JDBC, SQLJ, ODMG und JDO. Dpunkt Verlag, in der aktuellen Auflage.
Additional literature is announced every term.
|
| Changing subject? |
No |
| Further information |
VL and UE Data Modeling form an inseparable didactic unit. The learning outcomes described are achieved through the interaction of both.
|
| Earlier variants |
They also cover the requirements of the curriculum (from - to)
1WBWDMV: VL Data Modeling (2002W-2014S)
|
|
