SQL and Relational DatabasesLaajuus (3 cr)

Objective

After the course, a student has ability to understand and maintain SQL and relational databases

Content

- Introduciton to relational databases, basics of relational model, introduction to SQL, planning and creating a database, tools

Assessment criteria, satisfactory (1)

aradigm: - the student understands what relation applied to databases is, understands normalization and is able to do the normalization with the instructor's help; syntax: - the student understands SQL syntax and is able to write simple SQL syntax with the instructor's help; queries and result arrangement: - the student understands what SQL queries and result arrangements are and is able to write and use them with the instructor's help; database modification: - the student understands what INSERT, UPDATE & DELETE are and is able to write and use them with the instructor's help;

Assessment criteria, good (3)

paradigm: - the student understands what relation applied to databases is, understands normalization and is able to do the normalization; - the student shows independent solutions. syntax: - the student understands SQL syntax and is able to write simple SQL syntax; - the student shows independent solutions. queries and result arrangement: - the student understands what SQL queries and result arrangements are and is able to write and use them; - the student shows independent solutions. database modification: - the student understands what INSERT, UPDATE & DELETE are and is able to write and use them; - the student shows independent solutions.

Assessment criteria, excellent (5)

paradigm: - the student understands what relation applied to databases is, understands normalization and is able to do the normalization; - the student shows independent solutions and critical evaluation. syntax: - the student understands SQL syntax and is able to write simple SQL syntax; - the student shows independent solutions and critical evaluation. queries and result arrangement: - the student understands what SQL queries and result arrangements are and is able to write and use them; - the student shows independent solutions and critical evaluation. database modification: the student understands what INSERT, UPDATE & DELETE are and is able to write and use them; - the student shows independent solutions and critical evaluation.