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

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

Kurs och studieplanssökning