• suggest a database design according to the relational model, and present it as an SQL schema, using the concepts key, type, and constraint.
• define a database design by E-R modelling, using the concepts entity, attribute, key, cardinality, and relationship.
• write SQL queries, involving multiple relations, compound conditions, grouping,
  aggregation, and subqueries.
• find functional dependencies in a relation and perform decomposition to eliminate unwanted dependencies.
• decide if a given index is likely to improve performance for a given query.
• identify possible problems in transaction handling, related to consistency, atomicity, and isolation.
• use SQL in an imperative programming language (Java).
• suggest a conceptual and physical design of an OLAP system.
• suggest an abstract model suitable for a given data mining task.
• formulate an analytics task as a sequence of operations on a stream, or in the MapReduce framework.

• Programming in SQL, including all basic operations as well as some more advanced constructions (e.g. subqueries)
• Database design using E-R modelling
• Defining a database design using the relational model and SQL schemas
• Normalization of relations
• Use of different indexes, including hash indexes, B-tree indexes, non-clustered and clustered indexes
• Transaction handling
• Using SQL in applications, e.g. Java-applications
• Other basic concepts related to relational databases and SQL, such as triggers, views etc.

• OLAP and data warehousing
• Data mining problems such as clustering, finding association rules, and building decision trees.
• Infrastructures for handling massive analysis tasks, such as distributed computation, and computations on data streams.

The textbook, lectures and exam are in English. However, written work and the exam can be delivered by students in English or Danish.

4 mandatory assignments must be handed in before November 30, 2012 for students to be eligible for the exam. Three of the assignments are to be done in groups.

-----
NB!! Course restriction!!
Please note that there is a course restriction between this course and the SDT course Database Systems.
That means that you cannot take this course, if you have already taken Database Systems. 

During this course students will be required to hand in mandatory assignments that need to be completed/approved before being eligible to register for the examination and e.g. being allowed to submit written work for examination. Failure to hand in these mandatory assignments on time will mean that the registration for examination is annulled.

These mandatory assignment (deadlines are posted separately, e.g. on the course blog)

The duration of the written examination is 4 hour(s).

Submission/completion of mandatory activities before November 30, 2012 at 15:00.