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

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.

Further information

Kurssin voi suorittaa verkko-opintoina