Relational DatabasesLaajuus (5 cr)

Objective

The student knows the principles of relational databases and is capable to design a relational database and apply it in practice to information management.

Content

- Concept analysis
- Relational Models
- Basics of SQL commands (SELECT, DML, DDL)

Assessment criteria, satisfactory (1)

The student knows the structure of a relational database.

The student can utilize simple SQL statements in database processing.

Assessment criteria, good (3)

The student outlines the principles of relational databases.

The student can complete a concept analysis, create a relational database model and utilize the most common SQL statements in data management.

Assessment criteria, excellent (5)

The student can perform concept analysis and create a context-based relational database model.

The student can use SQL commands in a versatile manner in database processing.