Syllabus

Database Systems

Code
GIK2AL
Points
7.5 Credits
Level
First Cycle
School
School of Information and Engineering
Subject field
Information Systems (IKA)
Group of Subjects
Informatics/Computer and Systems Sciences
Disciplinary Domain
Technology, 100%
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 August 2019.
This syllabus is valid from 20 November 2019.
Download as pdf To course page

Learning Outcomes

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

Course Content

The course introduces the concept of database, system theory and basic design principles for relational databases. It provides a method to develop database systems. The course imparts knowledge on how and why databases are used in businesses, and private and public organisations.

Assessment

Written examination (3.5 credits) and written report on laboratory work (4 credits).

Forms of Study

Lectures and labs

Grades

The Swedish grades U–G.

Prerequisites

  • Object-Oriented Programming 7.5 Credits, First cycle or other course in Fundamentals of Programming

Other Information

The course is equivalent to Database Systems 7,5 credits, Qualification course in Database Systems for master programme in Business Intelligence 7,5 credits and the first 7,5 credits in the course Databases and Information Systems 15 credits.