Tentalabbet

TDDD12 · 6 credits · Basic level (G2F) · Informationsteknologi, Datateknik, Datavetenskap, Programmering

Database Technology

Active · next start VT 2027

73%

passed the latest ordinary exam

TEN1 · 29 May 2026 · 119 students

74%

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

TEN1 · 510 students

76%

Harder than 76% of courses at basic level

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

Part of 9 programmes

Exam

TEN1 Written examination

  • 5
  • 4
  • 3
  • U

Ordinary exams

74% passed · 510 students

  • 73%119
  • 50%98
  • 80%103
  • 84%86
  • 85%104

Re-exams

48% passed · 148 students

  • 47%30
  • 40%30
  • 23%30
  • 64%11
  • 67%6
  • 31%13
  • 78%9
  • 100%10
  • 67%9
  • Pass the re-exam: 48% (148 students), compared with 74% (510 students) on the ordinary exam
  • Get 4 or 5: 38% (658 students)
Show small sittings (1)

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

  • 0%2

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

  • G

Main rounds

100% passed · 472 students

  • 100%46
  • 100%63
  • 100%40
  • 100%52
  • 100%36
  • 100%65
  • 100%73
  • 100%97

Later rounds

100% passed · 16 students

  • 100%5
  • 100%6
  • 100%5
  • Pass a later round: 100% (16 students), compared with 100% (472 students) on the ordinary exam
Show small sittings (25)

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

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

About the course

Aim

The aim of this course is to give a thorough introduction to the design, usage, and implementation of database systems. After the completion of the course a student should be able to:

  • Design relational databases for different types of example domains by first creating a conceptual schema using the Enhanced Entity Relationship (EER) model and then translating this schema into a corresponding logical schema captured in the relational data model.
  • Analyze and improve the quality of given relational database schemas based on the formal measure of normal forms.
  • Employ the database language SQL to query and to modify several example relational databases, as well as to create such a database with a given relational database schema.
  • Explain and apply basic concepts and techniques that database management systems (DBMSs) use internally to provide their main functionalities, which are the persistent storage and efficient retrieval of data, the efficient processing of queries, and the handling of concurrent access to a database.

Content

Principles for general database management systems: DBMS, Methods fordatabase design and use. Datamodelling with ER, Relational databases,Datastructures for databases, SQL, Relational algebra, queryoptimization, transactions, serialisation, concurrency.

Examiner
Olaf Hartig
Scheduled hours
48 h
Main field of study
Informationsteknologi, Datateknik, Datavetenskap, Programmering
Syllabus on Studieinfo ↗