Database Technology, 6 credits (TDDD81)

Databasteknik för kandidatprojekt, 6 hp

Main field of study

Computer Science and Engineering

Level

First cycle

Course type

Programme course

Examiner

Jose M. Pena

Director of studies or equivalent

Patrick Lambrix
Course offered for Semester Period Timetable module Language Campus VOF
6CIEI Industrial Engineering and Management - International, M Sc in Engineering - French (Specialization Computer Science and Engineering) 6 (Spring 2017) 1, 2 2, 4 Swedish Linköping v
6CIEI Industrial Engineering and Management - International, M Sc in Engineering - French 6 (Spring 2017) 1, 2 2, 4 Swedish Linköping v
6CIEI Industrial Engineering and Management - International, M Sc in Engineering - Japanese (Specialization Computer Science and Engineering) 6 (Spring 2017) 1, 2 2, 4 Swedish Linköping v
6CIEI Industrial Engineering and Management - International, M Sc in Engineering - Japanese 6 (Spring 2017) 1, 2 2, 4 Swedish Linköping v
6CIEI Industrial Engineering and Management - International, M Sc in Engineering - Spanish (Specialization Computer Science and Engineering) 6 (Spring 2017) 1, 2 2, 4 Swedish Linköping v
6CIEI Industrial Engineering and Management - International, M Sc in Engineering - Spanish 6 (Spring 2017) 1, 2 2, 4 Swedish Linköping v
6CIEI Industrial Engineering and Management - International, M Sc in Engineering - German (Specialization Computer Science and Engineering) 6 (Spring 2017) 1, 2 2, 4 Swedish Linköping v
6CIEI Industrial Engineering and Management - International, M Sc in Engineering - German 6 (Spring 2017) 1, 2 2, 4 Swedish Linköping v
6CIEI Industrial Engineering and Management - International, M Sc in Engineering - Chinese (Specialization Computer Science and Engineering) 6 (Spring 2017) 1, 2 2, 4 Swedish Linköping v
6CIEI Industrial Engineering and Management - International, M Sc in Engineering - Chinese 6 (Spring 2017) 1, 2 2, 4 Swedish Linköping v
6CIII Industrial Engineering and Management, M Sc in Engineering (Specialization Computer Science and Engineering) 6 (Spring 2017) 1, 2 2, 4 Swedish Linköping o
6CIII Industrial Engineering and Management, M Sc in Engineering 6 (Spring 2017) 1, 2 2, 4 Swedish Linköping v

Main field of study

Computer Science and Engineering

Course level

First cycle

Advancement level

G2X

Course offered for

  • Industrial Engineering and Management - International, M Sc in Engineering
  • Industrial Engineering and Management, M Sc in Engineering

Entry requirements

Note: Admission requirements for non-programme students usually also include admission requirements for the programme and threshold requirements for progression within the programme, or corresponding.

Prerequisites

Basic programming as well as data structures and algorithms.

Intended learning outcomes

The aim of this course is to give a thorough introduction to the theoretical and practical issues underlying the design and implementation of modern database systems. After the completion of the course you should be able to:

  • explain and use important terminology in text-based information management in a correct way.
  • design a data model using EER diagrams.
  • design and use a relational database.
  • explain the theory behind the relational model and how this affects good design of databases.
  • explain which file structures in the database management system can be used to implement a database system.
  • explain the basic principles for indexing a database.
  • explain which problems can occur when several users use the database and solutions to this.
  • explain how a database can guarantee persistence of data.

Course content

Principles for general database management systems: DBMS, Methods for
database design and use. Datamodelling with ER, Relational databases,
Datastructures for databases, SQL, Relational algebra, query optimization, transactions, serialisation, concurrency.

Teaching and working methods

The course consists of lectures, laboratory work and a project. Lectures are devoted to theory and techniques. Database design and implementation techniques are practised in the laboratory work.

Examination

TEN1Written examinationU, 3, 4, 53 credits
LAB1Laboratory workU, G3 credits

Grades

Four-grade scale, LiU, U, 3, 4, 5

Other information

Supplementary courses:

Advanced Data Models and Databases; data mining

Department

Institutionen för datavetenskap

Director of Studies or equivalent

Patrick Lambrix

Examiner

Jose M. Pena

Education components

Preliminary scheduled hours: 42 h
Recommended self-study hours: 118 h

Course literature

Elmasri, R. and Navathe, S. B. Fundamentals of Database Systems, 3e, 4e, 5e eller 6e upplaga, Addison Wesley. OBS: Den 6e upplagans titel är: Database Systems - Models, Languages, Design, and Application Programming.
Elmasri, R. and Navathe, S. B. Fundamentals of Database Systems, 3e, 4e, 5e eller 6e upplaga, Addison Wesley. OBS: Den 6e upplagans titel är: Database Systems - Models, Languages, Design, and Application Programming.
TEN1 Written examination U, 3, 4, 5 3 credits
LAB1 Laboratory work U, G 3 credits

Regulations (apply to LiU in its entirety)

The university is a government agency whose operations are regulated by legislation and ordinances, which include the Higher Education Act and the Higher Education Ordinance. In addition to legislation and ordinances, operations are subject to several policy documents. The Linköping University rule book collects currently valid decisions of a regulatory nature taken by the university board, the vice-chancellor and faculty/department boards.

LiU’s rule book for education at first-cycle and second-cycle levels is available at http://styrdokument.liu.se/Regelsamling/Innehall/Utbildning_pa_grund-_och_avancerad_niva. 

This tab contains public material from the course room in Lisam. The information published here is not legally binding, such material can be found under the other tabs on this page. There are no files available for this course.

Page responsible: Info Centre, infocenter@liu.se