DatabasesLaajuus (5 cr)
Course unit code: HTO10400
General information
- Credits
- 5 cr
- Teaching language
- Finnish
- Responsible person
- Jarkko Immonen
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.