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.
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 activities using the Statistical Toolbox of Matlab
Laboratory activities on a database
TEACHIN AIDS: During the course lecture notes and slides will be provided.
|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|
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.