1 Database design
1.1 Conceptual design: Entity-Association model
1.2 Logical design: relational model, relational theory and languages
1.3 Relational algebra.
1.4 Non-procedural query language SQL92
1.5 Introduction to the theory of functional dependency and normalization
1.6 Generalities on Database Management Systems (DBMS).
2 Lab exercises
2.1 Basic Elements of a Database. Creating, modifying and deleting a database and its tables. Definition an modification of constraints. Data manipulation operations: INSERT, UPDATE, and DELETE.
2.3 Querying a database. Complex queries: JOIN and subqueries. Treatment of NULL values.
2.4 Complex structure elements: Views, Indexes.
2.5 Structured programming elements: stored procedures, triggers. Foundations of DB-based application development.