DD1334 Database Technology 6.0 credits

Databasteknik

Please note

The information on this page is based on a course syllabus that is not yet valid.

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

  • Education cycle

    First cycle
  • Main field of study

    Information Technology
    Technology
  • Grading scale

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

Course offerings

Autumn 18 dbtek18 for programme students

Autumn 19 dbtek19 for programme students

Intended learning outcomes

The student will understand:

  1. schema and queries in the relational database model using SQL;
  2. the operation of constraints and triggers during  modifications of a SQL database;
  3. how to avoid anomalies, preserve information and dependencies in the design of a relational databases;
  4. the use of ER diagrams and design principles in relational database design .
  5. the XML database model, XML-schema DTD, and XQuery. 

Course main content

Definition of the relation model. Information structuring according to the “Entity Relationship”-model.

Functional dependencies and what they mean for good database design. Normalization. Query languages and the mathematics behind them.Transaction handling. Assertion of security and integrity. Overview of different models for data representation. Laboratory assignments using experimental and commercial systems.

Disposition

The course consists of a series of lectures each with a prerequist reading assignment, recitations in which homework assignments are explained, labs,  a group assignment, and an exam.

Eligibility

For single course students: completed upper secondary education including documented proficiency in Swedish corresponding to Swedish B, English corresponding to English A. Furthermore: 7,5 hp in mathematics and 6 hp in computer science or programming technics.

Recommended prerequisites

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

Literature

H. Garcia-Molina, J. Ullman and J. Widom, Database Systems: The Complete Book, Pearson Prentice Hall, 2009.

Examination

  • LABA - Laboratory Assignments, 3.0, grading scale: A, B, C, D, E, FX, F
  • TEN1 - Examination, 3.0, grading scale: A, B, C, D, E, FX, F

In this course all the regulations of the code of honor at the School of Computer science and Communication apply, see: http://www.kth.se/csc/student/hederskodex/1.17237?l=en_UK.

Requirements for final grade

The students participating in the course are expected to take part in all activities on the course with a particular emphasis on the exercises and laboratories.
In addition the course focuses on training:
acquiring knowledge.
training oral and written presentation.
Examination by one examination (TEN1; 3 university credits), laboratory assignments (LAB1; 3 university credits), seminar and training tasks.

Offered by

EECS/Computer Science

Contact

Florian Pokorny (fpokorny@kth.se)

Examiner

Florian Pokorny <fpokorny@kth.se>

Supplementary information

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

Add-on studies

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

Version

Course syllabus valid from: Spring 2019.
Examination information valid from: Spring 2019.