DD1334 Database Technology 6.0 credits

Course contents

Definition of the relational model and the semi-structured data model. Information structuring according to the Entity-Relationsship model. Functional dependencies and their importance for good database design. Normalisation. Query language and underlying mathematics. Transaction management. Overview of different models for data representation. Labs that apply the concept of the course, particularly SQL, XML and XQuery. 

Intended learning outcomes

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

• explain the functions and structure of a database management system
• discuss advantages and disadvantages with different database models
• model and structure data considering current restrictions
• explain how different restrictions will influence the database structure
• use query language to formulate questions and describe the mathematical background for query language
• write embedded SQL statements in a third generation programming language
• explain and write SQL, XML and XQuery code 
• explain the argument behind and carry out database normalising tasks, and formulate and explain functional dependencies.

Course disposition

No information inserted

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.

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

One of the courses 2D1320/DD1320 Applied Computer Science, 2D1343/DD1343 Computer Science, 2D1344/DD1344 Fundamentals of Computer Science or the equivalent.

Equipment

No information inserted

Literature

No information inserted

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

• LABA - Laboratory Assignments, 3,0 hp, betygsskala: A, B, C, D, E, FX, F
• TEN1 - Examination, 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

Florian Pokorny

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.

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.

Offered by

EECS/Computer Science

Main field of study

Information Technology, Technology

Education cycle

First cycle

Add-on studies

DD2471 Modern Database Systems and Their Application, DD2483 Development of Web Applications with Enterprise Java.

Contact

Florian Pokorny (fpokorny@kth.se)

Supplementary information

The course cannot be counted towards the degree if the student also has taken 2I1100 or 2I1033.

In this course, the EECS code of honor applies, see:
http://www.kth.se/en/eecs/utbildning/hederskodex