After a successful course, the student shall:

- demonstrate comprehension of a relational database (function, architecture and limits)
- display knowledge of fundamental database design principles
- display knowledge of transaction management, indexing and file organization within databases
- demonstrate comprehension of the main differences between relational and non-relational databases

- demonstrate the ability to design an ER-model from a provided business description
- demonstrate the ability to apply the first three normalization forms
- demonstrate the ability to formulate basic and advanced SQL queries
- demonstrate the ability to interpret SQL expressions and comprehend the obtained results

The purpose of the course is to introduce and experience Database design and querying.
After a successful course, the student shall master basics of relation databases and be able to model, design and query databases.

The course includes the following topics:
- Relational Databases - Introduction, Theory, Purpose
- Database Design - ER model
- Normalization
- Structured Query Language and Query writing
- Multi-table Queries - Joins, Relations
- Usage of databases and database systems with software and/or mobile development
- Advanced SQL, Transactions, Indexing

Tuition will consist of lectures, exercises and lab work.

The teaching is conducted in English.

General entry requirements and completed courses in Introduction to Programming, 9 credits (or the equivalent).

The course is graded 5,4,3 or Fail.

Name of the Test	Value	Grading
Examination1	4 credits	5/4/3/U
Practical Assignment	2 credits	U/G

¹ Determines the final grade of the course, which is issued only when all course units have been passed.

The literature list for the course will be provided 8 weeks before the course starts.

Title: Fundamentals of Database Systems, Seventh Edition
Author: Elmasri & Navathe
Publisher: Pearson
ISBN: 978-1-292-09761-9