DD1368 Database Technology 6.0 credits

Databasteknik för D

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

Show course information based on the chosen semester and course offering:

Offering and execution

No offering selected

Select the semester and course offering above to get information from the correct course syllabus and course offering.

Course information

Content and learning outcomes

Course contents *

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. Overview of different models for data representation. Laboratory assignments using experimental and commercial systems.

Intended learning outcomes *

After completing the course you will be able to:

  • explain the functions and architecture of a database 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,
  • use a query language to formulate queries, and describe themathematical foundations for data manipulation languages,
  • write embedded SQL in a 3rd generation programming language.

Course Disposition

No information inserted

Literature and preparations

Specific prerequisites *

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

No information inserted

Equipment

No information inserted

Literature

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

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
  • 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 *

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:

  • independently acquiring knowledge,
  • oral presentation.

Examination by one written exam and laboratory assignments.

Opportunity to complete the requirements via supplementary examination

No information inserted

Opportunity to raise an approved grade via renewed examination

No information inserted

Examiner

Dena Hussain

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 denah@kth.se

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.

Supplementary information

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