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)

Evaluation scale

0 - 5

Arviointikriteerit, kiitettävä (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.

Arviointikriteerit, tyydyttävä (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.