Course content

This topic covers the following topics:

Terminology related to databases. Data modeling and database design. Relational database systems and SQL. Database integrity. Normalization. Transaction handling and multi-user issues. Security. Introduction of alternatives to relational database (NoSQL). Link between database and programming.

Learning outcome

Knowledge: The candidate must:

• know central concepts (in Norwegian and English) within databases, and be able to explain these
• understand problems related to several simultaneous users of a database and know how these can be solved
• know the theory behind the relational model
• know about alternatives to relational databases (NoSQL and semi-structured data)

Skills: The candidate must:

• be able to create a separate database, and extract and change the data in this database, all via SQL
• see the connection between program code and underlying SQL / database
• be able to optimize SQL queries for performance
• be able to construct a data model (EER) for a given problem and translate this into the relational model
• could propose sustainable solutions for storing data related to normalization and re-use of data

General competence: The candidate must:

• gain an understanding of applying database solutions to solve various needs for the storage and representation of digital data
• gain an understanding of security challenges in database systems
• have an understanding of what good data quality is

Learning methods and activities

Teaching with practical exercises and discussion forum.

Compulsory assignments

• Compulsory exercises

Specific conditions

Recommended previous knowledge

Basic knowledge in programming.

Course materials

Given at the start of the course.

Credit reductions