Course

DB1 - Data Base Systems 1

PDF Course Catalog Deutsche Version: DB1

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

Long name Data Base Systems 1
Approving CModule DB1_BaTIN
Responsible
Prof. Dr. Andreas Behrend
Professor Fakultät IME
Level Bachelor
Semester in the year winter semester
Duration Semester
Hours in self-study 60
ECTS 5
Professors
NF Büchel
Requirements Basic Course Mathematics
Basic Course Computer Science
Language German
Separate final exam Yes
Literature
G. Vossen: Datenmodelle, Datenbanksprachen und Datenbankmanagementsysteme
A. Kemper, A. Eickler: Datenbanksysteme
C. Türker: SQL 1999 & SQL 2003
Final exam
Details
Examination questions are Entity Relationship Modeling, Mapping of a entity relationship model to a database scheme, SQL, development of a JDBC programe, XML document type defintion
Minimum standard
Programming of simple SQL statements (INSERT, UPDATE, DELETE, SELECT)
Programming of a complex SQL application, which is embedded in a java programe
Exam Type
Examination questions are Entity Relationship Modeling, Mapping of a entity relationship model to a database scheme, SQL, development of a JDBC programe, XML document type defintion

Learning goals
Knowledge
General Data Base Model
Relational data base system
Structured Query Language
Embedded SQL in Java (JDBC)
Specification and design of data bases
Entity Relationship Model
Normal forms of a relational data base
XML and data bases
Document type definition
Expenditure classroom teaching
Type Attendance (h/Wk.)
Lecture 2
Exercises (whole course) 0
Exercises (shared course) 2
Tutorial (voluntary) 1
Special literature
keine/none
Special requirements
none
Accompanying material
Script "Data Bases" (on the WEB-Page and as printed text); a lot of examples of SQL- and JDBC-programes, of ERD, of XML- and DTD-documents, of UML-documents for data base specification on the WEB-Page.
Separate exam
none

Learning goals
Skills
Implementation of a data base with several tables, which is specified in a requirement analysis; programming of embedded complex SQL code in JAVA; entity relationship modeling; definition of an DB/XML-interface with a document type definition
Expenditure classroom teaching
Type Attendance (h/Wk.)
Practical training 1
Tutorial (voluntary) 0
Special literature
keine/none
Special requirements
none
Accompanying material
Script "Data Bases" (on the WEB-Page and as printed text); a lot of examples of SQL- and JDBC-programes, of ERD, of XML- and DTD-documents, of UML-documents for data base specification on the WEB-Page.
Separate exam
none

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

© 2022 Technische Hochschule Köln