Giancarlo NOTA | INFORMATION TECHNOLOGY FOR TOURIST SYSTEMS

cod. 0212900019

INFORMATION TECHNOLOGY FOR TOURIST SYSTEMS

	0212900019
	DEPARTMENT OF ECONOMICS AND STATISTICS
	EQF6
	TOURISM SCIENCE
	2024/2025

PERCORSO TOURISM SCIENCE

	YEAR OF COURSE 3
	YEAR OF DIDACTIC SYSTEM 2022
	SPRING SEMESTER

TEACHING UNITS

	SSD	CFU	HOURS	ACTIVITY	TYPE OF ACTIVITY
	INF/01	5	30	LESSONS	SUPPLEMENTARY COMPULSORY SUBJECTS

EXAMS

	Exam	Date	Session
	NOTA	14/04/2025 - 15:00	SESSIONE ORDINARIA

	Objectives
	ACCORDING TO THE OBJECTIVES OF THE COURSE OF STUDY, STUDENTS WILL ACQUIRE THE ABILITY TO OPERATE WITH COMPUTERS BY USING APPLICATIONS FOR THE MANAGEMENT OF PRESENTATIONS, SPREADSHEETS, AND DATABASES. STUDENTS WILL BE ALSO ABLE TO USE SOFTWARE TOOLS SUPPORTING PROJECT MANAGEMENT AND DIGITAL MARKETING. KNOWLEDGE AND UNDERSTANDING AT THE END OF THE COURSE, STUDENTS WILL KNOW THE FUNDAMENTAL ASPECTS FOR THE ELABORATION OF THE CREATION OF SPREADSHEETS, PRESENTATIONS, AND DATABASES, AS WELL AS THE FUNDAMENTAL ASPECTS OF TOOLS SUPPORTING PROJECT MANAGEMENT AND WEB ANALYTICS. APPLYING KNOWLEDGE AND UNDERSTANDING STUDENTS WILL BE ABLE TO USE SIMPLE APPLICATIONS, WITH SPECIFIC REFERENCE TO THE CREATION OF PRESENTATIONS, SPREADSHEETS, DATABASES, DEVELOPMENT AND MONITORING OF WORK PLANS, AND CREATION OF A WEB PRESENCE.

ACCORDING TO THE OBJECTIVES OF THE COURSE OF STUDY, STUDENTS WILL ACQUIRE THE ABILITY TO OPERATE WITH COMPUTERS BY USING APPLICATIONS FOR THE MANAGEMENT OF PRESENTATIONS, SPREADSHEETS, AND DATABASES. STUDENTS WILL BE ALSO ABLE TO USE SOFTWARE TOOLS SUPPORTING PROJECT MANAGEMENT AND DIGITAL MARKETING.

KNOWLEDGE AND UNDERSTANDING

AT THE END OF THE COURSE, STUDENTS WILL KNOW THE FUNDAMENTAL ASPECTS FOR THE ELABORATION OF THE CREATION OF SPREADSHEETS, PRESENTATIONS, AND DATABASES, AS WELL AS THE FUNDAMENTAL ASPECTS OF TOOLS SUPPORTING PROJECT MANAGEMENT AND WEB ANALYTICS.

APPLYING KNOWLEDGE AND UNDERSTANDING

STUDENTS WILL BE ABLE TO USE SIMPLE APPLICATIONS, WITH SPECIFIC REFERENCE TO THE CREATION OF PRESENTATIONS, SPREADSHEETS, DATABASES, DEVELOPMENT AND MONITORING OF WORK PLANS, AND CREATION OF A WEB PRESENCE.

	Prerequisites
	THERE ARE NO PREREQUISITES FOR THIS TEACHING

	Contents
	THE COURSE IS DIVIDED INTO THREE PARTS 1) DATA MANAGEMENT SYSTEMS; 2) PROJECT MANAGEMENT; 3) WEB APPLICATIONS FOR TOURISM 1. DATA MANAGEMENT SYSTEMS (12 HOURS OF FACE-TO-FACE LECTURES). INFORMATION SYSTEMS AND DATA SYSTEMS. DATABASES AND DATABASE MANAGEMENT SYSTEMS. STRUCTURES OF THE RELATIONAL MODEL: RELATIONSHIPS, TABLES, RELATIONAL DATABASES, SCHEMA AND INSTANCE OF A DATABASE. DATA QUERYING IN THE SQL LANGUAGE. SPREADSHEETS, PITOV TABLE FOR MULTIDIMENSIONAL DATA ANALYSIS IN EXCEL. DATA TRANSFORMATION FROM EXCEL FORMAT TO RELATIONAL TABLES. 2. PROJECT MANAGEMENT (10 HOURS OF FACE-TO-FACE LECTURES). BASIC CONCEPTS OF PROJECT MANAGEMENT: PROJECT DEFINITION, SCOPE OF A PROJECT, STAKEHOLDERS, WORK BREAKDOWN STRUCTURE (WBS). TIME, COST AND QUALITY DIMENSIONS FOR ANALYZING A PROJECT. PLANNING, MONITORING AND CONTROLLING THE RESOURCES AND ACTIVITIES REQUIRED TO IMPLEMENT A PROJECT. CPM AND PERT, PROJECT MANAGEMENT UNDER UNCERTAINTY.

Contents

THE COURSE IS DIVIDED INTO THREE PARTS 1) DATA MANAGEMENT SYSTEMS; 2) PROJECT MANAGEMENT; 3) WEB APPLICATIONS FOR TOURISM

1. DATA MANAGEMENT SYSTEMS (12 HOURS OF FACE-TO-FACE LECTURES).
INFORMATION SYSTEMS AND DATA SYSTEMS. DATABASES AND DATABASE MANAGEMENT SYSTEMS. STRUCTURES OF THE RELATIONAL MODEL: RELATIONSHIPS, TABLES, RELATIONAL DATABASES, SCHEMA AND INSTANCE OF A DATABASE. DATA QUERYING IN THE SQL LANGUAGE. SPREADSHEETS, PITOV TABLE FOR MULTIDIMENSIONAL DATA ANALYSIS IN EXCEL. DATA TRANSFORMATION FROM EXCEL FORMAT TO RELATIONAL TABLES.

2. PROJECT MANAGEMENT (10 HOURS OF FACE-TO-FACE LECTURES).
BASIC CONCEPTS OF PROJECT MANAGEMENT: PROJECT DEFINITION, SCOPE OF A PROJECT, STAKEHOLDERS, WORK BREAKDOWN STRUCTURE (WBS). TIME, COST AND QUALITY DIMENSIONS FOR ANALYZING A PROJECT. PLANNING, MONITORING AND CONTROLLING THE RESOURCES AND ACTIVITIES REQUIRED TO IMPLEMENT A PROJECT. CPM AND PERT, PROJECT MANAGEMENT UNDER UNCERTAINTY.

	Teaching Methods
	TEACHING INVOLVES STUDENTS' CONSTANT ATTENDANCE AT LECTURES. PRACTICAL EXERCISES AIMED AT BETTER ASSIMILATION OF THE CONCEPTS CONVEYED DURING THE LECTURES WILL BE PLANNED. STUDENTS WILL BE ORGANIZED INTO WORKING GROUPS, AND EACH GROUP WILL BE ASSIGNED A PROJECT TO CREATE A DATABASE AIMED AT MANAGING TOURISM DATA. THE PROJECT WILL INVOLVE THE USE OF BOTH SPREADSHEETS AND RELATIONAL DATABASE MANAGEMENT SYSTEMS. WORKING GROUPS WILL BE REQUIRED TO TRANSFER THE KNOWLEDGE GAINED TO THEIR ASSIGNED PROJECTS.

Teaching Methods

TEACHING INVOLVES STUDENTS' CONSTANT ATTENDANCE AT LECTURES. PRACTICAL EXERCISES AIMED AT BETTER ASSIMILATION OF THE CONCEPTS CONVEYED DURING THE LECTURES WILL BE PLANNED. STUDENTS WILL BE ORGANIZED INTO WORKING GROUPS, AND EACH GROUP WILL BE ASSIGNED A PROJECT TO CREATE A DATABASE AIMED AT MANAGING TOURISM DATA. THE PROJECT WILL INVOLVE THE USE OF BOTH SPREADSHEETS AND RELATIONAL DATABASE MANAGEMENT SYSTEMS. WORKING GROUPS WILL BE REQUIRED TO TRANSFER THE KNOWLEDGE GAINED TO THEIR ASSIGNED PROJECTS.

	Verification of learning
	FINAL PROOF (A) PROJECT DISCUSSION AND PRACTICE ON THE SOFTWARE TOOLS USED (10 POINTS). (B) ORAL TEST ON THE THEORETICAL CONTENT OF THE COURSE (20 POINTS).

	Texts
	1.S. CERI, P. FRATERNALI, S. PARABOSCHI, R. TORLONE, BASI DI DATI VI EDIZIONE, MC GRAW HILL, 2023. 2. LECTURE SLIDES AVAILABLE AT THE LINK THAT WILL BE PROVIDED AT THE FIRST LECTURE OF THE COURSE.

BETA VERSION Data source ESSE3 [Ultima Sincronizzazione: 2025-01-31]

Giancarlo NOTA | INFORMATION TECHNOLOGY FOR TOURIST SYSTEMS