Database Fundamentals and Applications

2018-2019
Dit vak wordt in het Engels aangeboden. Omschrijvingen kunnen daardoor mogelijk alleen in het Engels worden weergegeven.

Doel vak

In an increasingly data-driven world, database systems play a central
role in data retrieval, manipulation, and storage. Although some users
may be hardly aware of it, anyone browsing the World Wide Web (by using
services provided by companies such as Google, Amazon, and Booking.com)
is in fact a user of highly advanced database systems. In addition, the
reach of such systems goes well beyond just the digital economy. Most
enterprises use one or more databases to keep track of important data
(e.g., 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 computer sessions, in which participants get to
work on practical group assignments. In addition to these group
assignments, participants are expected to read relevant literature and
work on individual homework assignments.

Inhoud vak

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, and integrity constraints as well as
transaction processing and concurrency control.

Onderwijsvorm

Lectures (4 hours a week), tutorials (2 hours a week), computer sessions
(2 hours a week). Individual homework assignments will be discussed
during the tutorials. Computer sessions will allow students to work on
group assignments.

Toetsvorm

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

Literatuur

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.

Algemene informatie

Vakcode E_EOR2_DBFA
Studiepunten 6 EC
Periode P2
Vakniveau 200
Onderwijstaal Engels
Faculteit School of Business and Economics
Vakcoördinator dr. R. de Vlaming
Examinator dr. R. de Vlaming
Docenten dr. R. de Vlaming

Praktische informatie

Voor dit vak moet je zelf intekenen.

Voor dit vak kun je last-minute intekenen.

Werkvormen Hoorcollege, Werkgroep, Computerpracticum
Doelgroepen

Dit vak is ook toegankelijk als: