Course ObjectiveIn 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 ContentThe 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 MethodsLectures (4 hours a week) and tutorials (2 hours a week). Assignments
will be discussed during the tutorials.
Method of AssessmentWritten exam (60% of the final grade), group assignments (40% of the
LiteratureGarcia-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.
|Language of Tuition||English|
|Faculty||School of Business and Economics|
|Course Coordinator||dr. R. de Vlaming|
|Examiner||dr. R. de Vlaming|
dr. R. de Vlaming
You need to register for this course yourself
Last-minute registration is available for this course.
|Teaching Methods||Study Group, Lecture, Computer lab|
This course is also available as: