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
- and also have some basic understanding of query
- how to analyze, design and implement a simple
relational database in a real client-server
- 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

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

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 curriculum search