Databases (5cr)

Code

General information

Timing: 01.01.2020 - 31.07.2020; Implementation has ended.

Number of ECTS credits allocated: 5 cr

Local portion: 5 cr

Mode of delivery: Face-to-face

Unit: School of Technology

Teachers: Antti Häkkinen

Groups: ZJA19STPVI
Avoin amk, TEKN,ICT ICT - verkkopolkuopinnot; ZJA19ST
Avoin amk, TEKN

Course: TTZC0800

Unfortunately, no reservations were found for the realization Databases TTZC0800-0K0Z1. It's possible that the reservations have not yet been published or that the realization is intended to be completed independently.

Objective

The student is familiar with the basic concepts of databases, understands the overall structure and operating principle of a database system, is able to read and draw up database descriptions, is able to create a database, is able to use it (retrieve information from a database) and knows the basics of SQL.

Content

- Introduction to databases
- Database design with conceptual analysis
- Queries and SQL
- Database implementation: tables and relations

Assessment criteria, satisfactory (1)

Sufficient 1: The student is able to design and implement a simple database by creating at least one relationship between tables using primary and foreign keys. In addition, the student is able to make basic SQL queries.

Satisfactory 2: The student is able to design and implement a database and is able to carry out basic queries utilizing SQL. The required documentation contain at least the database description.

Assessment criteria, good (3)

Good 3: The database completed as assignment and in the exam has been designed and implemented almost perfectly and the student knows SQL in a versatile manner. The required documentation is extensive and the assignment has been presented.

Very good 4: The student is able to design and implement a database where the choices are well-founded. He (she) knows the basic commands of SQL comprehensively. The required documentation is extensive and the presentation on the course assignment is fluent.

Assessment criteria, excellent (5)

Excellent 5: The student is able to design and implement an innovative database where the choices are well-founded and metadata is saved. The student can use SQL (Structured Query Language) for demanding data queries. The required documents are complete, understandable and of high quality (error-free). The presentation on the course assignment is extensive.