No upcoming implementations. See the syllabus for more information.
Learning outcomes of the course
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.
Course contents
- Introduction to databases
- Database design with conceptual analysis
- Queries and SQL
- Database implementation: tables and relations
Prerequisites and co-requisites
-
Evaluation scale
0-5
Assessment criteria
Assessment criteria - grade 1 and 2
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 - grade 3 and 4
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 - grade 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.