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 |
Valid from | winter semester 2021/22 |
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 |
G. Vossen: Datenmodelle, Datenbanksprachen und Datenbankmanagementsysteme |
A. Kemper, A. Eickler: Datenbanksysteme |
C. Türker: SQL 1999 & SQL 2003 |
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 | EN Klausur |
Goal type | Description |
---|---|
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 |
Type | Attendance (h/Wk.) |
---|---|
Lecture | 2 |
Exercises (whole course) | 0 |
Exercises (shared course) | 2 |
Tutorial (voluntary) | 1 |
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 | No |
Goal type | Description |
---|---|
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 |
Type | Attendance (h/Wk.) |
---|---|
Practical training | 1 |
Tutorial (voluntary) | 0 |
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 | No |
© 2022 Technische Hochschule Köln