course-details-portlet

TDT4145 - Data Modelling, Databases and Database Management Systems

About

Examination arrangement

Examination arrangement: Written exam., Work and Midterm
Grade: Letters

Evaluation form Weighting Duration Examination aids Grade deviation
Semester test 30/100 2 hours
Home examination 30/100 2 hours
Assignment 40/100

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

Knowledge of:
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:
1. Data modeling with entity-relationship model.
2. Realization of relational databases.
3. Database-Oriented Programming: SQL, relational algebra and database programming in Java.
4. Evaluation and improvement of relational database schema based on normalization theory.
5. Analysis and optimization of the performance of database systems.
General qualifications:
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. Students must complete a compulsory project in databases to be allowed to participate in the exam. Additonally, there are mandatory exercises which must be completed.

Compulsory assignments

  • Project work
  • Exercises

Further on evaluation

Due to the Covid-19 situation, the assessment form has been changed for spring 2021. See the course description in Norwegian for more information.

Specific conditions

Exam registration requires that class registration is approved in the same semester. Compulsory activities from previous semester may be approved by the department.

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 01.08.2006
IT167 7.5 01.08.2006
Facts

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

Coursework

Term no.: 1
Teaching semester:  SPRING 2021

No.of lecture hours: 4
Lab hours: 4
No.of specialization hours: 4

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

Phone:

Examination

Examination arrangement: Written exam., Work and Midterm

Term Status code Evaluation form Weighting Examination aids Date Time Digital exam Room *
Summer UTS Semester test 30/100 INSPERA
Room Building Number of candidates
Spring ORD Semester test 30/100

Release 2021-03-04

Submission 2021-03-04

Release 10:00

Submission 12:00

INSPERA
Room Building Number of candidates
Summer UTS Home examination 30/100 INSPERA
Room Building Number of candidates
Spring ORD Home examination 30/100

Release 2021-06-11

Submission 2021-06-11

Release 09:00

Submission 11:00

INSPERA
Room Building Number of candidates
Summer UTS Assignment 40/100 INSPERA
Room Building Number of candidates
Spring ORD Assignment 40/100 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