Web Business & Technology FT
Apply Icon
Apply
now

Data Engineering

level of course unit

Bachelor

Learning outcomes of course unit

The students:

- understand what database systems are used for and how they work
- know different database systems and can compare them with each other
- have a detailed understanding of relational database systems
- can depict facts of the real world as a data model
- can transform data models into a relational data structure

prerequisites and co-requisites

none

course contents

The following contents are covered in this course:

- Fundamentals of database systems and data management
- Data modeling (cardinality, conditionality, relationship types)
- Key candidates, superkeys and primary keys
- Normalization of data structures (1, 2, 3, BC normal form)
- Interaction with relational databases using SQL
- Outlook on advanced database concepts

recommended or required reading

- Watson, R. T. (2013): Data Management. Databases and Organizations. 6th edition, eGreen Press
- Date, C. (2015): SQL and Relational Theory. 3rd edition, O’Reilly Media, 2015

assessment methods and criteria

Exercise series and/or project work and/or written exam (together with ’Data Engineering Lab’ as module examination)

language of instruction

German

number of ECTS credits allocated

4.5

eLearning quota in percent

20

course-hours-per-week (chw)

3

planned learning activities and teaching methods

- Lecture and discussion
- Workshops with group projects

semester/trimester when the course unit is delivered

1

name of lecturer(s)

Prof. (FH) Michael Kohlegger

year of study

1

recommended optional program components

none

course unit code

DAT1

type of course unit

integrated lecture

mode of delivery

Compulsory

work placement(s)

not applicable