course-details-portlet

IDATA2002

Databases

Choose study year
Credits 7.5
Level Foundation courses, level I
Course start Spring 2025
Duration 1 semester
Language of instruction English
Location Ålesund
Examination arrangement School exam

About

About the course

Course content

This topic covers the following topics:

Terminology related to databases. Data modeling and database design. Relational database systems and SQL. Database integrity. Normalization. Transaction handling and multi-user issues. Security. Introduction of alternatives to relational database (NoSQL). Link between database and programming.

Learning outcome

Knowledge: The candidate must:

  • know central concepts (in Norwegian and English) within databases, and be able to explain these
  • understand problems related to several simultaneous users of a database and know how these can be solved
  • know the theory behind the relational model
  • know about alternatives to relational databases (NoSQL and semi-structured data)

Skills: The candidate must:

  • be able to create a separate database, and extract and change the data in this database, all via SQL
  • see the connection between program code and underlying SQL / database
  • be able to optimize SQL queries for performance
  • be able to construct a data model (EER) for a given problem and translate this into the relational model
  • could propose sustainable solutions for storing data related to normalization and re-use of data

General competence: The candidate must:

  • gain an understanding of applying database solutions to solve various needs for the storage and representation of digital data
  • gain an understanding of security challenges in database systems
  • have an understanding of what good data quality is

Learning methods and activities

Teaching with practical exercises and discussion forum.

Compulsory assignments

  • Compulsory exercises

Further on evaluation

Compulsory exercises: All exercises must be approved in order to sit for the exam. Requirements can be made for exercises to be carried out as group work (team work).

The re-sit exam for the written school exam is held in August.

Written exam might be changed to oral exam for the re-sit exam.

Specific conditions

Admission to a programme of study is required:
Computer Science - Engineering (BIDATA)

Course materials

Given at the start of the course.

Credit reductions

Course code Reduction From
IDATT2002 7.5 sp Autumn 2023
IDATG2002 7.5 sp Autumn 2023
IDATA2303 7.5 sp Autumn 2023
IDATG2204 7.5 sp Autumn 2023
INFT1009 7.5 sp Autumn 2024
This course has academic overlap with the courses in the table above. If you take overlapping courses, you will receive a credit reduction in the course where you have the lowest grade. If the grades are the same, the reduction will be applied to the course completed most recently.

Subject areas

  • Database technology
  • Engineering

Contact information

Course coordinator

Lecturers

Department with academic responsibility

Department of Computer Science

Examination

Examination

Examination arrangement: School exam
Grade: Letter grades

Ordinary examination - Spring 2025

School exam
Weighting 100/100 Examination aids Code E Date 2025-05-21 Time 09:00 Duration 4 hours Exam system Inspera Assessment
Place and room for school exam

The specified room can be changed and the final location will be ready no later than 3 days before the exam. You can find your room location on Studentweb.

Ankeret/Hovedbygget
Room C218
36 candidates
Room C215

Re-sit examination - Summer 2025

School exam
Weighting 100/100 Examination aids Code E Duration 4 hours Exam system Inspera Assessment
Place and room
The specified room can be changed and the final location will be ready no later than 3 days before the exam. You can find your room location on Studentweb.