Databases (4 cr)
Code: TTC2020-3036
General information
- Enrollment
-
20.11.2023 - 04.01.2024
Registration for the implementation has ended.
- Timing
-
08.01.2024 - 30.04.2024
Implementation has ended.
- Number of ECTS credits allocated
- 4 cr
- Local portion
- 4 cr
- Mode of delivery
- Face-to-face
- Unit
- School of Technology
- Campus
- Lutakko Campus
- Teaching languages
- Finnish
- Seats
- 20 - 35
- Degree programmes
- Bachelor's Degree Programme in Information and Communications Technology
Realization has 8 reservations. Total duration of reservations is 21 h 0 min.
| Time | Topic | Location |
|---|---|---|
|
Tue 05.03.2024 time 11:15 - 13:45 (2 h 30 min) |
Tietokannat TTC2020-3036 |
P2_D327
CISCO-laboratorio
|
|
Tue 12.03.2024 time 11:15 - 13:45 (2 h 30 min) |
Tietokannat TTC2020-3036 |
P2_D327
CISCO-laboratorio
|
|
Tue 19.03.2024 time 11:15 - 13:45 (2 h 30 min) |
Tietokannat TTC2020-3036 |
P2_D327
CISCO-laboratorio
|
|
Tue 26.03.2024 time 11:15 - 13:45 (2 h 30 min) |
Tietokannat TTC2020-3036 |
P2_D327
CISCO-laboratorio
|
|
Tue 02.04.2024 time 11:15 - 13:45 (2 h 30 min) |
Tietokannat TTC2020-3036 |
P2_D327
CISCO-laboratorio
|
|
Tue 09.04.2024 time 11:15 - 13:45 (2 h 30 min) |
Tietokannat TTC2020-3036 |
P2_D327
CISCO-laboratorio
|
|
Tue 16.04.2024 time 11:00 - 14:00 (3 h 0 min) |
Tietokannat TTC2020-3036 / Koe |
Verkko/Zoom
|
|
Tue 23.04.2024 time 11:00 - 14:00 (3 h 0 min) |
Tietokannat TTC2020-3036 / Uusinta |
Verkko / Zoom
|
Evaluation scale
0-5
Objective
Purpose:
After completing this course you understand the significance of databases as part of information systems, you know the basic concepts of databases, you are able to create and read database descriptions and make basic queries using SQL (Structured Query Language).
EUR-ACE Competences:
Knowledge and Understanding
Engineering practice
Learning outcomes:
You know the basic concepts of databases, you understand the generic structure of database system and its operational principle, you can read and create a database description based on the assignment, and you know the basics of SQL.
Content
Basic concepts related to databases
Database design with conceptual analysis
Basics of SQL including database queries and database management.
Materials
Opintojakson verkkosivut (verkkomateriaali, videomateriaali, harjoitustehtävät)
Teaching methods
Luennot, harjoitusten ja harjoitustyön ohjaus. Osaamistesti.
Student workload
Luennot 24 h, harjoitukset 56 h, itsenäinen työskentely 28 h
Yhteensä 108 h
Assessment criteria, satisfactory (1)
Pass/Sufficient 1: You are able to design and implement a simple database by creating a connection between at least two tables using basic and reference keys and make simple queries with SQL.
Satisfactory 2: You are able to design and implement a database and make basic queries with SQL. The assignment documentation contains at the very least a database description.
Assessment criteria, good (3)
Good 3: The database completed as assignment and in the exam has been designed and implemented almost flawlessly and the student's command of SQL is versatile.
Very good 4: You are able to design and implement a database where the choices have been justified. You have a comprehensive understanding of SQL basic commands. The documentation of the assignment is thorough and the given presentation has been fluent.
Assessment criteria, excellent (5)
Excellent 5: You are able to design and implement an out of the ordinary database where the choices have been justified and the metadata saved. You are able to use SQL in demanding data retrieval tasks. The database documentation is extensive and understandable as well as well composed and fluently presented. You are able to critically assess your competence in your solutions.