Select Academic Year:     2016/2017 2017/2018 2018/2019 2019/2020 2020/2021 2021/2022
Professor
ANDREA PINNA (Tit.)
Period
First Semester 
Teaching style
Convenzionale 
Lingua Insegnamento
ITALIANO 



Informazioni aggiuntive

Course Curriculum CFU Length(h)
[11/81]  SUSTAINABLE TOURISM MANAGEMENT AND MONITORING [81/00 - Ord. 2017]  PERCORSO COMUNE 9 54

Objectives

The course on Informative Systems and DBMS for STMM is addresses to students who have not yet acquired computer skills. The main objective of the course is to provide skills and abilities in the extraction and processing of data through computer programming in the Python language and through the support of a database to be designed and managed with the SQL language.
The course also aims to provide an overview of the main existing data formats and the archives of open data of interest in the tourism sector and on the main existing IT systems designed for the tourism sector.

Knowledge and understanding.
The student will know the basics of programming languages through a combined use of theoretical and practical notions of using the Python language and will understand how to implement an algorithm in such language with particular attention to data manipulation. He will understand the structure of a DBMS and will know the techniques for designing databases based on the description of a scenario. Will know and understand the methods of extracting Open data and will know the main information systems designed for tourism.


Ability and understanding.
The student will be able to apply the acquired knowledge through the design of simple schemes of relational databases and the relative queries, using the SQL language for the formulation of the queries. It will develop the ability to extract information from data.
The student will be able to apply the main informational programming concepts for
develop algorithms for solving complex problems in Python.


Autonomy of judgment.
The student will be able to evaluate which algorithms will be most convenient to implement in Python to manipulate the data in question. I will be able to choose SQL constructs to perform data extraction from the database. Will know how to decide how to collect and organize the storage and management of its own database. It will also be able to judge which development tools and tools
operative choose in different cases.


Communication skills.
The student will be able to dialogue with IT specialists on the choices and strategies to be adopted for the extraction, collection and organization of large data flows from and to databases and for the choice and implementation of algorithms for their manipulation.
He will be able to interact with company management for data of interest and core business and for their presentation to stakeholders.
They will be able to describe the data, both in written and oral form and will be able to use diagrams and graphs to effectively communicate, to experienced and non-expert interlocutors, the information and knowledge produced by the data extracted and analyzed.


Learning ability.
The student will consult different references, also in English, to acquire the ability to continuously update their professional knowledge in the IT field.
He will be able to independently learn advanced methodologies and new programming languages

Prerequisites

Knowledges.
-It is required the knowledge at a user level of an operating system and of the more popular applicative programs.

Abilities.
The student must reason in logical and mathematical terms and must use the PC and the web at basic user level.

Competences.
The student must have confidence with the mathematical logical and statistical instruments learned during the first three year degree.

Contents

Contents

Programming elements
- Overview of programming languages and the Python language.
- Simple data types (int, float, boolean, string).
- Variables, expressions.
- Control structures: if, while, for.
- Functions, procedures and passing of parameters.
- Structured data types (tuple, list, dictionary).
- Exceptions management.
- Standard I / O and I / O on file.

Data bases and open data
- CSV, XML and JSON formats and python data processing.
-Open date for tourism management.
-Introduction to the DBMS.
- Design, creation and management of schemes.
- SQL language and queries.
- Use Python libraries for interaction with DBMS.

ICT systems for tourism
- Central reservations system
-Customer relationship management
-Destination management system.
- Blockchain-Oriented systems for tourism.

Teaching Methods

-frontal lessons with graphical presentations
-Python and SQL practical sessions (in general using Pycharm e mySQL).

The professor will provide support during lessons and between lessons, as well as during receiving times and by mean of e-mail.

https://www.unica.it/unica/it/ateneo_s07_ss01_sss03.page?contentId=SHD191011

Verification of learning

The verification of learning will occur through written proves, with exercises about the entire course program.
Written prove: two parts
- Theory (40 minutes): quiz questions (true or false) and open-ended questions (tot 15 pt).
The quiz questions are worth 1 point if you answer correctly and -0.5 points if you answer incorrectly. 0 points if not answered.
- Programming (1 hour): two python programming exercises (tot 15 pt)

Both sides must reach a minimum score of 8 points. The exam is passed if the total score reaches or exceeds 18.


It is possible to integrate written proves with an oral prove.
It allows to add up to 4 points to the mark of the written test if both parts have a score of at least 8. In the case of a severely insufficient oral test the final grade is reduced by 1 point with respect to the mark of the written test.

Texts

Think Python: How to Think Like a Computer Scientist
Allen Downey
Green Tea Press
Wellesley, Massachusetts


P. Atzeni, S. Ceri, P Fraternali, S. Paraboschi, R. Torlone
Basi di Dati
Mc Graw Hill

R. Elmasri - S. Navathe
Fundamentals of Database Systems
Pearson Education Italia

More Information

Teaching material

The teaching material will be available in the official website. Students accounts will be set in laboratory computers where also teaching material can be shared.

Questionnaire and social

Share on: