CODE 66784 ACADEMIC YEAR 2021/2022 CREDITS 9 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 2019/2020) COMPUTER SCIENCE FOR DIGITAL HUMANITIES 90597 2019 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 class aims to provide students with a general overview of database analysis and design, as well as to develop their ability to create and manage databases on PCs and on the Web. 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) GIOVANNI ADORNI GIANNI VIARDO VERCELLI (Substitute) LESSONS LESSONS START First semester 2021/2022 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/2022 09:00 SAVONA Compitino 27/01/2022 09:00 SAVONA Compitino 10/02/2022 09:00 SAVONA Compitino 18/05/2022 09:00 SAVONA Compitino 01/06/2022 09:00 SAVONA Compitino 15/06/2022 09:00 SAVONA Compitino 29/06/2022 09:00 SAVONA Compitino 15/09/2022 09:00 SAVONA Compitino
