Database Systems

• design a conceptual data model
• transform a conceptual data model into a logical data model for a relational database
• optimize a logical data model using normalization
• carry out a physical database design for relational databases: decide how the logical data model is to be implemented in a database management system
• use a widespread database management system
• explain and apply techniques for optimizing the physical access of data in databases
• perform programming tasks to create, query, update, and administrate a database
• formulate queries in formal relational query languages
• understand tasks normally solved by database designers and administrators

• The relational model
• Relational algebra and calculus base calculations
• Structured Query Language, SQL:
– SQL commands for defining, manipulating and querying relational databases
– Advanced SQL language constructs such as triggers, stored procedures and views
• Conceptual database design:
– ER-modelling with ER-diagrams showing entities and their relationships, keys, domains and other constraints.
• Logical database design, including:
– transforming an ER-model to a relational model
– features of good relational designs and normal forms
– normalisation of relational models to 4NF
• Physical database design and implementation, including
– conversion of a logical model into an implementation in SQL
• Techniques for optimizing the physical access of data in databases.

01017/01019/02105/02110, or equivalent knowledge about
(1) discrete mathematics: set theory and logical operators,
(2) programming, algorithms and data structures (at the level of 02105), and
(3) balanced trees (as taught in 02110).

Lectures and exercises and a group project.

Minimum: 5.

Please be aware that this course will only be held if the required minimum number of participants is met. You will be informed 8 days before the start of the course, whether the course will be held.