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. Protection against improper use and unauthorized access.

Learning outcome

The course gives fundamental knowledge and skills in data modelling, databases and database management systems (DBMS).

Learning methods and activities

The course consists of lectures, exercises, project work and self-tuition. Students of Studieprogram Datateknikk and students of Studieprogram Kommunikasjonsteknologi have to carry through a joint project with TTM4100, TDT4140 and TDT4180 (Datateknikk only). The joint project is co-ordinated from TDT4140. Other students have to carry through a mandatory project. If there is a re-sit examination, the examination form may change from written to oral.

Compulsory assignments

• Exercises

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.

Course materials

Given at the start of the course.

Credit reductions