Teaching Workshop
A.Y. 2021/2022
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
More specific information on the delivery modes of training activities for academic year 2021/22 will be provided over the coming months, based on the evolution of the public health situation.
Course syllabus
1. Data, information, information systems - data storage, database management systems (DBMS), data and abstraction levels
2. Data semantics - ontologies and knowledge representation, introductory concepts, definitions and content
3. Conceptual design - entities and attributes, relationships between entities, cardinality of relationships, identifiers, generalisation hierarchies, methodological design guidelines
4. The relational model - theory of the relational model, null values, relations between tables, data consistency, relational algebra, projection and selection, set operations
5. Logical design - elimination of generalisation hierarchies, translation of entities and attributes, translation of relations
6. Database creation and querying - SQL language and its dialect PostreSQL, creating a database, defining associations between tables, populating a database, violating referential integrity constraints, modifying and deleting tables, querying a database, selection conditions, joining tables, sorting criteria, more query examples
7. The evolution of the Web - Web 2.0 and Semantic Web
2. Data semantics - ontologies and knowledge representation, introductory concepts, definitions and content
3. Conceptual design - entities and attributes, relationships between entities, cardinality of relationships, identifiers, generalisation hierarchies, methodological design guidelines
4. The relational model - theory of the relational model, null values, relations between tables, data consistency, relational algebra, projection and selection, set operations
5. Logical design - elimination of generalisation hierarchies, translation of entities and attributes, translation of relations
6. Database creation and querying - SQL language and its dialect PostreSQL, creating a database, defining associations between tables, populating a database, violating referential integrity constraints, modifying and deleting tables, querying a database, selection conditions, joining tables, sorting criteria, more query examples
7. The evolution of the Web - Web 2.0 and Semantic Web
Prerequisites for admission
No prerequisites.
Teaching methods
For attending students class attendance is mandatory. Lectures are based on face-to-face teaching with the support of slides and handouts that are progressively published on the reference course website (Ariel platform). Throughout the lectures, real case-studies are proposed for analysis with the aim of illustrating the application of the theoretical course contents to the concrete scenarios.
Non attending students will find recorded lectures on Ariel. Laboratory is also based on didactic material provided on the same platform.
Non attending students will find recorded lectures on Ariel. Laboratory is also based on didactic material provided on the same platform.
Teaching Resources
The bibliography coincides for attending and non-attending students.
S. Castano, A. Ferrara, S. Montanelli, "Informazione, conoscenza e Web per le scienze umanistiche". Pearson. 2009. ISBN: 8871925483
Chapters 1, 2, 3, 4, 5, 6, 12
S. Castano, A. Ferrara, S. Montanelli, "Informazione, conoscenza e Web per le scienze umanistiche". Pearson. 2009. ISBN: 8871925483
Chapters 1, 2, 3, 4, 5, 6, 12
Assessment methods and Criteria
Attending and non-attending students:
the assessment method consists in a written exam on the syllabus of the whole course. The written exam is composed of quizzes, open-ended questions, and exercises. The assessment criteria are the capability to clearly present knowledge, the completeness of answers, the correctness of reasoning in carrying out exercises.
Incoming Erasmus students can take the exam in English according to a syllabus previously endorsed and confirmed by the teacher.
The assessment methods for students with handicap and/or learning disability is case-by-case defined by the teacher with the support of the competent authority.
the assessment method consists in a written exam on the syllabus of the whole course. The written exam is composed of quizzes, open-ended questions, and exercises. The assessment criteria are the capability to clearly present knowledge, the completeness of answers, the correctness of reasoning in carrying out exercises.
Incoming Erasmus students can take the exam in English according to a syllabus previously endorsed and confirmed by the teacher.
The assessment methods for students with handicap and/or learning disability is case-by-case defined by the teacher with the support of the competent authority.
Professor(s)
Reception:
Tuesdays at 13:00-14:00, or upon request
Piazza Sant'Alessandro 1, Anglistics sector, third floor