autumn 2017

INF-2700 Database Systems - 10 stp

Last changed: 05.09.2017

The course is administrated by

Faculty of Science and Technology

Campus

Tromsø |

Application deadline

Applicants from Nordic countries: 1 June for the autumn semester and 1 December for the spring semester. Exchange students and Fulbright students: 15 April for the autumn semester and 1 October for the spring semester.

Type of course

The course can be taken as a singular course.

Admission requirements

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

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.

Recommended prerequisites

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

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.

Assessment

A 4 hour final written exam counting 100%. Approved assignments give access to the final written exam.

Course requirements: The coursework includes up to 3 written assignments graded "Approved" / "Not approved". Oral presentation of the assignments and demonstration of a working system can be claimed.

Grading scale: Letter grades A-F.

Re-sit examination: Given early in teaching free semester, if the course is compulsory in the study plan. It will be arranged a 4 hour written exam counting 100%. To get access to the re-sit examination in the teaching free semester the student must have passed the course requirements.

Postponed examination: Given early in teaching free semester. It will be arranged a 4 hour written exam counting 100%. To get access to the postponed examination in the teaching free semester the student must have passed the course requirements.

For further details see: - Utfyllende bestemmelser for eksamener ved Fakultet for naturvitenskap og teknologi (only in Norwegian) - Regulations for examinations at the UiT

Date for examination

Written test 30.11.2017

The date for the exam can be changed. The final date will be announced at your faculty early in May and early in November.

Schedule

Course overlap

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
AUT-2004 Application Development 2 stp

Recommended reading/syllabus

Syllabus and reading list are available in Fronter or by contacting the responsible teacher or a student adviser.
Lectures Autumn 2017
First attendance: Friday 18.08.2017, at 11:15 in TEKNOBYGGET 1.023AUD.
Lecture f.aman. Weihai Yu
Colloquium gr 1 vit.ass. Nikolai Åsen Magnussen


Contact

Yu, Weihai


Phone: 77644048
Mobile: 41429077 weihai.yu@uit.no

Skip to main content