Teaching Workshop
A.Y. 2022/2023
Learning objectives
The aim of the lab is to provide the basic knowledge and skills about computer science tools for modeling, defining, and managing digital historical archives.
Expected learning outcomes
The student will acquire the following knowledge and skills:
- fundamental principles of the relational model for the definition of a historical archive (database)
- languages and tools for extracting information from a relational database
- languages and tools for the representation of historical knowledge with semantic web formalisms
- fundamental principles of the relational model for the definition of a historical archive (database)
- languages and tools for extracting information from a relational database
- languages and tools for the representation of historical knowledge with semantic web formalisms
Lesson period: First semester
Single course
This course cannot be attended as a single course. Please check our list of single courses to find the ones available for enrolment.
Course syllabus and organization
Single session
Responsible
Lesson period
First semester
Course syllabus
The lectures will be focused on the following topics:
1. Data, information and information systems. Representation and processing of information relevant to historical sciences, introduction to database management systems (DBMS).
2. The relational model. Relational model theory, null values, relationships between tables, data consistency, integrity constraints, relational algebra, projection and selection, set operations.
3. The SQL language and the PostgreSQL dialect. Creation of a database, definition of associations between tables, inserting data into a database, violation of the constraints of foreign key, modification and deletion of tables, query of a database, selection conditions, joins of tables, sorting criteria, and further query examples.
4. Exercises related to the employment of information technologies for the representation and management of information relevant to the historical sciences. PostgreSQL DBMS tutorials on creating a database, inserting data into a database, editing and deleting tables, querying a database, selection conditions, joining tables, and more query examples.
5. The evolution of the Web, introduction to the concept of the Semantic Web.
1. Data, information and information systems. Representation and processing of information relevant to historical sciences, introduction to database management systems (DBMS).
2. The relational model. Relational model theory, null values, relationships between tables, data consistency, integrity constraints, relational algebra, projection and selection, set operations.
3. The SQL language and the PostgreSQL dialect. Creation of a database, definition of associations between tables, inserting data into a database, violation of the constraints of foreign key, modification and deletion of tables, query of a database, selection conditions, joins of tables, sorting criteria, and further query examples.
4. Exercises related to the employment of information technologies for the representation and management of information relevant to the historical sciences. PostgreSQL DBMS tutorials on creating a database, inserting data into a database, editing and deleting tables, querying a database, selection conditions, joining tables, and more query examples.
5. The evolution of the Web, introduction to the concept of the Semantic Web.
Prerequisites for admission
No prior knowledge is required, however it is preferable to have a minimum of basic computer skills.
Teaching methods
For attending students, attending the lectures is compulsory (a maximum of two absences is allowed). Lectures are planned with the help of slides and teaching materials that will be progressively made available on the Ariel platform teaching website. Specific lectures will be focused on the analysis of real case studies aimed at illustrating the concrete application of the theoretical contents addressed during the lessons.
Non-attending students will be able to access the teaching materials used during the lessons through the Ariel platform.
Non-attending students will be able to access the teaching materials used during the lessons through the Ariel platform.
Teaching Resources
The course material for attending and non-attending students is the same. Slides and teaching materials will be provided by the professor on the Ariel platform teaching website. In particular, the teaching material refers to the following bibliography:
1. A. Albano, G. Ghelli, R. Orsini, "Foundations of Data Bases". fundamentalidibasididati.it. and. September 2021;
2. R. Elmasri, S. B. Navathe, "Fundamentals of database systems". Pearson. 7th edition. 2015;
3. S. Castano, A. Ferrara, S. Montanelli, "Information, knowledge and Web for the humanities". Pearson. 2009.
1. A. Albano, G. Ghelli, R. Orsini, "Foundations of Data Bases". fundamentalidibasididati.it. and. September 2021;
2. R. Elmasri, S. B. Navathe, "Fundamentals of database systems". Pearson. 7th edition. 2015;
3. S. Castano, A. Ferrara, S. Montanelli, "Information, knowledge and Web for the humanities". Pearson. 2009.
Assessment methods and Criteria
The exam is the same for attending and non-attending students.
The exam consists in the oral discussion of articles relating one or several topics of the course. The articles to be analysed are agreed in advance with the professor. As an alternative (in particular for non-attending students), it is possible to deliver a summary of the studied articles. The oral discussion or the summary aims to verify that the student has understood the content and is able to highlight the aspects of the studied work in a conscious, critical way, and with adequate language properties.
The exam consists in the oral discussion of articles relating one or several topics of the course. The articles to be analysed are agreed in advance with the professor. As an alternative (in particular for non-attending students), it is possible to deliver a summary of the studied articles. The oral discussion or the summary aims to verify that the student has understood the content and is able to highlight the aspects of the studied work in a conscious, critical way, and with adequate language properties.
Professor(s)
Reception:
To be agreed by scheduling an appointment
Room 37 (3rd floor) or Microsoft Teams