Relational algebra; the relational model; SQL: constructs to create and query a database; database design using the Entity-relationship model; analysis of ER diagrams and translation to the relational model; triggers; transactions; functional dependencies and normal forms; database normalization; case studies: PostgreSQL
Sistemi di Basi di Dati - Fondamenti
R.A. Elmasri, S.B. Navathe
Ed. Pearson, Addison Wesley
Basi di dati: Modelli e linguaggi di interrogazione
P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone
Ed. McGraw-Hill
Learning Objectives
- The relational model
- Management and query of databases using the SQL
- database design using the Entity relationship model
- Translation of ER diagrams into the relational model
- Database normalization
Prerequisites
Operating systems
Teaching Methods
Class lectures (45 h) and lab activities (10 h)
Further information
Handsout available from the course web site http://www.dsi.unifi.it/pala/index.php/Main/DB-material
Type of Assessment
written and oral test
Course program
The relational model (tables and integrity constraints); relational algebra (union intersection, difference, select, project, join); the SQL language (data types, integrity constraints, the basic select construct, aggregate operators, nested queries, correlated queries, scalar queries, views); Database design using the Entity-relationship model; Analysis of ER diagrams; normal forms and functional dependencies; database normalization; Triggers; Transactions; case studies: PostgreSQL