Internet Technology

Database Design

Integrated course, 4.00 ECTS

 

Course content

The course gives a systematic approach to relational database design in theory and practice (design tools and DDL).
The emphasis lies on the conceptual and logical design, including the definition of semantic conditions towards the resulting data structures. Overview of requirements engineering and physical design. In addition, systematic introduction to function and operation of database management systems (including transaction) as well as
related operations (DDL + CRUD commands etc.) All topics will be applied in practice in the accompanying tutorial.

Learning outcomes

On completion of the course, students have fundamental knowledge about principles of creating and developing software systems and about principles of classic RDBMS.

Recommended or required reading and other learning resources / tools

Books Ian Sommerville, Software Engineering, 10th International edition, 2015; Frederick P. Brooks, The Mythical Man-Month, 1995;
Schildt, H. (2014). Java: The complete reference. New York: McGraw-Hill Education.
Kemper A. Eickler A., Datenbanksysteme; Vossen, G., Datenmodelle, Datenbanksprachen und Datenbankmanagementsysteme;
Professional Journals: -

Mode of delivery

2 ECTS Lecture, 2 ECTS Tutorial

Prerequisites and co-requisites

None

Assessment methods and criteria

Final Exam, Tutorial: Continuous Assessment