Scuola Universitaria Interdipartimentale in Scienze Strategiche (SUISS)

By the end of the course, students have to be aware of the basis of database systems. Furthermore, they must be confident with models for the project of a database as well as with the SQL language for querying relational databases.

Knowledge of the E-R model and the relational model. Basic constructs of SQL.

1. Information systems and data bases 1.1 Logical models 1.2 Languages and users   2. The relational model 2.1 Relations and tables 2.2 Schemes and instances 2.3 Integrity constraints 2.4 Incomplete information and null values   3. Relational algebra and calculus 3.1 Union, intersection, difference 3.2 Selection, projection, join 3.3 Queries 3.4 Equivalences of queries 3.5 Algebra with null values 3.6 Relational calculus 3.7 Equivalence of relational algebra and calculus algebra   4. The;language SQL 4.1 Data definition 4.2 Queries 4.3 Data modificationi   5. Project of data bases 5.1 The Entity-Relationship model (E-R) 5.2 Conceptual representation 5.3 Changing the structure of E-R models 5.4 Translating E-R models into the relational model   6. Normalization 6.1 Redundancy and anomalies 6.2 Functional dependancies 6.3 Normal forms

 

Traditional classes and exercises using Moodle platform.

Atzeni, Ceri, Fraternali, Paraboschi, Torlone - Basi di dati: Modelli e linguaggi di interrogazione, quarta ed. McGraw-Hill 2013.