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.
DD1368 Database Technology 6.0 credits
A continuation course in computer science that covers the fundamentals of database technology.
Information per course offering
Information for Autumn 2026 dbtd26 programme students
- Course location
KTH Campus
- Duration
- 26 Oct 2026 - 11 Jan 2027
- Periods
Autumn 2026: P2 (6 hp)
- Pace of study
33%
- Application code
10837
- Form of study
Normal Daytime
- Language of instruction
Swedish
- Course memo
- Course memo is not published
- Number of places
Min: 1
- Target group
- CDATE, CTMAT and CLGYM.
- Planned modular schedule
- [object Object]
- Schedule
- Schedule is not published
Contact
Course syllabus as PDF
Please note: all information from the Course syllabus is available on this page in an accessible format.
Course syllabus DD1368 (Autumn 2026–)Headings with content from the Course syllabus DD1368 (Autumn 2026–) are denoted with an asterisk ( )
Content and learning outcomes
Course contents
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 credits, equivalent to completed course DD1337/DD1310-DD1319/DD1321/DD1331/DD1333/DD100N/ID1018/ID1022.
- Knowledge in algorithms, data structures and basic software development techniques, 6 credits, equivalent to completed course DD1338/DD1320-DD1328/DD2325/ID1020/ID1021 or completed exam elements KONT and LABD in DD1326.
Literature
You can find information about course literature either in the course memo for the course offering or in the course room in Canvas.
Examination and completion
Grading scale
A, B, C, D, E, FX, F
Examination
- LAB2 - Laboratory Assignments, 3.0 credits, grading scale: A, B, C, D, E, FX, F
- HEM1 - Home 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.
If the course is discontinued, students may request to be examined during the following two academic years.
Examiner
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
Computer Science and Engineering, Technology
Education cycle
First cycle
Transitional regulations
The earlier component TEN1 is replaced by HEM1.
Supplementary information
In this course, the EECS code of honor applies, see:
http://www.kth.se/en/eecs/utbildning/hederskodex