EPN-V2

DATA1500 Databases Course description

Course name in Norwegian
Databaser
Study programme
Bachelor in Applied Computer Technology
Bachelor's Degree Programme in Software Engineering
Bachelor's Degree Programme in Information Technology
Weight
10.0 ECTS
Year of study
2020/2021
Curriculum
SPRING 2021
Schedule
Programme description
Course history

Introduction

Two internal examiners. External examiners are used regularly.

Required preliminary courses

Emnet er ekvivalent (overlapper 10 studiepoeng) med LO124D.

Learning outcomes

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

Teaching and learning methods

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

Course requirements

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

  • 12 individual assignments

Assessment

Individual written exam, 3 hours

The exam result can be appealed.

Permitted exam materials and equipment

None.

Grading scale

Grade scale spring 2021:

Pass-Fail

[Grade scale earlier]:

Grade scale A-F.

Examiners

One internal examiner. External examiners are used regularly.

Overlapping courses

Emnet er ekvivalent (overlapper 10 studiepoeng) med: DATS1500, ITPE1500, ADTE1500, LO149A, LO149D og LO149I.

Ved praktisering av 3-gangers regelen for oppmelding til eksamen teller forsøk brukt i ekvivalente emner.