Databases (5 cr)

Evaluation scale

0-5

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

Location and time

Lutakon kampus

Materials

Opintojakson verkkosivut (luentomateriaali, harjoitukset ja kotitehtävät)

Teaching methods

Lähikontaktit (luennot, opettajan johdolla tehtävät ja omatoimiset harjoitukset, tentti)
Etäopiskelu (kotitehtävät, tenttiin valmistautuminen)

Student workload

Kontaktiopetus 45 h (luennot, harjoitukset, tentti)
Etäopiskelu 90 h (kotitehtävät, tenttiin valmistautuminen)
Yhteensä 135 h

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.

Qualifications

-

Further information

Exchange students 5 places