Content, progress and pedagogy of the module

Disclaimer.
This is an English translation of the module. In case of discrepancy between the translation and the Danish version, the Danish version of the module is valid.

PURPOSE
The course focuses on the use of relational database systems (RDBMS) to store large, complex amounts of data. Querying the RDBMS made via the language SQL is a central element. The course looks at how SQL is used from application code implemented in programming languages ​​such as C#, Rust or Python. Basic software architecture is introduced for the design of larger systems and their division into subsystems

Learning objectives

Knowledge

• issues linked to the development of a solid software architecture 
• the relational data model 
• graphic models for visualizing a database design, e.g. ER diagrams or UML class diagrams
• the query language SQL to modify the contents of and query larger databases  data integrity and data integration 
• the transaction concept 
• optimization of databases including indexing 
• access to data from application code

Skills

• describe fundamental concepts and definitions within software architecture 
• apply principles for dividing a system into subsystems 
• apply architecture patterns dedicated to subsystem development 
• design, evaluate and communicate graphical data models 
• query non-trivial databases with many tables  use transactions to update data 
• query and update data from application code in a language such as C#, Rust or Python

Competences

• assess the software architecture of subsystems 
• evaluate a visual model for a database

Type of instruction

Extent and expected workload

The student is expected to spend 30 hours per ECTS, which for this activity means 150 hours.

Exam

Exams

Additional information