Notions on the fundamentals of informatics.
Principles of digital transmission and codes.
Basic general programming techniques.
Knowledge on the architecture and the design criteria of modern information systems.
Ability to design databases, at the conceptual and logical levels.
Knowledge of the entity-relationship model and the relational model for data.
Ability to define the schema of a database in a DBMS and to issue queries using the SQL language.
Acquiring the basic notions about OLAP and data mining.
Knowledge of the design issues in computer networks.
Knowledge of TCP/IP protocols.
Ability to design and implement Web applications.
Introduction to information systems. Databases and Database Management Systems (DBMS). The relational data model. The SQL Language. Conceptual design. OLAP and data mining.
Paolo Atzeni, Stefano Ceri, Stefano Paraboschi, Riccardo Torlone “Modelli e linguaggi di interrogazione”, The McGraw-Hill companies
James F. Kurose, Keith W. Ross, "Computer Networking - A top down approach", Pearson Addison Wesley
Lectures on theory. Practical classwork.
Practical, written and oral examination.
Discussion of a homework assignment (Web application requiring the design of a database).
The course slides and support material are available on the course web site in USiena integra (https://elearning.unisi.it/)