x !
Archived Curricula Guide 2011–2012
Curricula Guide is archieved. Please refer to current Curricula Guides
TKOPP3 Data Bases 4 ECTS
Organised by
Computer Science
Person in charge
Preceding studies
Or corresponding knowledge in the field.

Learning outcomes

The goal is to familiarise students with the basic structures of SQL databases and using ER modelling. Upon completion of the course, students will be able to model data using ER diagrams, convert ER models into SQL database (relational database) schemas, and use a database with the help of SQL language.


Course topics include establishing a database, updating data and posing queries in SQL language, ER diagrams and conversion from an ER diagram into an SQL database (relational database) schema.

Teaching methods

Teaching method Contact Online
Lectures 14 h 0 h
Exercises 12 h 0 h

Teaching language


Modes of study

Written examination, a certain number of weekly exercises and a project work.


Numeric 1-5.

Recommended year of study

1. year autumn

Study materials

  1. Elmasri, R. & Navathe, S., Fundamentals of Database Systems. Benjamin/Cummings, 1997 or newer edition.

Further information

Some of the topics have previously been part of the courses Principles of Information Systems and Database Programming. If you have completed the course Principles of Information Systems, you can take this course. If you have completed the course Database Programming (10 ECTS/5 cu) before autumn 2004, you cannot get credits for this course.

Belongs to following study modules

School of Information Sciences
Joint Basic Studies (Computer Science)
School of Information Sciences
Joint Basic Studies (Interactive Technology)
Archived Teaching Schedule. Please refer to current Teaching Shedule.
School of Information Sciences