course-details-portlet

IDATG2002 - Databases

About

New from the academic year 2024/2025

Examination arrangement

Examination arrangement: School exam
Grade: Letter grades

Evaluation Weighting Duration Grade deviation Examination aids
School exam 100/100 4 hours E

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

Course materials

Given at the start of the course.

Credit reductions

Course code Reduction From To
IDATT2002 7.5 AUTUMN 2023
IDATA2002 7.5 AUTUMN 2023
IDATG2204 7.5 AUTUMN 2023
IDATA2303 7.5 AUTUMN 2023
INFT1009 7.5 AUTUMN 2024
More on the course

No

Facts

Version: 1
Credits:  7.5 SP
Study level: Foundation courses, level I

Coursework

Term no.: 1
Teaching semester:  SPRING 2025

Language of instruction: English

Location: Gjøvik

Subject area(s)
  • Database technology
  • Engineering
Contact information
Course coordinator: Lecturer(s):

Department with academic responsibility
Department of Computer Science

Examination

Examination arrangement: School exam

Term Status code Evaluation Weighting Examination aids Date Time Examination system Room *
Spring ORD School exam 100/100 E INSPERA
Room Building Number of candidates
Summer UTS School exam 100/100 E INSPERA
Room Building Number of candidates
  • * The location (room) for a written examination is published 3 days before examination date. If more than one room is listed, you will find your room at Studentweb.
Examination

For more information regarding registration for examination and examination procedures, see "Innsida - Exams"

More on examinations at NTNU