Databases
Persone
Docente titolare del corso
Assistente
Descrizione
The course covers all the classical topics related to databases and database management systems (DBMS), starting from the general concepts of information and data, the conceptual and logical design of a database, to the specifics of the use of a relational database management system (MySQL), including issues of normalisation and the use of Relational Algebra. The course takes also a practical perspectives, guiding the students through the design and implementation of a database as indicated in an individual case study.
Obiettivi
The course teaches the basis of the design and management of the structured information contained in databases.
Modalità di insegnamento
In presenza
Impostazione pedagogico-didattica
The course is divided in two parts running in parallel. A theoretical part that presents the fundamentals of database design, the entity-relation model, the relational model and the relational algebra and a practical part that consolidates the theoretical teachings using a large set of examples and applications. As part of the practical part, an individual database design project based on MySQL is assigned to each student in order to expose the student to realistic database applications.
Modalità d’esame
Students knowledge will be tested using 3 theoretical and 1 practical tests during the semester (no final exam). The final mark will be the average mark of these tests.
Bibliografia
- Elmasri, Ramez, Navathe, Sham. Database systems. Seventh edition. Columbus Indianapolis New York San Francisco Hoboken Amsterdam Cape Town Dubai London Madrid Milan Munich Paris Montreal Toronto Delhi Mexico City São Paulo Sydney Hong Kong Seoul Singapore Taipei Tokyo: Pearson, 2016.
- Elmasri, Ramez, Navathe, Shamkant B, Navathe, Sham. Database systems: models, languages, design, and application programming. 6th ed. ; global ed.. Upper Saddle River, N.J.: Pearson Education, 2011.
Offerta formativa
- Master of Science in Economics, Lezione, 1° anno
- Master of Science in Economics, Lezione, 120 ECTS, A scelta, 2° anno
- Master of Science in Economics, Lezione, Internship or Electives, A scelta, 2° anno
- Master of Science in Management and Informatics, Lezione, 1° anno