Study Guide@lith
 

Linköping Institute of Technology

 
 
Valid for year : 2016
 
TDDD12 Database Technology, 6 ECTS credits.
/Databasteknik/

For:   DI   Ii   IP   M   Mat   MMAT   Y  

 

Prel. scheduled hours: 42
Rec. self-study hours: 118

  Area of Education: Technology

Main field of studies: Computer Engineering, Programming

  Advancement level (G1, G2, A): G2

Aim:
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.


Prerequisites: (valid for students admitted to programmes within which the course is offered)
Basic programming and Data structures and algorithms.

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

Supplementary courses:
Advanced Data Models and Databases; data mining

Organisation:
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.

Course contents:
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.

Course literature:
Elmasri, R. and Navathe, S. B. Fundamentals of Database Systems, 3e, 4th, 5th or 6th edition, Addison Wesley. OBSERVE: The title of the 6th edition is: Database Systems - Models, Languages, Design, and Application Programming.

Examination:
Written examination
Laboratory work
3 ECTS
3 ECTS
 



Course language is English.
Department offering the course: IDA.
Director of Studies: Patrick Lambrix
Examiner: Jose M. Pena

Course Syllabus in Swedish

Linköping Institute of Technology

 


Contact: TFK , val@tfk.liu.se
Last updated: 08/31/2015