Databases (3 cr)

Code: AE00CM69-3002

General information

Enrollment: 17.04.2023 - 11.10.2023
Registration for the implementation has ended.

Timing: 23.10.2023 - 17.12.2023
Implementation has ended.

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: English

Degree programmes: Bachelor of Engineering, Automation Engineering

Teachers: Marko Hietamäki

Groups: AE22
Bachelor of Engineering, Automation Engineering

Course: AE00CM69

Evaluation scale

1-5

Objective

The student understands the concept of database and database management system. Student knows how database is designed and how information is analyzed and modeled. Student can transform entity-relationship model to a relational model, and the to relation database. Student knows the SQL programming language and can make queries and other operations to database, also from other programs. Student knows the basics of NoSQL databases.

Content

- Concepts of databases and database management systems
- Relational databases
- Conceptual modelling
- ER (Entity-Relationship) modelling
- SQL (Structured Query Language)
- Basics of NoSQL databases

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)

The student understands the concept of database. Student knows how database is designed and how information is modeled. Student knows the basics of SQL programming language and can make queries and other operations to database.

Assessment criteria, good (3)

Assessment criteria, excellent (5)

The student understands the concept of database and database management system. Student knows how database is designed and how information is analyzed and modeled. Student can transform entity-relationship model to a relational model, and the to relation database. Student masters the SQL programming language and can make queries and other operations to database, also from other programs. Student can develop applications, which use NoSQL databases.

Qualifications

- Basics of programming