Curricula

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

Qualifications

-

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.