The course is included in these curricula and study modules

It 2001 - 2004 - System and application software

Level/category

Professional studies

Teaching language

Swedish

Type of course

Compulsory

Recommended year of study

3

Total number of ECTS

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

Course contents

Database theory:

  • definitions, concepts and terminology
  • relational database model
  • 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

Recommended or required reading

Lecturer's material
McCarty-Risch: Databasteknik (elementary part)

Study activities

  • Lectures - 15 hours
  • Excursions and demonstrations - 3 hours
  • Exercise based learning - 20 hours
  • Tuition managed by students but supervised by the teacher - 12 hours
  • Project work and productions - 15 hours
  • Individual studies - 15 hours

Workload

  • Total workload of the course: 80 hours
  • Of which autonomous studies: 30 hours
  • Of which scheduled studies: 50 hours

Mode of Delivery

Participation in tuition

Assessment methods

Reports and productions

Examiner

Karlsson Hanne

Group size

No limit

Course completion date

Date for course completion will be announced later

Assignments valid until

12 months after course has ended

Assessment methods

2007-04-10 - Reports and productions

Course and curriculum search