course-details-portlet

TDT4145 - Data Modelling, Databases and Database Management Systems

About

Examination arrangement

Examination arrangement: Aggregate score
Grade: Letter grades

Evaluation Weighting Duration Grade deviation Examination aids
School exam 40/100 3 hours D
Project work 30/100
Midterm 30/100 2 hours D

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 written exam.

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

Course materials

Given at the start of the course.

Credit reductions

Course code Reduction From To
SIF8020 7.5
MNFIT167 7.5
MNFIT167 7.5
IT1607 7.5 SPRING 2006
IT167 7.5 SPRING 2006
More on the course

Facts

Version: 1
Credits:  7.5 SP
Study level: Intermediate course, level II

Coursework

Term no.: 1
Teaching semester:  SPRING 2025

Language of instruction: Norwegian

Location: Trondheim

Subject area(s)
  • Informatics
  • Technological subjects
Contact information
Course coordinator: Lecturer(s):

Department with academic responsibility
Department of Computer Science

Timetable

List view
Calendar view

Examination

Examination arrangement: Aggregate score

Term Status code Evaluation Weighting Examination aids Date Time Examination system Room *
Spring ORD Midterm 30/100 D 2025-02-25 14:00 INSPERA
Room Building Number of candidates
SL311 orange sone Sluppenvegen 14 65
SL310 turkis sone Sluppenvegen 14 59
SL310 blå sone Sluppenvegen 14 48
SL310 hvit sone Sluppenvegen 14 46
SL311 lyseblå sone Sluppenvegen 14 22
SL319 Sluppenvegen 14 0
SL322 Sluppenvegen 14 0
SL324 Sluppenvegen 14 0
SL425 Sluppenvegen 14 0
SL415 Sluppenvegen 14 53
SL410 orange sone Sluppenvegen 14 58
SL410 blå sone Sluppenvegen 14 51
SL311 brun sone Sluppenvegen 14 82
SL310 lilla sone Sluppenvegen 14 80
SL311 grønn sone Sluppenvegen 14 68
Spring ORD School exam 40/100 D 2025-06-05 15:00 INSPERA
Room Building Number of candidates
SL110 lilla sone Sluppenvegen 14 7
SL111 brun sone Sluppenvegen 14 26
SL110 turkis sone Sluppenvegen 14 41
SL111 grønn sone Sluppenvegen 14 50
SL111 orange sone Sluppenvegen 14 60
SL410 orange sone Sluppenvegen 14 58
SL311 grønn sone Sluppenvegen 14 55
SL111 blå sone Sluppenvegen 14 36
SL111 lyseblå sone Sluppenvegen 14 72
SL110 hvit sone Sluppenvegen 14 64
SL311 brun sone Sluppenvegen 14 8
SL210 Sluppenvegen 14 51
SL410 blå sone Sluppenvegen 14 51
Spring ORD Project work 30/100

Submission
2025-03-21


14:00

Room Building Number of candidates
Summer UTS Midterm 30/100 D INSPERA
Room Building Number of candidates
Summer UTS School exam 40/100 D INSPERA
Room Building Number of candidates
  • * The location (room) for a written examination is published 3 days before examination date. If more than one room is listed, you will find your room at Studentweb.
Examination

For more information regarding registration for examination and examination procedures, see "Innsida - Exams"

More on examinations at NTNU