Databases (4cr)
Code: KL00CQ20-3006
General information
- Enrollment
- 22.04.2025 - 03.09.2025
- Registration for the implementation has ended.
- Timing
- 25.08.2025 - 12.10.2025
- Implementation is running.
- Number of ECTS credits allocated
- 4 cr
- Local portion
- 4 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, Information Technology
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
Tunnilla jaettava materiaali
Teaching methods
Lähiopetus ja tehtävät verkossa
Student workload
4 OP, josta 35 tuntia lähiopetusta
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)
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. Student knows the basics of NoSQL databases.
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.