Knowledge

The student...

is able to explain the components that are part of a DBMS
is able to define the ACID characteristics and why these should be met
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 DBMS
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 an ER model from specification to completed database
is able to apply SQL to execute CRUD operations on the database
is able to apply SELECT queries with options to fetch reports, including combining several tables using JOIN clauses
is able to apply the normalized forms UNF, 1NF, 2NF, 3NF, and BCNF
is able to apply VIEW
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 6605

Databases