Skip to main content

DatabasesLaajuus (5 cr)

Code: 5051264

Credits

5 op

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

Enrollment

01.06.2024 - 15.09.2024

Timing

02.09.2024 - 15.12.2024

Number of ECTS credits allocated

5 op

Mode of delivery

Contact teaching

Unit

Engineering and Business

Campus

Kupittaa Campus

Teaching languages
  • Finnish
  • English
Seats

30 - 60

Teachers
  • Tiina Ferm
Groups
  • PTIVIS23H
    Health Technology

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

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.

Evaluation scale

H-5

Assessment methods and criteria

Assessment is completely based on exercises. NOTE! exercises returned late are not assessed



- 5 mandatory class exercises, assessment pass/fail during the class (there are total of 10 class exercises).
- 5 quiz, each 5 points
- 5 DBlabs, each 5 points


if all 5 mandatory class exercises are passed the grade is 1
each 10 points from quizzes and labs add 1 grade
If a student fails a mandatory class exercise, points from quizzes and labs are used to compensate it and10 points compensate for one class exercise.

Assessment criteria, fail (0)

missing mandatory accepted class exercises and not enough points to compensate them

Assessment criteria, satisfactory (1-2)

all mandatory class exercises done (grade 1) and additional 10 points (grade 2)

Assessment criteria, good (3-4)

all mandatory class exercises done (grade 1) and additional 20 points (grade 3) or 30 (grade 4)

Assessment criteria, excellent (5)

all mandatory class exercises done (grade 1) and additional 40 points (grade 5)

all mandatory class exercises done (grade 1) and additional 50 points (grade 5 and 6 credits)

Enrollment

01.06.2023 - 17.09.2023

Timing

04.09.2023 - 31.12.2023

Number of ECTS credits allocated

5 op

Mode of delivery

Contact teaching

Unit

Engineering and Business

Campus

Kupittaa Campus

Teaching languages
  • English
Seats

20 - 60

Degree programmes
  • Degree Programme in Information and Communication Technology
  • Degree Programme in Information and Communications Technology
Teachers
  • Tiina Ferm
Groups
  • PTIVIS22H
    Health Technology

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

Teaching methods

learning by doing

International connections

Weekly topics are handled with
- lecture
- examples
- assessed network exercises
- db excercise

Completion alternatives

The complete course can be completed with an exam. The date will be agreed upon during the first lesson.

Student workload

lessons and rehearsals 45h
assessed network exercises 45h
DB exercises 45h

Content scheduling

Using a database (QBE, SQL)
Planning and implementing a database (entity analysis, ER model, DB structure model, populating a database)

Evaluation scale

H-5

Assessment methods and criteria

Every exercise is worth 5-10 points, max 100 changed 14.11.2023 max 80p
Points are cumulative and have no weight.
Only exercises returned in time are evaluated.

Network exercises (40 points)
Lab works (40 points)    

Assessment criteria, fail (0)

< 40% or ( 32/80 points hanged 14.11.2023)

Assessment criteria, satisfactory (1-2)

40 - 59%

Assessment criteria, good (3-4)

60 - 79%

Assessment criteria, excellent (5)

>80%
>90% grade5 and 6 credits

Enrollment

01.06.2022 - 28.08.2022

Timing

05.09.2022 - 22.12.2022

Number of ECTS credits allocated

5 op

Mode of delivery

Contact teaching

Unit

Engineering and Business

Campus

Kupittaa Campus

Teaching languages
  • Finnish
Degree programmes
  • Degree Programme in Information and Communication Technology
  • Degree Programme in Information and Communications Technology
Teachers
  • Tiina Ferm
Teacher in charge

Tiina Ferm

Groups
  • PTIVIS21H
    Terveysteknologia

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

Teaching methods

learning by doing

International connections

Weekly topics are handled with
- lecture
- examples
- assessed network exercises
- db excercise

Completion alternatives

The complete course can be completed with an exam. The date will be agreed upon during the first lesson.

Student workload

lessons and rehearsals 45h
assessed network exercises 45h
DB exercises 45h

Content scheduling

Using a database (QBE, SQL)
Planning and implementing a database (entity analysis, ER model, DB structure model, populating a database)

Evaluation scale

H-5

Assessment methods and criteria

Every exercise is worth 5 points, max 100
Points are cumulative and have no weight.
Only exercises returned in time are evaluated.

Assessment criteria, fail (0)

< 40% or ( 40/100 points)

Assessment criteria, satisfactory (1-2)

40 - 59%

Assessment criteria, good (3-4)

60 - 79%

Assessment criteria, excellent (5)

>80%
>90% grade5 and 6 credits