Knowledge

The student...

is able to explain the components that are part of a database management system
is able to define the key properties of a database transaction
is able to describe relational algebra and concepts like Cartesian product
is able to define the concepts primary, foreign, candidate and super key, and apply them in relational databases
is able to define the concepts normalization, functional dependence and determinant
is able to explain roles and rights in a database management system
is able to explain the difference between a relational database and a document database

Skills

The student...

is able to describe and execute the steps of the development of a database model from specification to completed database, draw a model with correct notation and cardinality
is able to apply SQL language to execute read, update, add and delete operations on a database
can retrieve data from multiple combined database tables
is able to normalize database tables
is able to create virtual database tables using views
is able to perform basic user administration

General competence

The student...

is able to explain and exemplify the advantages of using a database, and assess whether they are present in concrete cases
is able to sketch the lifetime of a typical database: modelling, creation, use and revision

Subject description 6501

Databases