Curricula

Objective

The students understand the concepts and background theories related to relational databases. They are familiarized with the conceptual data modeling and they are able to create a relational database based on a conceptual model. The students know the basics of the SQL language and they can utilize that knowledge in the database management.

Content

- ER modeling: method of conceptual modeling, notations, description technique.
- Database solution: planning a database according to the relational model based on a conceptual model.
- Managing the data included in the database by the SQL-language.

Qualifications

Computing

Assessment criteria, satisfactory (1)

Excellent (5): The students can model real world data interrelations and implement a relational database based on a model they have created. The students master well the main parts of the SQL-language and they are able to build versatile queries.
Good (3-4): The students can model smallish data interrelations and they can create a functional relational database. The students can manage the data in the database easily with the SQL-language.
Satisfactory (1-2): The students understand the basics of modeling. They can create a relational database from a ready-made ER-diagram or database descriptions. The students master the basics of the SQL-language.

Assessment criteria, good (3)

Good (3-4): The students can model smallish data interrelations and they can create a functional relational database. The students can manage the data in the database easily with the SQL-language.

Assessment criteria, excellent (5)

Excellent (5): The students can model real world data interrelations and implement a relational database based on a model they have created. The students master well the main parts of the SQL-language and they are able to build versatile queries.