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

DD1370 Database Technology and Information systems 7.5 credits

Administer About course

Course offerings are missing for current or upcoming semesters.
Headings with content from the Course syllabus DD1370 (Autumn 2009–) are denoted with an asterisk ( )

Content and learning outcomes

Course contents

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

Simple rules for good database design. Query languages and a little about the mathematics behind them. Transaction management.

Assertion of security and integrity.

Laboratory assignments using experimental and commercial systems.

Intended learning outcomes

The students will, upon completion of the course, be able to model and implement a simple database. Further on, the students will be able to formulate queries, using SQL, to search information in such databases. Finally, the students will have basic knowledge in the use of decision support systems (data warehouses).

This implies that the students should be able to:

* understand the functions and architecture of a database system,

* be able to model and structure data according to actual constraints

* be able to use a query language to formulate queries

* use a simple decision support system.

Literature and preparations

Specific prerequisites

No information inserted

Recommended prerequisites

No information inserted

Equipment

No information inserted

Literature

To be announced at least 4 weeks before course start at course web page.

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

  • LAB1 - Computer Assignment, 2.5 credits, grading scale: P, F
  • SEM1 - Seminar, 2.0 credits, grading scale: P, F
  • TEN1 - Examination, 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.

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.

Other requirements for final grade

Examination by seminar tasks, laboratory assignments and one written examination.

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 Petter Ögren

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

CSC/Computer Science

Main field of study

Technology

Education cycle

First cycle

Add-on studies

DD1334, DD2469, DD2471, DD2472 and DD2483.

Contact

Petter Ögren, e-post: petter@kth.se