Databases
2025/2026- Purpose and learning objectives
The subject element contains and deals with the selection and use of database types appropriately in relation to different application domains, including data-driven decision support. The focus is also on development towards large databases, including redesign and operation optimization.
KnowledgeThe student has knowledge of:
Skills
• different database types and the underlying models
• the storage organisation and query execution of a specific database system
• optimization possibilities of a specific database system – including advantages and disadvantages
• database-specific security issues and their solutions
• concepts and issues related to scaling and data complexity
• the specific issues raised by many simultaneous transactions, including in connection with distributed databases
• principles for accessing data from applicationsThe student can:
Competences
• analyse the use domain for the choice of database type
• transform logical data models into physical ones in different database types
• perform the optimization of databases
• manage simultaneous transactions in a specific database system
• use the facilities and programming options provided by a modern DBMS
• use up-to-date tools to access dataThe student can:
• familiarize yourself with various database technologies
• facilitate collaboration for data support of business objectives - Type of instruction
The teaching is organised as a variation between class teaching, guest lecturing, company visits, group project work and individual work. The learning is most often problem-based and cross-disciplinary and always practise-oriented. In addition to learning the subject, the student will gain the competences to work individually and in collaboration with others.
The common aim of the activities is always to set clear intended learning objectives. - Subject/module requirement for
participation
Equipment needed to participate
Windows PC, Mac or Linux
- min 8 GB RAM (16 GB RAM preferably)
- 200 GB available disk space
- CPU with virtualisation hardware (usually available in most modern CPUs)
- 15,6” screen or bigger is recommended - Exam
The learning outcomes of the exam are identical with the learning outcomes of the subject(s)/modul(es)
Prerequisites for access to the examinationDuring the Database module, the student will be given two mandatory assignments and an exam report.
To attend the exam, the student will have to write a report reflecting upon different topics related to the course and hand it in Wiseflow.Exam in one or more subjectsSubject/module is tested standaloneType of examCombined written and oral examinationThe exam is individual, but the students can work on their project report and product in groups.Formal requirementsNumber of stud Number of pages
2 Max 25
3 Max 30
4 Max 35Individual exam or group examIndividualExam languagesEnglishDurationPresentation - max 10 min.
Examination- max. 15 min.
Grading - 5 min.
Total - 30 min.Rules regarding exam aidsComputer is allowedAvailable exam aidsProjectorType of evaluation7-point grading scaleExaminersExternal censureExam criteriaA single grade is given based on a total assessment of the entire written product and the oral examination. - Preliminary literature list
This is a preliminary literature list. A final literature list will be provided in connection with study start.Course materials available to the students via Internet.
- Additional information
Some classes may take place online.
In the subject Databases you will receive 69 hours of instruction, which corresponds to 92 lessons (1 lesson = 45 min.) and 25% of your total workload for the subject.
The teaching primarily consists of the following activities: classroom teaching, external lectures, group work, Online teaching.
The preparation primarily consists of the following activities: reading your own notes, reading the curriculum, group work, project work.
Read about KEAs Study Activity Model
*KEA can deviate from the number of hours if this is justified by special circumstances