Learning objectives

The course aims to provide the necessary skills for (a) data design based on requirements with reference to different application contexts and within the production process of software systems; (b) the effective and efficient management and use of data always according to the assigned requirements; (c) the use of a relational database management system to create, manage and query information contained in a database; (d) the development of applications that interact with relational databases. At the end of the course, the student will have to: demonstrate knowledge and understanding of the data models and query languages that characterize data management systems, the fundamental mechanisms for developing applications that interact with a database; knowing how to apply the knowledge acquired for the design of a data collection with respect to a set of application requirements, ability to efficiently query and use the data managed by a system, ability to design and implement an application that interacts with a base of data; Be able to choose the most appropriate representation for a set of data that characterizes an application area and/or evaluate the quality of a given data representation in a relational system; knowing how to evaluate the correctness and quality of a query on relational systems; knowing how to argue in a technical and precise way the quality of the representation of a set of data and/or the correctness of a query on relational systems; Be able to independently expand the knowledge in order to analyze and highlight the model and language differences of new data management systems.