ITF30307 Databases - Management and Systems (Autumn 2014)

Facts about the course

ECTS Credits:
10
Responsible faculty:
Avdeling for informasjonsteknologi
Course Leader:
Edgar Bostrøm
Teaching language:
Norwegian
Duration:
½ year

Table of contents

The course is affiliated to the following study programme

Compulsory course in:

  • Bachelor Programme in Computer Science
  • Bachelor Programme in Information Systems: specialisation in IT Management and specialisation in Web Development

Elective course in:

  • Bachelor Programme in Computer Engineering
  • Bachelor Programme in Computer Engineering, Y-veien
  • Bachelor Programme in Computer Engineering, Tress

Prerequisites

It is recommended that students have knowledge equivalent to the courses in Databases and Introduction to Programming.

Teaching semester

Semester 5 (autumn)

Total workload:

4 hours of lectures + exercises per week.

Content

Database administration, connecting to databases, triggers and stored procedures, XML, middleware and persistence. Data warehousing and big data. Models for databases, relational algebra Non-relational systems: Multimedia databases, object-oriented and object-relational systems, and XML-based systems

The student's learning outcomes on passing the course

Knowledge

On completion of the course, the students have:

  • deeper insight into what a database system is and of its components
  • know how database systems interact with other systems such as middleware
  • advanced theoretical understanding in, among other things, optimisation
  • knowledge of different types of databases and applications, including data warehouses
  • knowledge of big data

Skills

On completion of the course, the students can:

  • set up and operate a database system
  • write statements in relational algebra
  • create simple stored procedures and triggers
  • design a warehouse
  • use XML in connection with databases
  • work on different database systems

General competence

On completion of the course, the students have:

  • sound competence in DBA
  • advanced knowledge of developing and using database systems

Teaching and learning methods

Lectures and project work. The course is mainly built on a combination of lectures and project work. Some topics included in the projects will not be covered in lectures, and students are therefore expected to learn about them independently.

Exam

Portfolio exam and written exam

The final individual grade is awarded on the basis of two partial exams. Students must pass each partial exam in order to pass the whole course.

Partial Exam 1 is a portfolio exam comprising reports from 4 projects conducted in groups. The portfolio exam accounts for 49%. Individual grades awarded.

Partial Exam 2 comprises an individual written exam lasting 3 hours and worth 51%. No support materials permitted.

Letter grading scale A?F.

In the case of resit exams or rescheduled exams, each part of an exam may be retaken and the results of each part combined. The content of the project assignment must be discussed with the course instructor in the case of resit exams or rescheduled exams.

Course evaluation

This course is evaluated as follows:

  • Mid-semester evaluation (optional)
  • Final evaluation (compulsory)

The course instructor prepares a course report on the basis of student feedback and on his/her own experiences of the course. Course reports are discussed with the Committee for Study Quality at the Faculty of Computer Sciences.

Reading list

Thomas M. Connolly Carolyn E. Begg. Database Systems: A Practical Approach to Design, Implementation and Management - 6th Edition

Handouts and web resources.

Last updated from FS (Felles studentsystem) Oct. 15, 2026 2:35:34 AM