Study Guide

Objective

The students know the principles of relational databases, can design and implement a simple database, know how to use relational database software and a completed database in the query language.
After the course the students will understand the central role of databases in information systems. The students will also understand the growing importance of databases with the growth and improvement of hardware, software and data transfer capacity. Key operating environments include WWW, electronic commerce, data generated by sensor networks, the Internet of Things and mobile environments.

Content

SQL basic functions
SQL commands
SQL and programming language
Basics of the relationship model
Basic operations of the relationship algebra
Relationship assignments
MySQL exercises, creating a database for a MySQL server
ASSIGNMENT (Learning assignment) (Design, ER model, creating a database, adding data, implementing a client-server program to manage database events)

Location and time

Lukujärjestyksen mukaan

Materials

Kaikki kurssimateriaali on saatavilla Moodlessa, kurssiavaimen saa opettajalta.

Teaching methods

Luennot ja harjoitukset, vapaaehtoinen harjoitustyö

Employer connections

-

Exam schedules

Loppukoe jakson viimeisellä viikolla, tarkempi päivämäärä ilmoitetaan myöhemmin.

Completion alternatives

Sovittava erikseen opettajan kanssa

Student workload

Luennot ja harjoitukset 40 h, itsenäinen opiskelu 40 h.

Content scheduling

Tietokantojen suunnittelu
ER-mallinnus
Eheysvaatimukset
Normalisointi
SQL-kielen perusteet
Haku useammasta taulusta
Sisäkkäiset SQL-lauseet ja koostefunktiot
Taulujen luominen ja muokkaaminen SQL-kyselyillä

Evaluation scale

0 - 5

Assessment criteria, excellent (5)

The students are able to design and build a 3. normal format relational database from a given subject and to follow the theoretical rules given in the assignment
The students are able to perform demanding searches from the database with sql sentences.
The students have mastered updating the database in sql sentences.

Assessment criteria, good (3)

The students are able to explain the structure , the keys and the reference keys of a relational database
The students are able to draw an ER diagram of the given object and determine the database tables, the table attributes and the keys from a chart.
The students are able to explain the purpose of normalization and can initially normalize the database to the third normal database format
The students are able to retrieve data from the given database with SQL statements and different conditions and update the database with SQL statements.
The students are able to create a simple database with one of the database management software.

Assessment criteria, satisfactory (1)

The students can determine what a relational database is.
The students are able to name entities, attributes, and concepts in a completed ER diagram.
The students are able to draw a simple ER diagram of the given object and determine tables from the charts.
The students are able to give examples of table and reference keys.
The students are able to write simple SQL statements.
The students are able to create under supervision, a simple database with one of the database management software.

Assessment criteria, excellent (5)

Opiskelija hallitsee laaja-alaisesti tietokantojen suunnittelun periaatteet ja osaa soveltaa SQL-kieltä käytännön tehtävissä monipuolisesti ja innovatiivisesti

Toteutuksen arviointikriteerit, hyvä (3-4)

Opiskelija hallitsee hyvin tietokantojen suunnittelun periaatteet ja osaa soveltaa SQL-kieltä käytännön tehtävissä

Assessment criteria, satisfactory (1)

Opiskelija ymmärtää tietokantojen suunnittelun sekä SQL-kielen perusteet