autumn 2022
INF-2700 Database Systems - 10 ECTS

Last changed 26.09.2022

Application deadline

Applicants from Nordic countries: 1 June for the autumn semester and 1 December for the spring semester. 

Type of course

The course can be taken as a singular course.

Admission requirements

Higher Education Entrance Qualification + specific entrance requirements equivalent to MATRS: R1/(S1+S2). Application code: 9354 - Singular course in computer science

Course overlap

Du vil få en reduksjon i antall studiepoeng (som oppgitt under), dersom du avlegger eksamen i dette emnet og har bestått følgende emne(r) fra før av:

D-212 Data base systems 10 stp
DOK-1012 Digital Media and Data Bases 3 stp
DOK-1012 Data Bases 3 stp
DOKGF Documentation studies, undergraduate course 10 stp

Course content

This course is an in-depth introduction of database systems. It covers theory of data modeling, practice of database application design and implementation, and principles and practice of system-level data management. Data modeling includes different data models in general, and the relational data model in particular. The theory of relational model includes relational algebra and relation schema normalization. The practice of database application includes database schema design and SQL programming. System-level data management includes database performance, data organization on disk, indexing, query processing and optimization, transaction processing, recovery and concurrency control.

Recommended prerequisites

INF-1101 Data structures and algorithms, INF-2201 Operating system fundamentals

Objectives of the course

Knowledge; students should understand

  • theory of the relational data model,
  • application database design and implementation,
  • physical data management and query processing,
  • transaction processing, concurrency control and crash recovery.

Skills; students should be able to

  • design application databases with entity-relationship modeling and schema normalization,
  • implement application databases with SQL,
  • implement some system-level elements of database management systems, for example, in-memory and on-disk data processing, query processing and transaction processing.

General competence:

  • Students should be more competent in system-level programming.
  • Students should have better understanding in system performance issues in general and database performance issues in particular.

Language of instruction and examination

The language of instruction is English and all of the syllabus material is in English. Examination questions will be given in English, but may be answered either in English or a Scandinavian language.

Teaching methods

Lectures: 30 hours, Colloquium: 30 hours, Laboratory: 30 hours. The course is given every autumn semester.

Information to incoming exchange students

This course is available for inbound exchange students. 

This course has recommended academic prerequisites. Please see the «Prerequisite» section for more information. 

Do you have questions about this module? Please check the following website to contact the course coordinator for exchange students at the faculty: https://en.uit.no/education/art?p_document_id=510412.


Schedule

Recommended reading/syllabus

Pensumliste for INF-2700 Databasesystem

Examination

Examination systems: Date: Duration: Grade scale:
School exam 4 Hours A–E, fail F
Coursework requirements – To take an examination, the student must have passed the following coursework requirements:
Written assignments Approved/ Not approved

More info about the coursework requirements

3 written assignments.

Re-sit examination

Given early in the following semester. The re-sit exam is for those who did not get a passed grade on the last ordinary examination. It will be arranged a 4 hour written exam counting 100%.
  • About the course
  • Campus: Tromsø |
  • ECTS: 10
  • Course code: INF-2700
  • Tidligere år og semester for dette emnet