course-details-portlet

INFT1009

Databases

This course is no longer taught and is only available for examination.

Credits 7.5
Level Foundation courses, level I
Language of instruction Norwegian
Location Trondheim
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

Online teaching with practical exercises and discussion forum.

Compulsory assignments

  • Compulsory assignments

Further on evaluation

Compulsory activities: Corresponding to 8 compulsory 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 will be in November/December.

Specific conditions

Admission to a programme of study is required:
Information Technology (ITBAINFO)

Course materials

Given at the start of the course.

Credit reductions

Course code Reduction From
IDATT2103 7.5 sp Autumn 2024
IDATT2002 7.5 sp Autumn 2024
IDATG2002 7.5 sp Autumn 2024
IDATA2002 7.5 sp Autumn 2024
INFT1001 3 sp Autumn 2024
DIFT1002 3 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

Department with academic responsibility

Department of Computer Science

Examination

Examination

Examination arrangement: School exam
Grade: Letter grades

Re-sit examination - Autumn 2025

School exam
Weighting 100/100 Examination aids Code B Date 2025-11-19 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.

Sluppenvegen 14
Room SL111 brun sone
1 candidate

Ordinary examination - Spring 2026

School exam
Weighting 100/100 Examination aids Code B Duration 4 hours Exam system Inspera Assessment Place and room Not specified yet.