Course­ Manual DB2

Data Base Systems 2


PDF Course Catalog Deutsche Version: DB2

Version: 1 | Last Change: 11.09.2019 19:04 | Draft: 0 | Status: vom verantwortlichen Dozent freigegeben

Long name Data Base Systems 2
Approving CModule DB2_BaTIN
Responsible
Prof. Dr. Andreas Behrend
Professor Fakultät IME
Valid from summer semester 2022
Level Bachelor
Semester in the year summer semester
Duration Semester
Hours in self-study 60
ECTS 5
Professors
NF Büchel
Requirements Basic Course Mathematics
Basic Course Computer Science
Data Base Systems 1
Language German
Separate final exam Yes
Literature
C. Türker: SQL 1999 & SQL 2003
St. Edlich: NoSQL Datenbanken
Final exam
Details Examination questions are programming of XML parser functions for generating insert- or update-commands, definition of a XML grammar using XML scheme, transformation of a UML class diagramm in a sequence of abstract data types, transformation of abstract data types in object-relational data types and in JSON types, insert- and delete-operations in Bayer trees.
Minimum standard Programming of a XML parser functions for generating an insert- or an update-commands, Transformation of an abstract data type in the scheme of a JSON type, An insert- or a delete-operation of a key in a Bayer tree.
Exam Type EN Klausur

Learning goals
Goal type Description
Knowledge XML Grammar with XML scheme
abstract data types
object oriented data bases
object relational data bases
NoSQL data bases
Bayer trees
Expenditure classroom teaching
Type Attendance (h/Wk.)
Lecture 2
Exercises (whole course) 0
Exercises (shared course) 2
Tutorial (voluntary) 0
Special requirements
none
Accompanying material Script "Data Base Systems 2" (on the WEB-Page and as printed text); a lot of examples of XML parser programes using XML scheme and programmes for object relational data bases and for NoSQL data bases.
Separate exam No

Learning goals
Goal type Description
Skills Definition of XML schemes, of abstract data types, of data types in object-relational data bases. Programming of CRUD Operations on object-relational data bases and on NoSQL data bases. Validating parsing of JSON documents.
Expenditure classroom teaching
Type Attendance (h/Wk.)
Practical training 1
Tutorial (voluntary) 0
Special requirements
none
Accompanying material Script "Data Base Systems 2" (on the WEB-Page and as printed text); a lot of examples of XML parser programes using XML scheme and programmes for object relational data bases and for NoSQL data bases.
Separate exam No

Bei Fehlern, bitte Mitteilung an die
Webredaktion der Fakultät IME

© 2022 Technische Hochschule Köln