The course is included in these curricula and study modules

Level/category

Professional studies

Teaching language

Swedish

Type of course

Compulsory

Cycle/level of course

First

Recommended year of study

2

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

None

Previous course names

2004-2005 Databases and SQL

Additional information

None

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

Workload

  • 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.

Teacher

Forss Thomas

Examiner

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