Databases (5 cr)

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)

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

Pedagogic approaches and sustainable development

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

Evaluation 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.

Failed (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

Further information

Opintojakso toteutetaan kampuksella. Tilat ilmoitetaan lukujärjestyksessä syksyn alussa