CODE 66784 ACADEMIC YEAR 2020/2021 CREDITS 6 cfu anno 3 SCIENZE DELLA COMUNICAZIONE 8752 (L-20) - SAVONA SCIENTIFIC DISCIPLINARY SECTOR ING-INF/05 LANGUAGE Italian TEACHING LOCATION SAVONA SEMESTER 1° Semester PREREQUISITES Propedeuticità in ingresso Per sostenere l'esame di questo insegnamento è necessario aver sostenuto i seguenti esami: Communication science 8752 (coorte 2018/2019) COMPUTER SCIENZE FOR DIGITAL HUMANITIES 66729 2018 TEACHING MATERIALS AULAWEB OVERVIEW The course is going to present basics on information management, with particular reference to database analysis and design. Also, students will be provided with tools and programs to implement databases. We will discuss the general methodology to create databases on PCs and on the Web, including query language and design techniques. At the end of this course, students will be able to manage information, design and create databases. AIMS AND CONTENT LEARNING OUTCOMES The course aims at covering basics on database design and providing students with the needed capabilities to create and manage databases for network applications. AIMS AND LEARNING OUTCOMES The students will acquire an adequate level of knowledge on digital information management as well as capabilities in understanding database analysis and design. The students will be able to apply acquired notions and will have problem solving capabilities in the field of information management through database and database management systems. PREREQUISITES 66729 - FONDAMENTI DI INFORMATICA UMANISTICA OR 90597 - TECNOLOGIE E LINGUAGGI PER LE DIGITAL HUMANITIES TEACHING METHODS Active lectures Laboratory activities SYLLABUS/CONTENT Data and information Information management Information management systems Database and database management systems Logical and conceptual data models Entity-relationship analysis From analysis to design Database implementation Relational algebra SQL language Database in a client/server architecture with PHP/MySQL Hands-on laboratory RECOMMENDED READING/BIBLIOGRAPHY Teacher notes. R.A. Elmasri, S.B. Navathe, Fundamentals of Database Systems Ed. Pearson, 2016. TEACHERS AND EXAM BOARD MAURO COCCOLI Ricevimento: On lectures' days, at the Savona Universtity Campus. On appointment, at the Department DIBRIS in Genoa. On appointment, via Teams. Exam Board MAURO COCCOLI (President) GIANNI VIARDO VERCELLI GIOVANNI ADORNI (Substitute) LESSONS LESSONS START First semester 2020/2021 Class schedule METHODS AND MODELS FOR DIGITAL INFORMATION MANAGEMENT EXAMS EXAM DESCRIPTION Quizzes and project work. ASSESSMENT METHODS The quizzes aim to proving that the students have become proficient in information mamagement and database theory and have acquired analysis skills. The project work aims to proving that the students have acquired database design capabilities and skills in using database management system programs. Exam schedule Data appello Orario Luogo Degree type Note 13/01/2021 09:00 SAVONA Orale 27/01/2021 09:00 SAVONA Orale 10/02/2021 09:00 SAVONA Orale 17/05/2021 09:00 SAVONA Orale 31/05/2021 09:00 SAVONA Orale 14/06/2021 09:00 SAVONA Orale 28/06/2021 09:00 SAVONA Orale 13/09/2021 09:00 SAVONA Orale