Skip to main content

Before choosing course

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

Choose semester and course offering

Choose semester and course offering to see information from the correct course syllabus and course offering.

* Retrieved from Course syllabus DD1368 (Autumn 2021–)

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.

Course Disposition

No information inserted

Literature and preparations

Specific prerequisites

Knowledge and skills in programming, 6 higher education credits, equivalent to completed course DD1337/DD1310/DD1311/DD1312/DD1314/DD1315/DD1316/DD1318/DD1321/DD1331/DD100N/ID1018.

Knowledge in basic computer science, 6 higher education credits, equivalent to completed course DD1338/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. Registering for a course is counted as active participation. The term 'final examination' encompasses both the regular examination and the first re-examination.

Recommended prerequisites

No information inserted

Equipment

No information inserted

Literature

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

Examination

  • HEM1 - Home assignments, 3,0 hp, betygsskala: A, B, C, D, E, FX, F
  • LAB2 - Laboratory Assignments, 3,0 hp, betygsskala: 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

Examiner

Profile picture Dena Hussain

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 web

Further information about the course can be found on the Course web at the link below. Information on the Course web will later be moved to this site.

Course web DD1368

Offered by

EECS/Computer Science

Main field of study

Computer Science and Engineering, Technology

Education cycle

First cycle

Add-on studies

DD2447, DD2471 and DD2476.

Contact

Dena Hussain

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