BASES OF DATA, ONTOLOGIES AND SEMANTIC WEB

Module MODULO A: BASI DI DATI

The course has as main objective to provide the fundamental concepts on: database management systems (DBMS), the SQL language, and the study of techniques and methods of data design and modeling and methods of designing a database data.

During the course, students will apply the knowledge acquired on local servers in order to carry out real and practical CRUD (Create, Read, Update, Delete) operations on databases on local servers.

Particular attention is paid to the techniques for carrying out the functional analysis, the collection of requirements and the definition of the processes of the work context where the database will be inserted.

According to the Dublin descriptors, students, at the end of the course, will demonstrate:

Knowledge and understanding

To understand the structure of IT systems, the collection of requirements and their modeling in order to be aware of the context in which the databases are located.

To understand the main concepts of management and design of database systems.

Knowing and understanding concepts and tools for querying databases of different types.

To understand the differences between the various types of databases: relational, and the study of data warehouses as well as big data and NoSQL.

Applying knowledge and understanding

To collect the needs, to understand the requirements set by the context and to extract the essential information in order to model the data, to write requirements documents, to know the design principles and to query the datasets. To recognize the required fundamentals that are needed in the design and in the implementation of the database, from traditional data to digital data.

Making judgements

Being able to analyze, collect and interpret data from a complex context and be able to adopt the most efficient design solution.

Communication skills

Orally explain your project choices in a clear way with an appropriate technical vocabulary with regards to the fundamental concepts in database management.

Learning skills

Through the concepts and notions acquired during the course, the student will be able to undertake subsequent studies with a high degree of autonomy.

1.      Basic notions of information systems (Teaching materials provided by the instructor and available on STUDIUM)

1. Introduction to information systems

2. Software life cycle

3. Software development methodology

4. Architectural analysis of software systems

5. Collection and management of requirements

2.       Models and languages of databases

1. Introduction to Database Management Systems (Chapter 1)

2. Relational model (Chapter 2)

3. Elements of Algebra and relational calculus (Chapter 3)

4. SQL language (Chapter 4)

5. Relational DBMS: MySQL (Teaching materials provided by the instructor and available on STUDIUM)

6. Other types of databases (Teaching materials provided by the instructor and available on STUDIUM)

3.       Design of databases

1. Design methodologies (Chapter 6)

2. Conceptual Design (Chapter 7)

3. Logical Design (Chapter 8)

4. Normalization (Chapter 9)

5. Elements of PHP: the aim is creating pages with access to MySQL database (Teaching materials provided by the instructor and available on STUDIUM)

1. BASI DI DATI 5/ED CON CONNECT, di Paolo Atzeni, Stefano Ceri, Piero Fraternali, Stefano Paraboschi, Riccardo Torlone - Casa editrice: Mc-Graw-Hill (2018)

2. Teaching materials provided by the instructor (available on STUDIUM)

Please remember that in compliance with art 171 L22.04.1941, n. 633 and its amendments, it is illegal to copy entire books or journals, only 15% of their content can be copied.

For further information on sanctions and regulations concerning photocopying please refer to the regulations on copyright (Linee Guida sulla Gestione dei Diritti d’Autore) provided by AIDRO - Associazione Italiana per i Diritti di Riproduzione delle opere dell’ingegno (the Italian Association on Copyright).

All the books listed in the programs can be consulted in the Library.