course-details-portlet

INFT1009 - 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 B

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 To
IDATT2103 7.5 AUTUMN 2024
IDATT2002 7.5 AUTUMN 2024
IDATG2002 7.5 AUTUMN 2024
IDATA2002 7.5 AUTUMN 2024
INFT1001 3.0 AUTUMN 2024
DIFT1002 3.0 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: Norwegian

Location: Trondheim

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

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 B 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