course-details-portlet

TDT4145

Data Modelling, Databases and Database Management Systems

Assessments and mandatory activities may be changed until September 20th.

Credits 7.5
Level Intermediate course, level II
Course start Spring 2026
Duration 1 semester
Language of instruction Norwegian
Location Trondheim
Examination arrangement Aggregate score

About

About the course

Course content

Basic introduction to data modelling with emphasis on Entitity Relationship modelling. The relational model, relational algebra and SQL. Database construction. Normalization as a design theory for relational databases. Other database models. Storage technologies, file organization and index structures. Query processing. Database management systems (DBMS). Transactions, concurrency and recovery. Data integrity.

Learning outcome

Learning outcome

Knowledge of:

By completion of this course, the candidate should explain:

1. Database management systems - general characteristics and system structure.

2. Data modeling with an emphasis on entity-relationship models.

3. Relational database model for database systems, database schema and data integrity.

4. Query Languages : Relational Algebra and SQL.

5. Design theory for relational databases.

6. System Design and programming using database systems.

7. Data storage, file organization and index structures.

8. Execution of database queries.

9. Transactions, concurrency, and robustness against errors.

Skills:

By completion of this course, the candidate should demonstrate:

1. Data modeling with entity-relationship model.

2. Realization of relational databases.

3. Database-Oriented Programming: SQL, relational algebra and database programming in Python.

4. Evaluation and improvement of relational database schema based on normalization theory.

5. Analysis and optimization of the performance of database systems.

General qualifications:

By completion of this course, the candidate should explain / demonstrate:

1. Knowledge of applications of database systems and understanding of the benefits and limitations of such systems.

2. Modelling and analytical approach to computer technical problems.

Learning methods and activities

The course consists of lectures, exercises, project work and self-tuition.

There are mandatory exercises which must be completed.

Compulsory assignments

  • Exercises

Further on evaluation

Exercises must be approved to get an evaluation in the course.

At re-take of the course, parts of the assessment ("delvurderinger") may de done without the need to re-take all parts.

A re-sit examination might be arranged for both the midterm and the school exam.

The re-sit examination for the school exam and the midterm is held in August.

If there is a re-sit examination, the examination form may change from written to oral. This applies to both the midterm and the school exam.

In the event of voluntary repetition, fail (F) or valid absence, the project work must be retaken in a semester with teaching

Course materials

Given at the start of the course.

Credit reductions

Course code Reduction From
SIF8020 7.5 sp
MNFIT167 7.5 sp
MNFIT167 7.5 sp
IT1607 7.5 sp Spring 2006
IT167 7.5 sp Spring 2006
IDATT2002 3.7 sp Autumn 2025
IDATA2002 3.7 sp Autumn 2025
IDATG2002 3.7 sp Autumn 2025
This course has academic overlap with the courses in the table above. If you take overlapping courses, you will receive a credit reduction in the course where you have the lowest grade. If the grades are the same, the reduction will be applied to the course completed most recently.

Subject areas

  • Informatics
  • Technological subjects

Contact information

Course coordinator

Lecturers

Department with academic responsibility

Department of Computer Science

Examination

Examination

Examination arrangement: Aggregate score
Grade: Letter grades

Ordinary examination - Spring 2026

Midterm
Weighting 30/100 Examination aids Code D Duration 2 hours Exam system Inspera Assessment
School exam
Weighting 40/100 Examination aids Code D Duration 3 hours Exam system Inspera Assessment Place and room Not specified yet.
Project work
Weighting 30/100

Re-sit examination - Summer 2026

Midterm
Weighting 30/100 Examination aids Code D Duration 2 hours Exam system Inspera Assessment
School exam
Weighting 40/100 Examination aids Code D Duration 3 hours Exam system Inspera Assessment Place and room Not specified yet.