Apply
now
now
Data Engineering
level of course unit
BachelorLearning 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
- 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
- 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
- Date, C. (2015): SQL and Relational Theory. 3rd edition, O’Reilly Media, 2015
assessment methods and criteria
Portfolio assessment
language of instruction
Germannumber of ECTS credits allocated
4.5eLearning quota in percent
20course-hours-per-week (chw)
3planned learning activities and teaching methods
- Lecture and discussion
- Workshops with group projects
- Workshops with group projects
