Course - Data Modelling, Databases and Database Management Systems - TDT4145
Data Modelling, Databases and Database Management Systems
Choose study yearAbout
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 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.
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 |
|---|---|---|
| SIF8020 | 7.5 sp | |
| MNFIT167 | 7.5 sp | |
| MNFIT167 | 7.5 sp | |
| IT1607 | 7.5 sp | Spring 2006 |
| IT167 | 7.5 sp | Spring 2006 |
Subject areas
- Informatics
- Technological subjects