EPN-V2

BV1100 Child protection in the welfare state - Mandate, profession and self-understanding Course description

Course name in Norwegian
Barnevern i velferdsstaten – mandat, profesjon og selvforståelse
Study programme
Bachelor Programme in Child Care and Welfare
Weight
10.0 ECTS
Year of study
2024/2025
Course history

Introduction

The students shall acquire knowledge of database design and skills in the use of relational databases. Furthermore, they shall develop skills in the construction and maintenance of databases and insight into multi-user and multi-layer database architecture. They will gain knowledge of XML and insight into programming for databases.

Required preliminary courses

After completing the course, the student is expected to have achieved the following learning outcomes defined in terms of knowledge, skills and general competence:

Knowledge

The student is capable of:

  • explaining what a database system is and what it consists of
  • explaining what XML is and how it is used
  • explaining what transactions are and how they are carried out
  • explaining the use of indices and different ways of storing the files physically
  • explaining what a data warehouse is and how it differs from a database system
  • explaining how the combination of ER modelling and normal forms provides well-structured relational databases

;

Skills

The student is capable of:

  • designing databases with the help of ER modelling
  • creating databases and using them with the help of the SQL language
  • drawing ER models and generating database scripts with the help of software

;

General competence

The student is capable of:

  • explaining the documentation and design of databases with ER models

Learning outcomes

Lectures and work on practical assignments. The weekly assignments will form the basis for the written assignments to be submitted.

Content

The exam in the course is a supervised exam of 5 hours.

Teaching and learning methods

The following coursework is compulsory and must be approved before the student can sit the exam:

  • 12 individual assignments

Course requirements

Individual written exam, 3 hours

The exam result can be appealed.

Assessment

None.

Permitted exam materials and equipment

Grade scale A-F.

Grading scale

The teaching methods will include both lectures and group work with practical examples and reviews of cases. The students will give oral presentations of reasoned conclusions. The course activities will also include discussions or adversarial consideration of disputed issues.

Examiners

The following coursework requirements must have been approved in order for the student to take the exam:

  • Coursework 1: Mandatory written assignment with a scope of 8-10 pages.

All required coursework must be completed and approved by the given deadline in order for the student to take the exam. If the coursework requirements have not been approved, the student will be given one opportunity to submit an improved version by the given deadline.