Information Technology (2019/2020)

Course code
4S00093
Name of lecturer
Riccardo Muradore
Coordinator
Riccardo Muradore
Number of ECTS credits allocated
6
Academic sector
INF/01 - INFORMATICS
Language of instruction
English
Location
VERONA
Period
Sem 2A dal Feb 17, 2020 al Mar 28, 2020.

Lesson timetable

Go to lesson schedule

Learning outcomes

The course objective is to give students basic concepts of theory of probability and of database management. At the end of the course, the student will be able to - do basic statistical analysis on data, - manage a database.

Syllabus

THEORY.
The course will comprise two distinct parts.
The first part will provide basic notions of probability and statistics:
- Introduction to probability: random variables, mean, variance, expectation, independence, conditionally independence
- Linear methods for regression
- Least Square methods

The second part will focus on fundamentals of database systems:
- Introduction to Database theory
- Entity-Relation paradigm
- Examples of Structured Query Language (SQL)

LABORATORY.
Laboratory activities using the Statistical Toolbox of Matlab
Laboratory activities on a database

TEACHIN AIDS: During the course lecture notes and slides will be provided.

Reference books
Author Title Publisher Year ISBN Note
R. Elmasri, S. B. Navathe Fundamentals of database systems Pearson Education 2008
Papoulis, A., Pillai, U Probability, random variables and stochastic processes (Edizione 4) New York: McGraw-Hill 2001

Assessment methods and criteria

The exam will consist of a project addressing some topics discussed during the course. To pass the exam, the student should:
- have understood the principles related to probability and statistics, and database management,
- be able to use the knowledge acquired during the course to solve the assigned project,
- be able to describe their work.

Due to the Coronavirus pandemic, and in accordance with the University of Verona guidelines, during ​the 2020 summer session the assessment modality will be modified as follows: online oral exam.