DatabasesLaajuus (5 cr)
Course unit code: IIZO3030
General information
- Credits
- 5 cr
- Teaching language
- Finnish
Objective
The students
- know the basic concepts related to databases
- understand the general structure and operating principle of database systems
- can read and create database descriptions
- can create a database (with some commonly used database software)
- can use a database (search for information in the database)
- know the basics of the SQL language
Content
-Introduction to databases
-concept analysis (design tube)
-queries and SQL
-implementing a database: tables and connections
Qualifications
Database basics
Assessment criteria, satisfactory (1)
Excellent 5: Exemplary performance in all the subareas: design and implementation choices are well justified and the meta data has been saved, innovative solution, excellent SQL competence
Very good 4: The student has reached the objectives in all the subareas; the design and implementation choices are well justified and the metadata has been saved, the student has a good SQL competence.
Good 3: the database has been designed and documented nearly faultlessly and the student has a versatile knowledge of SQL.
Satisfactory 2: The student masters the basics: he (she) can design and create a database and he (she) can perform basic queries with SQL.
Sufficient 1: The student knows the basics: he (she) can create a simple database based on a description, can create a connection between 2 tables using basic and reference keys, and he (she) can perform simple basic queries with SQL.