Study Guide

Objective

Students will know the principles of relational databases, being able to plan and create a simple database, use relational database software and the ready database using query language.

Content

The basic concepts of databases
ER modelling
Normalisation
Basic Functions of SQL

Materials

Kaikki kurssin materiaali on saatavilla Repussa.
Kysy kurssiavain opettajalta.

Teaching methods

Luennot ja harjoitukset.
Kurssin voi suorittaa myös itsenäisesti Repun materiaalin avulla.

Employer connections

-

Exam schedules

Loppukoe viimeisellä viikolla lukujärjestyksen mukaisesti.

Completion alternatives

Kurssin voi suorittaa itsenäisesti tekemällä palautettavat tehtävät ja harjoitustyön sekä osallistumalla loppukokeeseen.

Student workload

Luennot ja harjoitukset 40 h
Itsenäinen työskentely 40 h

Content scheduling

Relaatiotietokannan mallintaminen
Tietokannan normalisointi ja eheysvaatimukset
SQL:n perusteet
SELECT-lause
Haku useasta taulusta
Sisäkkäiset SELECT-lauseet
Tilastolliset koostefunktiot
Taulujen luonti ja muuttaminen

Evaluation scale

0 - 5

Assessment criteria, excellent (5)

The students are able to plan and build a third normalized relational database from a given target and can follow theoretical rules given during their work. They are able to carry out demanding searches within the database using sql statements. They are proficient in updating the database using sql statements.

Assessment criteria, good (3)

The students are able to explain the structure, keys and reference keys of a relational database and can draw an ER diagram of a given target and define the database's tables, their attributes and keys from the diagram. The students are able to explain the meaning of normalization and can initially normalize a database into a third normalized form. They are able to search for information from a given database using sql statements with different terms and to update the database using sql statements. They know how to form a simple database using database management software.

Assessment criteria, satisfactory (1)

The students know how to define a relational database ans can name entities, attributes and concepts from an ER diagram. They are able to draw a simple ER model from a given target and to define tables from the diagram. The students know how to give examples of the keys of the tables and reference keys. The students know how to write simple sql statements and can form a simple a database under supervision using database management software.

Assessment methods and criteria

Loppukoe, harjoitustyö ja kolme palautettavaa tehtävää

Further information

Kurssin voi suorittaa verkko-opintoina