Databases (3 cr)

Code: KL25AB77000-3011

General information

Enrollment: 22.04.2025 - 03.09.2025; Registration for the implementation has begun.

Timing: 25.08.2025 - 12.10.2025; The implementation has not yet started.

Number of ECTS credits allocated: 3 cr

Local portion: 3 cr

Mode of delivery: Contact learning

Unit: SeAMK Automation Engineering and Information Technology

Campus: SeAMK Seinäjoki, Frami

Teaching languages: Finnish

Degree programmes: Bachelor of Engineering, Automation Engineering

Teachers: Jarkko Loima

Groups: AUTE24SA
Degree Programme in Automation Engineering, Full-time studies

Course: KL25AB77000

Evaluation scale

1-5

Objective

The aim of the course is to familiarize the student with the basics of data warehouse. The student understands the relational database and document-base NoSql-database and learns the stages of the information analysis. Students will have command of SQL language. The student learns to use international sources in database design.

Content

The course comprises the following:
- Data warehouseing
- Relational databases
- Conceptual modelling
- ER (Entity-Relationship)-modelling
- Main features of SQL (Structured Query Language)

Materials

Lecture materials,
Additional material: Hovi, Huotari, Lahdenmäki. Tietokantojen suunnittelu ja indeksointi, Docendo
Connolly Thomas - Begg Carolyn: Database Systems, Addison Wesley

Teaching methods

Lectures and exercises

Student workload

scheduled studies 50% and autonomous studies 50%

Assessment criteria, satisfactory (1)

- Satisfactory (1-2) The student knows the basics

Assessment criteria, good (3)

- Good (3-4): The student is familiar with the principles of database design and basic of SQL language

Assessment criteria, excellent (5)

- Excellent (5): The student is able to apply the principles of database design in his/her exercises, and dominates the SQL language

Qualifications

No previous studies are required.