Can explain how structured data differs from unstructured data

Can describe the principles of processing data

Can explain the difference of data and its description

Can explain the the difference of data contents and data representation

Can explain the main concepts of a conceptual level data model

Is able to interpret conceptual level data descriptions

Knows data representation and access principles

Is able to explain the principle of XML data structures

Can explain the use of abstraction levels in desribing data

Can explain the data model concept

Is able to interpret and construct a conceptual level data model for a small amount of data

Knows the most important quality constraints for data desrciptions and is able to analyse the quality of a data description

Is able to describe the ways to access data in different types of data stores.

Can explain the principles of the XML structure and compare the structure to other data modelling techniques

Is able to independently get acquainted with   data modelling techniques and their notations

Principles of the relational model of data

The concept of a mathematical relation

The operations of mathematical set theory and associated notations

Principles of logical expressions and connectives (and, or. -not)

Can explain the basic concept of the relational model (relation, tuple, attribute, domain, key, foreign key)

Can explain the principle of connecting data in the relational database

Can explain the operations of the relational algebra and the constraints for these operations

Is able to interpret different notations to define relational database structures

Knows well the concepts and notations of the relational model

Knows how to connect data in the relational model and is able to apply this knowledge in practice

Knows how the operations of the relational algebra work and is able to estimate the sizes of operation results

Is able to express queries in relational algebra

Gets acquainted to extensions of the relational model and variations of the operations

Familiarizes oneself to the principles of query optimization.

Databases

Knows how the traditional files are used in programs

Is able to identify features that separate databases from traditional files

Can explain what is metadata

Cand explain extensively how realtional databases differ from traditional files

Is able to identify the kernel component of a database management system and describe their responsibilities

Is able to explain the principle of data independence

Knows how to utilize metadata

Logical expression in programming languages

Is able to interpret a database description in SQL

Is able to express a simple need for data as an SQL query

Is able to carry out simple database maintenance operations with SQL

Is able to define a database in SQL

Is able to express his/her data needs as SQL queries

Is able to carry out database maintenance operations in SQL

Knows the transaction concept and is able to compose database maintenance operations in transactions.

Is able to utilize manuals and uses SQL fluently in database processing

Is able to estimate the sizes of query results and the time of processing the query

Is able to describe the principles of desining a relational database structure based on the conceptual model of data

Can explain the concept of functional dependency

Can explain the Boyce-Codd normal form

Is able to design relational database structures based on the conceptual model of data

Is able to interpret and identify functional dependencies 

Is able to analyse database structures using functional dependencies

Is able to define keys for relations

Is able to analyse  database structures using extensive criteria

Masters the syntactic design theory for relational databases