Course - Data Modelling, Databases and Database Management Systems - TDT4145
TDT4145 - Data Modelling, Databases and Database Management Systems
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.
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.
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.
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.
- Project work
Further on evaluation
Exercises and projects completed the last three years will suffice to be allowed to attend the exam. All previous exercises and projects must be approved for this to happen, elsewise all exercises and projects must be done.
If there is a re-sit examination, the examination form may change from written to oral.
Exam registration requires that class registration is approved in the same semester. Compulsory activities from previous semester may be approved by the department.
Recommended previous knowledge
Knowledge and skills equivalent to TDT4100 Object-Oriented Programming and TDT4120 Algorithms and Data Structures. Java is used as the programming language in projects and exercises.
Given at the start of the course.
Credits: 7.5 SP
Study level: Intermediate course, level II
Term no.: 1
Teaching semester: SPRING 2021
No.of lecture hours: 4
Lab hours: 4
No.of specialization hours: 4
Language of instruction: Norwegian
- Technological subjects
Examination arrangement: Written examination and Midterm
- Term Status code Evaluation form Weighting Examination aids Date Time Digital exam Room *
- Spring ORD Semester test 30/100 D
Room Building Number of candidates
- Spring ORD Written examination 70/100 D
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"