Introductory Databases and Database Programming

• develop a conceptual data model for a given problem description
• create a logical data model for a relational database from a conceptual data model
• transform a relational model to 3rd normal form
• carry out a physical database design
• use a relational database language for implementing a physical database design
• explain and apply techniques for optimizing the physical access of data in databases
• use a relational database language for querying relational databases
• use a relational database language for manipulating relational databases

• Conceptual database design:
– ER-modelling with ER-diagrams showing entities and their relationships, keys, domains and other constraints.
• Logical database design, including:
– mapping from ER-model to relational model
– normalisation of relational models to 3NF
• Physical database design, including:
– conversion of a logical model’s relations to tables
– definition of constraints
• Implementation of a physical database design in SQL
• Indexing techniques for optimizing the physical access of data in databases
• Structured Query Language, SQL:
– SQL Commands for defining, manipulating and querying databases
– Advanced SQL language constructs such as triggers, stored procedures and views

Participants are expected to take courses 01904 and 02312 at the latest in the same semester as this course, or to have equivalent knowledge about
(1) discrete mathematics: set theory and logical operators,
(2) programming

Lectures and exercises and a project.

In case of overbooking, diplom students shall be preferred.