RelaatiotietokannatLaajuus (5 op)
Opintojakson tunnus: R504D66
Opintojakson perustiedot
- Laajuus
- 5 op
- Opetuskieli
- englanti
- Korkeakoulu
- Peppi
Osaamistavoitteet
The student knows the principles of relational databases and is capable to design a relational database and apply it in practice to information management.
Sisältö
- Concept analysis
- Relational Models
- Basics of SQL commands (SELECT, DML, DDL)
Arviointikriteerit, tyydyttävä (1)
The student knows the structure of a relational database.
The student can utilize simple SQL statements in database processing.
Arviointikriteerit, hyvä (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.
Arviointikriteerit, kiitettävä (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.