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

Location and time

See the timetable

Materials

All course material is available in Reppu.
Ask the course key from the teacher.

Teaching methods

Lectures and exercises.
The course can also be completed independently with the help of the Repu material.

Employer connections

-

Exam schedules

The final exam will take place in the last week of the course according to the timetable. A re-examination is possible in the autumn following the course.

International connections

-

Completion alternatives

The course can be completed independently by completing the assignments and exercises to be returned and by taking the final exam.

Student workload

Lectures and exercises 40 h
Independent work 40 h

Content scheduling

Modelling a relational database
Database normalization and integrity requirements
Basics of SQL
SELECT statement
Querying data from multiple tables
Nested SELECT statements
SQL functions
Creating and modifying tables

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 criteria, fail (0)

The student has not passed the final exam

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.

Toteutuksen arviointikriteerit, hyvä (3-4)

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.

Further information

Kurssin voi suorittaa verkko-opintoina