Databases (5 cr)
Code: 5051264-3006
General information
- Enrollment
-
01.06.2024 - 15.09.2024
Registration for the implementation has ended.
- Timing
-
02.09.2024 - 15.12.2024
Implementation has ended.
- Number of ECTS credits allocated
- 5 cr
- Local portion
- 5 cr
- Mode of delivery
- Contact learning
- Unit
- Engineering and Business
- Campus
- Kupittaa Campus
- Teaching languages
- Finnish
- English
- Seats
- 30 - 60
Realization has 23 reservations. Total duration of reservations is 67 h 0 min.
| Time | Topic | Location |
|---|---|---|
|
Tue 03.09.2024 time 12:00 - 14:00 (2 h 0 min) |
Theory, Tietokannat 5051264-3006 |
ICT_B3048
Terveysteknologia laboratorio/ teoriatila
|
|
Tue 10.09.2024 time 12:00 - 14:00 (2 h 0 min) |
Theory, Tietokannat 5051264-3006 |
ICT_B3048
Terveysteknologia laboratorio/ teoriatila
|
|
Fri 13.09.2024 time 13:00 - 16:00 (3 h 0 min) |
Practice, Tietokannat 5051264-3006 |
ICT_C2027
IT telakka
|
|
Tue 17.09.2024 time 12:00 - 14:00 (2 h 0 min) |
Theory, Tietokannat 5051264-3006 |
ICT_B3048
Terveysteknologia laboratorio/ teoriatila
|
|
Fri 20.09.2024 time 12:00 - 16:00 (4 h 0 min) |
Practice, Tietokannat 5051264-3006 |
ICT_C2027
IT telakka
|
|
Tue 24.09.2024 time 12:00 - 14:00 (2 h 0 min) |
Theory, Tietokannat 5051264-3006 |
ICT_B3048
Terveysteknologia laboratorio/ teoriatila
|
|
Fri 27.09.2024 time 12:00 - 16:00 (4 h 0 min) |
Practice, Tietokannat 5051264-3006 |
ICT_C2027
IT telakka
|
|
Tue 01.10.2024 time 12:00 - 14:00 (2 h 0 min) |
Theory, Tietokannat 5051264-3006 |
ICT_B3048
Terveysteknologia laboratorio/ teoriatila
|
|
Fri 04.10.2024 time 12:00 - 16:00 (4 h 0 min) |
Practice, Tietokannat 5051264-3006 |
ICT_C2027
IT telakka
|
|
Tue 08.10.2024 time 12:00 - 14:00 (2 h 0 min) |
Theory, Tietokannat 5051264-3006 |
ICT_B3048
Terveysteknologia laboratorio/ teoriatila
|
|
Fri 11.10.2024 time 12:00 - 16:00 (4 h 0 min) |
Practice, Tietokannat 5051264-3006 |
ICT_C2027
IT telakka
|
|
Tue 22.10.2024 time 12:00 - 14:00 (2 h 0 min) |
Theory, Tietokannat 5051264-3006 |
ICT_B3048
Terveysteknologia laboratorio/ teoriatila
|
|
Fri 25.10.2024 time 12:00 - 16:00 (4 h 0 min) |
Practice, Tietokannat 5051264-3006 |
ICT_C2027
IT telakka
|
|
Tue 29.10.2024 time 12:00 - 14:00 (2 h 0 min) |
Theory, Tietokannat 5051264-3006 |
ICT_B3048
Terveysteknologia laboratorio/ teoriatila
|
|
Fri 01.11.2024 time 12:00 - 16:00 (4 h 0 min) |
Practice, Tietokannat 5051264-3006 |
ICT_C2027
IT telakka
|
|
Tue 05.11.2024 time 12:00 - 14:00 (2 h 0 min) |
Theory, Tietokannat 5051264-3006 |
ICT_B3048
Terveysteknologia laboratorio/ teoriatila
|
|
Fri 08.11.2024 time 12:00 - 16:00 (4 h 0 min) |
Practice, Tietokannat 5051264-3006 |
ICT_C2027
IT telakka
|
|
Tue 12.11.2024 time 12:00 - 14:00 (2 h 0 min) |
Theory, Tietokannat 5051264-3006 |
ICT_B3048
Terveysteknologia laboratorio/ teoriatila
|
|
Fri 15.11.2024 time 12:00 - 16:00 (4 h 0 min) |
Practice, Tietokannat 5051264-3006 |
ICT_C2027
IT telakka
|
|
Tue 19.11.2024 time 12:00 - 14:00 (2 h 0 min) |
Theory, Tietokannat 5051264-3006 |
ICT_B3048
Terveysteknologia laboratorio/ teoriatila
|
|
Fri 22.11.2024 time 12:00 - 16:00 (4 h 0 min) |
Practice, Tietokannat 5051264-3006 |
ICT_C2027
IT telakka
|
|
Tue 26.11.2024 time 12:00 - 14:00 (2 h 0 min) |
Theory, Tietokannat 5051264-3006 |
ICT_B3048
Terveysteknologia laboratorio/ teoriatila
|
|
Fri 13.12.2024 time 12:00 - 16:00 (4 h 0 min) |
Practice, Tietokannat 5051264-3006 |
ICT_C2027
IT telakka
|
Evaluation scale
H-5
Content scheduling
Using a database (QBE, SQL)
Planning and implementing a database (entity analysis, ER model, DB structure model, populating a database)
During the Database (autumn 2024) and Object-oriented Programming (spring 2025) courses we are developing an application for a business case EhtoisatEllit. Every (database and OO-program) version reflects the evolution of Ehtoisat Ellit business from estate management company to home and care service provider and their needs at each stage.
Objective
After completing the course the student is able to:
- understand different types of databases and evaluate their feasibility for different purposes.
- plan and implement a database based on requirements and search and modify data in the database
- use at least one well-known database management system
- describe database management tasks
Content
- Different types of databases
- Definition, planning and implementation of databases
- SQL basics
- Database administration with DBMS
- Management principles for databases
Materials
course material in itslearning
Recomended reading:
SQL in Easy Steps, 4th Edition : Ideal for Those Who Want to Master SQL Essentials
Mike McGrath
and
Database Modeling and Design : Logical Design
Book Cover Image
by Toby J. Teorey, , Sam S. Lightstone, , Tom Nadeau, , and H.V. Jagadish
Teaching methods
learning by doing
Exam schedules
Assessment is completely based on exercises.
The complete course can be completed with an exam. The date will be agreed upon during the first lesson, but must be within the 1st month (September).
There is no retake for the compensating exam.
International connections
Weekly topics are handled with
- lecture
- examples
- class exercises, that are returned
- assessed network exercises
- db exercises
Completion alternatives
The complete course can be completed with an exam. The date will be agreed upon during the first lesson, but must be within the 1st month (September).
The exam is an e-exam done in TUAS e-exam room using Ville system.
The compensating exam can only be taken if a student is enrolled to the course.
Student workload
lessons and rehearsals 45h
assessed network exercises 45h
DB exercises 45h