Tentalabbet

TDDE49 · 6 credits · Basic level (G2F) · Bioteknik, Datateknik

Databases and Information Security for Bioinformatics

Active · next start HT 2026

96%

passed the latest ordinary exam

TEN1 · 27 Oct 2025 · 28 students

98%

passed the ordinary exams, all sittings over the last 5 years

TEN1 · 96 students

10%

Harder than 10% of courses at basic level

Compared with 874 courses at the same level, ordinary exams over the last three academic years. 61 students.

Part of 3 programmes

Exam

TEN1 Written examination

  • 5
  • 4
  • 3
  • U

Ordinary exams

98% passed · 96 students

  • 96%28
  • 97%33
  • 100%35

Re-exams

97% passed · 34 students

  • 97%34
  • Pass the re-exam: 97% (34 students), compared with 98% (96 students) on the ordinary exam
  • Get 4 or 5: 66% (130 students)
Show small sittings (3)

Sittings with fewer than 5 students, often credit transfers or special sittings. They are not part of any figure on this page.

  • 100%1
  • 100%2
  • 33%3

Other modules

Partial exams, hand-ins and labs. They are not part of the figures at the top.

Hand-in or lab

LAB1 Laboratory work and project

  • G

Main rounds

100% passed · 122 students

  • 100%39
  • 100%28
  • 100%32
  • 100%23

Later rounds

100% passed · 36 students

  • 100%8
  • 100%7
  • 100%21
  • Pass a later round: 100% (36 students), compared with 100% (122 students) on the ordinary exam
Show small sittings (5)

Sittings with fewer than 5 students, often credit transfers or special sittings. They are not part of any figure on this page.

  • 100%1
  • 100%1
  • 100%2
  • 100%2
  • 100%4

About the course

Aim

The aim of this course is to give a thorough introduction to the practical issues underlying the design and implementation of modern biological database systems that are used in bioinformatics research. Further, basic concepts in database security are introduced.

After the completion of the course you should be able to:

  • Design relational databases for different types of example domains by first creating a conceptual scheme using the EER model and then translating this scheme into a corresponding logical schema captured in the relational data model.
  • Employ the SQL language to query and to modify relational databases, as well as to create such a database with a given relational database scheme.
  • Explain and use the terminology and the main principles of information security.
  • Apply relevant information security modeling techniques.

Content

General database management systems (DBMS). Methods for data modelling and database design (EER modeling). Database language (SQL). Security considerations of databases as a part of a larger system. Security modeling techniques. Approaches to database security (DB access control, DB encryption, DB privacy).

Examiner
Olaf Hartig
Scheduled hours
50 h
Main field of study
Bioteknik, Datateknik
Syllabus on Studieinfo ↗