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
• use a relational database language for creating relational 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
• Structured Query Language, SQL:
– SQL Commands for defining, manipulating and querying databases
– Advanced SQL language constructs such as triggers, stored procedures and views

• 36 – 49 (Wed 13-17)

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.