Database Fundamentals and Applications

2019-2020

Course Objective

In an increasingly data-driven world, database systems play a central
role in data retrieval, manipulation, and storage. Although some may be
hardly aware of it, anyone using services provided by companies such as
Google, Amazon, and Booking.com is in fact a user of highly advanced
database systems. The reach of such systems goes well beyond the online
world. Most enterprises use one or more databases to keep track of
important data (e.g. on their personnel, clients, payments, sales, and
so on). Obviously these systems need to be robust and efficient, in
terms of handling simultaneous queries, internal consistency, and
durability of information stored by the database.

This course is aimed at teaching participants about the theoretical
fundamentals of databases systems. Special attention is paid to a deep
understanding of relational databases, relational algebra, and how to
develop conceptual database models. Moreover, students will acquire
skills on several advanced topics (e.g. efficiency, robustness of the
system, and semi-structured data). The theory provided in this course is
complemented by weekly tutorials, in which participants get to work on
group assignments. In addition to working on these assignments,
participants are expected to read all relevant literature.

Course Content

The course is focused on relational databases and XML. Much attention
will be paid to the relational model, relational algebra, and SQL
queries. In addition, the course will focus on database design,
functional dependencies, normal forms, and integrity constraints, as
well as transaction processing and concurrency control.

Teaching Methods

Lectures (4 hours a week) and tutorials (2 hours a week). Assignments
will be discussed during the tutorials.

Method of Assessment

Written exam (60% of the final grade), group assignments (40% of the
final grade).

Literature

Garcia-Molina, H., Ullman, J.D., and Widom, J. (2013). Database Systems,
The Complete Book (2nd international edition; ISBN-10: 1-292-02447-X;
ISBN-13: 978-1-292-02447-9). Essex, UK: Pearson Education Limited.

General Information

Course Code E_EOR2_DBFA
Credits 6 EC
Period P2
Course Level 200
Language of Tuition English
Faculty School of Business and Economics
Course Coordinator dr. R. de Vlaming
Examiner dr. R. de Vlaming
Teaching Staff dr. R. de Vlaming

Practical Information

You need to register for this course yourself

Last-minute registration is available for this course.

Teaching Methods Study Group, Lecture, Computer lab
Target audiences

This course is also available as: