- Knowledge of the main characteristics of a database management system - Knowledge of the structure and properties of the relational model - Knowledge of query languages for a relational database: Relational algebra and SQL language - Ability to write queries in the relational algebra and SQL languages - Knowledge of the conceptual Entity-Relationship model for data representation and of the methodology for conceptual and logical design of a relational database - Ability to design a relational database - Knowledge of the SQL statements for view management, data access control, and transaction management - Knowledge of the interaction techniques between SQL statements and programming languages - Ability to design and develop an application accessing a database

Basic programming skills.

Class topics and their weight in credits: - Characteristics of a database management system (0.2 cr.) - Characteristics of the relational model (0.2 cr.) - Relational algebra (0.4 cr.): main operators and query definition - SQL language: statements for data definition and processing (1 cr.) - Conceptual data model (Entity-Relationship) and methodology for the conceptual and logical design of a relational database (0.8 cr.) - SQL language: statements for view management, data access control, and transaction management (0.4 cr.) - SQL for applications: client-server architectures, integration of SQL statements into a programming language, stored procedures, design of a client-server web-based architecture accessing a database (1.35 cr.)

The course includes lectures in the classroom, whose topics are described earlier, and practices on the lecture topics, and in particular SQL language, relational algebra, and conceptual and logical database design (2.6 cr.). Students will prepare an individual written report on the exercises proposed during the course. The report will contribute to the final exam grade. The course includes laboratory sessions on the SQL language and the design of a client-server architecture accessing a database (1.05 cr.). Laboratory sessions allow experimental activities on the most widespread commercial and open-source products.

The reference book, covering the majority of the course topics, is: Atzeni, Ceri, Paraboschi, Torlone, "Basi di dati - Modelli e linguaggi di interrogazione", 3 ed., McGraw Hill, 2009. The following book supports practices: Baralis, Belussi, Psaila, "Basi di dati: temi d’esame svolti", Esculapio, 2000. Copies of the slides used during the lectures, examples of written exams and exercises, and manuals for the activities in the laboratory will be made available. All teaching material is downloadable from the course website or the Portal.

Exam: Written test; Optional oral exam; Individual essay;

The exam includes a written part, which lasts 2 hours, an optional oral part, and the evaluation of the report on the individual practices assigned during the course. The written part consists of - 3 multiple-choice tests on the main course topics (theory of relation model, integrity constraints’ management, materialized views’ management, transactions’ management, security, SQL for applications (connection to databases, HTML, PHP)) (max 3 points) - 3 exercises on writing queries to access data in a relational database (through relational algebra and SQL language) (max 15 points) - 1 exercise on conceptual and logical database design and on the definition of referential integrity constraints (max 13 points) Students can consult textbooks or notes during the exam. The delivery of individual practices’ reports during the course is optional (max 2.5 points). The optional oral part covers all the topics of the course. The final exam grade is defined by evaluating both the written part and the reports. The grade of the reports is considered only if the written part evaluation is 18 or above. Exercises are evaluated according to the correctness of the proposed solution and to the appropriateness of the adopted methodologies of resolution.

In addition to the message sent by the online system, students with disabilities or Specific Learning Disorders (SLD) are invited to directly inform the professor in charge of the course about the special arrangements for the exam that have been agreed with the Special Needs Unit. The professor has to be informed at least one week before the beginning of the examination session in order to provide students with the most suitable arrangements for each specific type of exam.