General provisions

The course is included in the following degree programme:

Bachelor's Programme in Information Systems, specialisation software engineering 180 credits.

Entry requirements

30 credits in information systems or equivalent including 7.5 credits in databases

Learning outcomes

Regarding knowledge and understanding the student is expected to be able to on completion of the course:

• explain how NoSQL databases function and discuss their differences and similarities with relational databases,
• explain concepts relating to data warehouses, data mining and distributed databases, and relate them to relational databases and NoSQL databases.

Regarding competence and skills the student is expected to be able to on completion of the course:

• implement database transactions programmatically,
• apply advanced technologies in relational databases, for example index, views, triggers and stored procedures,
• design and manage NoSQL databases,
• implement database access using object-relational mapping (ORM) concepts.

Regarding judgement and approach the student should, on completion of the course, be able to:

• evaluate the suitability to apply relational databases and/or NoSQL databases to support information management needs in organisations.

Content

The course consists of two parts. The first part is a specialisation in relational databases where transaction management and multi-user systems are treated, as well as a specialisation in SQL. The second part of the course introduces various types of NoSQL databases with a focus on their use in applications and their functionality. Furthermore, the second part of the course addresses application domains as well as design considerations for database technologies.

Component 1: Relational databases 3 credits

The component contains a specialisation in relational databases and exercises to work with views index, triggers and stored procedures.

Component 2: NoSQL databases 2.5 credits

The component treats various types of NoSQL databases with a focus on their functionality and use.

Component 3: Databases 2 credits

Studies of and reflection on fields of use for relational databases and NoSQL databases, as well as how designs of various types of databases are influenced by technical preconditions and business needs.

Instruction

The course is given in the form of lectures and laboratory work.

Assessment

The course is examined through written assignments and written exam.

For the grade Pass in the whole course, it is required that all components are passed. To pass with distinction is required passed with distinction on at least two of the components.

If there are special reasons for doing so, an examiner may make an exception from the method of assessment indicated and allow a student to be assessed by another method. An example of special reasons might be a certificate regarding special pedagogical support from the University's disability coordinator or a decision by the department's working group for study matters.