Course - Databases - IDATA2002
IDATA2002 - Databases
About
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
Admission to a programme of study is required:
Computer Science - Engineering (BIDATA)
Recommended previous knowledge
Basic knowledge in programming.
Course materials
Given at the start of the course.
Credit reductions
| Course code | Reduction | From | To |
|---|---|---|---|
| IDATT2002 | 7.5 | AUTUMN 2023 | |
| IDATG2002 | 7.5 | AUTUMN 2023 | |
| IDATA2303 | 7.5 | AUTUMN 2023 | |
| IDATG2204 | 7.5 | AUTUMN 2023 | |
| INFT1009 | 7.5 | 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: English
Location: Ålesund
- 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 E 2025-05-21 09:00 INSPERA
-
Room Building Number of candidates G326 Gnisten/Fagskolen 36 - 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.
For more information regarding registration for examination and examination procedures, see "Innsida - Exams"