APPLIED INFORMATICS

Course objectives

General goals: -------------- Present and practice the main IT tools, theoretical and practical, for the management, storage and sharing of information in the humanities. More precisely, the goal is to introduce the main languages for data management and text markup. Specific goals: --------------- Create, manage and query relational databases. Define and interpret both markup languages and marked-up texts. Knowledge and understanding: ---------------------------- Knowledge of the relational model for data representation, the use of relational database management systems and languages for interacting with relational databases. Understand the meaning of metadata and markup. Knowledge of the XML meta-language. Apply knowledge and understanding: ---------------------------------- Being able to create relational databases, knowing how to query and manipulate databases using the SQL language. Being able to create and interpret an XML-based markup language to represent texts and their metadata. Critical and judgment skills: ------------------------------ Being able to evaluate the correctness and completeness of a database schema. Knowing how to evaluate the correctness and completeness of both a markup language and marked-up text. Communication skills: --------------------- Being able to describe the choices made in managing a database, from its creation to its manipulation and querying. Being able to describe the choices made in marking texts. Learning ability -------------------------- The design activities carried out during the course will stimulate the student to autonomously study some topics presented in the course.

Channel 1
Sara Santorsa Lecturers' profile

Program - Frequency - Exams

Course program
The course will cover two topics, closely related to information management and sharing: * relational databases (with particular reference to the SQL language) and their uses also in web design; * XML markup metalanguage and its uses in the humanities (XML-TEI, ICCU's MAG SCHEMA, etc.). Each topic will be accompanied by practical exercises that will be carried out independently and will form part of the evaluation. Texts adopted: The teaching material consists of the course slides and the texts and solutions of the exercises that will be provided by the lecturer. Prerequisites: There are no prerequisites. Procedure: The course involves the use of a computer during lectures and exercises. One or more exercises will be proposed to be carried out, either in the classroom or at home, and which will require students to put into practice what they have just learnt. The lecturer will then provide solutions to the exercises in order to check their correctness. The course will be delivered in person. Attendance: Attendance is not mandatory, but strongly recommended. Assessment methods: The examination consists of three parts: individual exercises, written test and oral test; 1. individual exercises (during the course) - 10 points 2. Final written examination (one part-structured database exercise and one part-structured XML exercise) - 10 points 3. oral examination (following the written examination) - 10 points During the oral examination, the lecturer discusses the outcome of the written examination and asks a few questions in order to investigate any errors in the written examination and further topics covered.
Prerequisites
There are no prerequisites.
Books
The teaching material consists of the course slides and the texts and solutions of the exercises that will be provided by the lecturer.
Frequency
Attendance is not mandatory, but strongly recommended.
Exam mode
The examination consists of three parts: individual exercises, written test and oral test; 1. individual exercises (in the course of the course) - 10 points Final written examination (one part-structured database exercise and one part-structured XML exercise) - 10 points 3. oral examination (following the written examination) - 10 points During the oral examination, the lecturer discusses the outcome of the written examination and asks a few questions in order to investigate any errors in the written examination and further topics covered.
Lesson mode
The course involves the use of a computer during lectures and exercises. One or more exercises will be proposed to be carried out, either in the classroom or at home, and which will require students to put into practice what they have just learnt. The lecturer will then provide solutions to the exercises in order to check their correctness. The course will be delivered in person.
  • Lesson code1041865
  • Academic year2024/2025
  • CourseArchive and Library Theory and Management
  • CurriculumSingle curriculum
  • Year1st year
  • Semester2nd semester
  • SSDING-INF/05
  • CFU6
  • Subject areaDiscipline scientifiche, tecnologiche ed economico-giuridiche