Course - Data Modelling, Databases and Database Management Systems - TDT4145
TDT4145 - Data Modelling, Databases and Database Management Systems
About
Examination arrangement
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 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: 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 course, all parts of the assessment ("delvurderinger") must be re-done.
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.
Passed mandatory activity from earlier can be approved by the department.
Recommended previous knowledge
Knowledge and skills equivalent to TDT4109 - Information Technology, Introduction and TDT4120 Algorithms and Data Structures. Python is used as the programming language in projects and exercises.
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 |
Version: 1
Credits:
7.5 SP
Study level: Intermediate course, level II
Term no.: 1
Teaching semester: SPRING 2024
Language of instruction: Norwegian
Location: Trondheim
- Informatics
- Technological subjects
Department with academic responsibility
Department of Computer Science
Examination
Examination arrangement: Aggregate score
- Term Status code Evaluation Weighting Examination aids Date Time Examination system Room *
- Spring ORD Midterm 30/100 D 2024-02-26 10:00 INSPERA
-
Room Building Number of candidates SL322 Sluppenvegen 14 1 SL410 blå sone Sluppenvegen 14 51 SL311 lyseblå sone Sluppenvegen 14 96 SL311 orange sone Sluppenvegen 14 65 SL410 orange sone Sluppenvegen 14 57 SL311 Sluppenvegen 14 311 SL311 brun sone Sluppenvegen 14 82 SL311 grønn sone Sluppenvegen 14 68 SL310 hvit sone Sluppenvegen 14 46 SL310 lilla sone Sluppenvegen 14 80 SL310 Sluppenvegen 14 232 SL318 Sluppenvegen 14 1 SL319 Sluppenvegen 14 1 SL317 Sluppenvegen 14 1 SL415 Sluppenvegen 14 53 SL323 Sluppenvegen 14 1 SL324 Sluppenvegen 14 1 SL310 turkis sone Sluppenvegen 14 59 SL310 blå sone Sluppenvegen 14 48 - Spring ORD School exam 40/100 D 2024-06-05 09:00 INSPERA
-
Room Building Number of candidates SL111 orange sone Sluppenvegen 14 53 SL111 blå sone Sluppenvegen 14 36 SL111 brun sone Sluppenvegen 14 81 SL111 grønn sone Sluppenvegen 14 50 SL410 orange sone Sluppenvegen 14 58 SL110 turkis sone Sluppenvegen 14 80 SL110 lilla sone Sluppenvegen 14 64 SL111 lyseblå sone Sluppenvegen 14 72 SL410 blå sone Sluppenvegen 14 51 SL110 hvit sone Sluppenvegen 14 64 -
Spring
ORD
Project work
30/100
Submission
2024-03-22
INSPERA
14:00 -
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.
For more information regarding registration for examination and examination procedures, see "Innsida - Exams"