The course covers the fundamental concepts of management and design of database systems. Topics include data models (ER and relational); query languages (SQL);
implementation techniques of database management systems (index structures and nd query processing); noSQL databases.
The learning objectives of the course, expressed according to the Dublin descriptors, are:
Knowledge and understanding
a) To understand the main concepts of management and design of database systems
b) To understand concepts and tools for querying databases of different nature (therefore with structured and unstructured data) and at different scales
c) To understandi the role and the impact that data and their correct modeling may have on software applications using them
Applying knowledge and understanding
a) To be able to design, starting from the requirements, a relational (and non) relational database, from a conceptual, logical and physical point of view.
b) To be able to understand and use the SQL language to manage data and perform efficient queries.
c) To be able to create and query unstructured databases (NoSQL) by manipulating JSON documents
The module deals with the methodological tools for the design of modern web-based information systems (Web Information Systems). In particular the module covers concepts for designing and developing the back-end (server-side programming) and front-end (client-side programming) of a web application. Particular emphasis will be given to the development of "responsive" front-ends The module covers also design and implementation techniques based on the Model-View-Controller (MVC) architectural pattern.
The module will finally presents elements on programming techniques for the implementation of interactive GUIs (e.g., AngularJS and React) and hybrid applications for mobile (e.g., Ionic).
The learning objectives of the course, expressed according to the Dublin descriptors, are:
Knowledge and understanding
Applying knowledge and understanding
Lectures, hands-on exercises, laboratory and seminars.
Should teaching be carried out in mixed mode or remotely, it may be necessary to introduce changes with respect to previous statements, in line with the programme planned and outlined in the syllabus.
Lectures, hands-on exercises, laboratory and seminars.
Should teaching be carried out in mixed mode or remotely, it may be necessary to introduce changes with respect to previous statements, in line with the programme planned and outlined in the syllabus.
Models and Languages for Database Management
Design of databases
* Topics to know and understand to pass the exam.
* Essential skills required to pass the course
Foundations of web programming and server-side development *
Web information Systems design and client-side application development *
Advanced Web Programming Techniques
1. Basi di dati - 4/ed, Modelli e linguaggi di interrogazione. Di: Paolo Atzeni, Stefano Ceri, Piero Fraternali, Stefano Paraboschi e Riccardo Torlone, Casa editrice: Mc-Graw-HIll
2. Teaching materials provided by the instructor
Instructor notes