Skriv ut | Lukk vindu |
Høst 2022
INF-2700 Database Systems - 10 stp
The course is administrated by
Institutt for informatikk
Type of course
The course can be taken as a singular course.
Course overlap
DOKGF Documentation studies, undergraduate course 10 stp
Course contents
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.
Application deadline
Applicants from Nordic countries: 1 June for the autumn semester and 1 December for the spring semester.
Admission requirements
Higher Education Entrance Qualification + specific entrance requirements equivalent to MATRS: R1/(S1+S2). Application code: 9354 - Singular course in computer science
Objective 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
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.
Date for examination
School exam 06.12.2022
The date for the exam can be changed. The final date will be announced at your faculty early in May and early in November.