Course GIK2LK

Database Systems

7.5 Credits
First Cycle
To Syllabus

Starts week 3, 2024

The overall goal is that students shall acquire knowledge about the principles and methods for designing and using relational databases.
After completing the course the student shall be able to:

Knowledge and understanding
  • explain the importance of normalisation when designing relational databases
  • explain the importance of designing good identifiers for database tables

Skills and abilities
  • apply basic principles of relational databases in accordance with the relational model
  • use conceptual modeling and graphical description techniques for designing relational databases corresponding to the third normal form
  • manipulate (search, add, modify and delete) data, and create, modify and delete database objects (tables, constraints, procedures, functions, triggers) using SQL and PL/SQL
  • use normalisation to analyse, verify and modify a data model to meet 3NF
Starts and ends:
week 3, 2024 - week 22, 2024
Study Rate:
Flexible rate (25%)
Location:
Flexible (Borlänge)
Time of Day:
Mixed
Teaching form:
Distance
Language:
Swedish
Other:
P: Course only offered as part of programme.
Entry Qualifications :
  • Object-Oriented Programming 7.5 Credits, First cycle or other course in Fundamentals of Programming
Selection :
Guarenteed admission
Application Code:
HDA-V3HJ9
Main field of study:
Online Education
Compulsory meetings:
0 physical
0 online
Computer Skills:

Surf on the Internet, read and send emails, use a word-processing programme (e.g. Word). Connect a camera and headphones to the computer and install a programme using instructions.

Computer Capacity:

Access to a computer (Not a mini pc, tablet or similar) that is not older than two years (or equivalent) and broadband connection, at least 2 Mbit/s (not mobile broadband, because mobile broadband can vary considerably in speed).

Means of Education:

Higher rate of web-based communication where our learning platform (Learn/Canvas) is a natural element of the course. Web-based meetings with sound and image where simple presentations can be held. Lectures can be broadcast live or can alternatively be made available afterwards online.

Tuition Fee
First Tuition Fee Installment:
16,875 SEK
Total Tuition Fee:
16,875 SEK
EU/EEA Citizens or exchange students are not required to pay fees.
Information on application and tuition fees: www.universityadmissions.se.
Closed for late application
Literature List

Literature lists are published at the latest one month ahead of the course start date.

To Literature List
How may we help you?

Ask us about studying at Dalarna University.
support@du.se
+46 23-77 88 88

Course room in Learn

In the learning platform Learn you can find more information about the course.

Visit the course room
Course Coordinator
Pär Douhan