M1106-CMS119
Database Management
|
|
Module Owner: |
N.N. |
Displayed in timetable as: |
CMS-COR-DBM |
Duration: |
1 |
Number of electives: |
0 |
Credits: |
5,0
|
Start Semester: |
WiSe 2020/21 |
Lecturer Responsible |
Prof. Dr. Wolfgang Lehner
wolfgang.lehner@tu-dresden.de |
Qualification Goals |
Upon completion of this module, students master the fundamental techniques for building transactional information systems. They will learn the core concepts of ER modelling and the relational database model including SQL and, in particular, master the central components of the database system architecture such as buffer management, recovery and the query optimiser. |
Content |
Basics of database systems, SQL, database programming, database design, relational data models, ER diagrams, normal forms, database architecture, query optimisation, buffer management. |
Forms of Teaching and Learning |
The module consists of 2 weekly lectures and 2 practicals, as well as independent study. |
Prerequisites for Participation |
Fundamental knowledge in the basics of computer databases as well as fundamental knowledge of computer programming at bachelor level is required. Students can prepare for the module with the following literature:
- Lemahieu, W.; Broucke, S.V.; Baesens, B.: “Principles of Database Management”, 2018
- Elasmri, R.; Navathe, S.: “Fundamentals of Database Systems” (5th Edition)
- Ramakrishnan, R.; Gehrke, J.: “Database Management Systems”. McGraw-Hill, 2002
- Weikum, G.; Vossen, G.: „Transactional Information Systems“. Morgan Kaufmann, 2001
- J. Hoffer:, M. Prescott, H. Topi: „Modern Database Management” (9th Edition).
|
Applicability |
In the Computational Modelling and Simulation Master's programme, the module is one of ten compulsory elective modules (for students of Computational Life Science: nine), of which three must be chosen. |
Prerequisites for the Assignment of Credit Points |
The credit points are awarded if the module examination is passed. The module examination consists of a 90-minute written examination. If there are fewer than 10 students registered at the end of the registration period, the written examination can be replaced by an oral examination as an individual examination lasting 30 minutes; if this is the case, this will be announced to the registered students at the end of the registration period. |
Credit Points and Grades |
5 credit points can be earned through completion of this module. The module grade corresponds to the examination grade. |
Frequency of Offer |
The module is offered in each winter semester. |
Workload |
The workload is 150 hours in total. |
Duration of Module |
The module takes one semester to complete. |
Module Number Module Handbook TU Dresden |
CMS-COR-DBM |