Tietokannat (5 cr)

Evaluation scale

0-5

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.

Materials

Available in Optima.

Completion alternatives

exercises, project, exam.

Student workload

Average 135 h

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.

Qualifications

Computing

Further information

-