Statistics for management

General objectives The main objectives are: acquire the ability to identify the conceptual structure of a database and learn how to interact with a database management system (DBMS). Specific objectives a) Knowledge and ability to understand After attending the course the students know and understand the relational data model, they are able to cover all the phases of the design of a database (in particular the conceptual design) and are able to write and understand SQL commands for defining and querying a relational DB. They also know the basic DBMS administration tools. b) Ability to apply knowledge and understanding At the end of the course the students are able to derive the relational schema of a DB starting from the requirements of a database-based application. They are able to translate the informal description of the structure of data into an Entity-Relationship diagram that correctly represents the data and define the integrity constraints on the data object of the design. They are able to realize a relational DB using the SQL language, they are able to perform complex queries using the SQL language. c) Autonomy of judgment The students are able to apply the formalism of the ER diagrams in order to obtain an accurate description of the structure of the data that make up a database. They can distinguish the role of data definition language, data manipulation language and query language to interact with a DBMS. They manage to evaluate how different implementation choices can lead to more or less adequate solutions to represent the integrity constraints existing between the data. Through the articulated laboratory activities they acquire the ability to evaluate the efficiency of commands that define queries of various complexity levels. d) Communication skills Students acquire the formal rigor necessary to read and produce a conceptual scheme. They can understand the meaning of a query expressed in a formal language. e) Learning ability Students who pass the exam can easily understand formalisms for the definition of DB in non-relational models, they are able to understand how to use query languages ​​embedded in general-purpose programming languages.