The course is included in these curricula and study modules


Professional studies

Teaching language


Type of course


Cycle/level of course


Recommended year of study


Total number of ECTS

5 cr

Competency aims

This subject will give the students the expertise needed to model, design, implement and manage a relational database. The student will also establish a general understanding of the theory behind relational databases. The course will give students fundamental knowledge of SQL language and multi-user database management systems. Students are also introduced to real database development environment in PC-lab.

Learning outcomes

In this course the student will learn: - the basic theory behind relational databases - how to write correct and executable SQL code, the main language for querying relational databases - and also have some basic understanding of query optimization - how to analyze, design and implement a simple relational database in a real client-server environment - the benefits of a design methodology

Course contents

Database theory: - definitions, concepts and terminology - relational database model, relational algebra - data base management systems and query language - data integrity Working with databases in a client-server environment using SQL: - select queries, data manipulation (DML) - creation of tables and other database objects (DDL)

Prerequisites and co-requisites


Previous course names

2004-2005 Databases and SQL

Additional information


Recommended or required reading

Study material Thomas Connolly etc.: Database Systems, Fifth Edition (2010) Connolly, Begg, Holowczak: Business Database Systems (2008)

Study activities

  • Lectures - 20 hours
  • Individual- and group instruction - 32 hours
  • Small-group work - 10 hours
  • Project- and production work/artistic activities - 41 hours
  • Individual studies - 30 hours


  • Total workload of the course: 133 hours
  • Of which autonomous studies: 133 hours
  • Of which scheduled studies: 0 hours

Mode of Delivery

Participation in tuition

Assessment methods

  • Exams (written-, oral-, home-)

Assessment requirements

1. SQL exercise (individual home exam) 2. Database project divided in three parts. A team can have max 2 members.


Forss Thomas


Forss Thomas

Home page of the course

Group size

No limit

Assignments valid until

12 months after course has ended

The timetable of the course

Hösten 2013

Assessment methods

  • Date of examination will be announced later - Exams
  • Date will be announced later - Other assignments

Course and curricula search