DD1364 Database Technology 7.5 credits

Databasteknik

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

Offering and execution

Course offering missing for current semester as well as for previous and coming semesters

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. Methods for storage and retrieval. Transaction handling. Assertion of security and integrity. Fourth generation development tools for design of database systems. Development of information systems. Overview of different models for data representation. 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 database. Further on they will have written an application program operating a database.

This implies that the students should:

  • understand the functions and architecture of a database system,
  • be able to discuss advantages and disadvantages with different database models,
  • be able to model and structure data according to actual constraints and be able to discuss advantages and disadvantages with different implementations of a database and its constraints,
  • understand how to choose index structures and decide which index structures are usable in different situations,
  • be able to use a query language to formulate queries and also to describe the mathematical foundations for data manipulation languages,
  • understand and be able to explain the implications of different constraints on the database,
  • fully understand the mechanisms for optimization of queries,
  • fully understand the principles of concurrency and recovery handling,
  • fully understand the solutions to security problems,
  • be able to write embedded SQL in a 3rd generations programming language.

Course Disposition

No information inserted

Literature and preparations

Specific prerequisites *

No information inserted

Recommended prerequisites

No information inserted

Equipment

No information inserted

Literature

Silberschaty, Korth, Sudarshan: Database Systems Concepts.

Examination and completion

Grading scale *

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

Examination *

  • LAB1 - Laboratory Work, 3.5 credits, Grading scale: P, F
  • TEN1 - Examination, 4.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:
• acquiring knowledge.
• training oral and written presentation.
Examination by one examination (TEN1; 4 university credits), laboratory assignments (LAB1; 3,5 university credits), seminar and training tasks.

Opportunity to complete the requirements via supplementary examination

No information inserted

Opportunity to raise an approved grade via renewed examination

No information inserted

Examiner

John Folkesson

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 DD1364

Offered by

CSC/Computer Science

Main field of study *

Technology

Education cycle *

First cycle

Add-on studies

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

Contact

John Folkesson

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

The last time the course is given is 2010/2011.