Syllabus

Relational Databases

Code
GIK2YK
Points
7.5 Credits
Level
First Cycle
School
School of Information and Engineering
Subject field
Information Systems (IKA)
This course can be included in the following main field(s) of study
Information Systems1
Microdata Analysis2
Progression indicator within (each) main field of study
1G1F
2G1F
Approved
Approved, 29 November 2022.
This syllabus is valid from 29 November 2022.
Download as pdf To course page

Learning Outcomes

Knowledge and Understanding

Upon completion of the course, the students will be able to:

  • explain the importance of normalization for a design solution of a relational database
  • explain the importance of clear identifiers for tables in relational databases

Skills and Abilities
Upon completion of the course, the students will be able to:

  • apply basic principles of relational databases in accordance with the relational model
  • use conceptual modelling and graphical description techniques to design relational databases that conform to at least third normal form
  • manipulate data and database objects
  • use normalization to analyze, verify, and modify a data model  

Course Content

The course covers the principles and methods for designing and using relational databases. The course introduces the database concept, systems theory, and basic design principles for relational databases. The course includes methods for developing database systems. The course also deals with how and why databases are used in companies, by authorities and in organisations.

Assessment

  • Lab report
  • Home examination

Grades

The grading scale used for the final course grade is U–G.

Grades are reported as follows:

  • Lab report - 4 Credits | U–G
  • Home examination - 3.5 Credits | U–G

Prerequisites

  • Software Development Technology, 7.5 credits or equivalent foundational programming course 7.5 credits

Other Information

This course cannot be counted towards the same degree along with courses that have equivalent content.

If the student has received a decision/recommendation granting study support from Dalarna University because of a disability, then the examiner has the right to offer an alternative examination arrangement. The examiner takes into account the objectives in the course syllabus when deciding whether the examination can be adapted in accordance with the decision/recommendation.