Course - Databases - INFT1009
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)
Recommended previous knowledge
Basic knowledge in programming.
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 |
No
Version: 1
Credits:
7.5 SP
Study level: Foundation courses, level I
Term no.: 1
Teaching semester: SPRING 2025
Language of instruction: Norwegian
Location: Trondheim
- Database technology
- Engineering
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.
For more information regarding registration for examination and examination procedures, see "Innsida - Exams"