Database Systems
About the course
The course can be taken as a singular course.
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.
Admission requirements
Objectives of the course
Knowledge; students 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 can
- 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 are more competent in system-level programming.
- Students have better understanding in system performance issues in general and database performance issues in particular.
Prerequisites
Anbefalte forkunnskaper
INF-1101 Data structures and algorithms, INF-2201 Operating system fundamentals
Credit reduction
If you pass the examination in this course, you will get an reduction in credits (as stated below), if you previously have passed the following courses:
- D-212 Data base systems 10 ects
- DOK-1012 Digital Media and Data Bases 3 ects
- DOK-1012 Data Bases 3 ects
- DOKGF Documentation studies, undergraduate course 10 ects
- AUT-2004 Application Development 2 ects
Teaching methods
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.Recommended reading/syllabus
Du kan se og få tilgang til deler av pensum via Leganto.
Pensumliste for INF-2700 Databasesystem- H23Information 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.
Examination
| School exam | Date: 04.12.2023 09:00 Duration: 4 Hours |
Grade: A–E, fail F |
To take an examination, the student must have passed the following coursework requirements
| Written assignments | Grade: Approved – not approved |
Everything you need to know about before, during, and after the exam; registration, absence, appeals, and diplomas: UiT Exams homepage