Skip to main content
Till KTH:s startsida Till KTH:s startsida

DD1334 Database Technology 6.0 credits

A continaution in computer science that covers the fundamentals of database technology.

About course offering

For course offering

Autumn 2024 dbtech24 programme students

Target group

Open to all programmes except CDATE, as long as it can be included in your programme.

Part of programme

Degree Programme in Industrial Engineering and Management, åk 3, DTOI, Mandatory


P1 (6.0 hp)


26 Aug 2024
27 Oct 2024

Pace of study


Form of study

Normal Daytime

Language of instruction


Course location

KTH Campus

Number of places

Places are not limited

Planned modular schedule


For course offering

Autumn 2024 dbtech24 programme students

Application code



For course offering

Autumn 2024 dbtech24 programme students


Johan Jansson


No information inserted

Course coordinator

No information inserted


No information inserted
Headings with content from the Course syllabus DD1334 (Autumn 2023–) are denoted with an asterisk ( )

Content and learning outcomes

Course contents

Definition of the relational data model. Information structuring according to the Entity-Relationship model.

Functional dependencies and their importance for good database design. Normalization. Query languages and their underlying mathematics.

Transaction management. Overview of different models for data representation.

Laboratory assignments using experimental and commercial systems.

Intended learning outcomes

After passing the course, the student should be able to:

  • explain the functions and structure of a database management system
  • discuss the advantages and disadvantages of different database models
  • model and structure data according to actual constraints
  • explain the implications of different constraints on the database structure
  • use a query language to formulate queries and describe the mathematical foundation for query languages
  • write embedded SQL statements in a third generation programming language
  • present independently acquired necessary knowledge orally and in writing.

Literature and preparations

Specific prerequisites

  • Knowledge and skills in programming, 6 higher education credits, equivalent to completed course DD1310/DD1311/DD1312/DD1314/DD1315/DD1316/DD1318/DD1331/DD100N/ID1018.
  • Knowledge in basic computer science, 6 higher education credits, equivalent to completed course DD1320/DD1321/DD1325/DD1327/DD2325/ID1020/ID1021.

Active participation in a course offering where the final examination is not yet reported in LADOK is considered equivalent to completion of the course.

Being registered for a course counts as active participation.

The term 'final examination' encompasses both the regular examination and the first re-examination.

Recommended prerequisites

DD2477 Search Engines and Information Retrieval Systems.


No information inserted


No information inserted

Examination and completion

If the course is discontinued, students may request to be examined during the following two academic years.

Grading scale

A, B, C, D, E, FX, F


  • HEM1 - Home assignments, 3.0 credits, grading scale: A, B, C, D, E, FX, F
  • LABA - Laboratory Assignments, 3.0 credits, grading scale: A, B, C, D, E, FX, F

Based on recommendation from KTH’s coordinator for disabilities, the examiner will decide how to adapt an examination for students with documented disability.

The examiner may apply another examination format when re-examining individual students.

Opportunity to complete the requirements via supplementary examination

No information inserted

Opportunity to raise an approved grade via renewed examination

No information inserted


Ethical approach

  • All members of a group are responsible for the group's work.
  • In any assessment, every student shall honestly disclose any help received and sources used.
  • In an oral assessment, every student shall be able to present and answer questions about the entire assignment and solution.

Further information

Course room in Canvas

Registered students find further information about the implementation of the course in the course room in Canvas. A link to the course room can be found under the tab Studies in the Personal menu at the start of the course.

Offered by

Main field of study

Information Technology, Technology

Education cycle

First cycle

Add-on studies

No information inserted


Johan Jansson

Transitional regulations

The earlier component TEN1 is replaced by HEM1.

Supplementary information

The course cannot be counted towards the degree if the student also has taken DD1368.

In this course, the EECS code of honor applies, see: