Databases 2

7.5 credits

Syllabus, Bachelor's level, 2IS227

A revised version of the syllabus is available.

Code: 2IS227
Education cycle: First cycle
Main field(s) of study and in-depth level: Information Systems G1F
Grading system: Fail (U), Pass (G), Pass with distinction (VG)
Finalised by: The Department Board, 3 September 2019
Responsible department: Department of Informatics and Media

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 the 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:

summarize how NoSQL databases work,
explain what data warehouse, data mining and distributed databases are and how they relate to relational and NoSQL databases.

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

implement database transaction management,
apply advanced techniques in relational databases, such as indexes, views, triggers, cursors, and stored procedures,
design and manage NoSQL databases.

Regarding judgement and approach the student is expected to be able to on completion of the course:

discuss differences and similarities between NoSQL databases and relational databases,
reflect on how the use of databases and data storage can affect an individual, organisation, and society from an ethical perspective.

Content

The course deals in relational databases where transaction management and multi-user systems are studied with and SQL with exercises in working with views, indexes, triggers, cursors, and stored procedures.

Furthermore, different types of NoSQL databases are dealt with, focusing on their use in applications and their functionality. The course also addresses uses and design principles for different types of databases.

The course also addresses ethical aspects of how the design and use of different forms of databases and data storage affect individuals, organisations and society.

Instruction

The course is given in the form of lectures, seminars, and labs.

Assessment

The course is examined through seminars and assignments.

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.