Salta al contenuto principale della pagina

METHODS AND MODELS FOR DIGITAL INFORMATION MANAGEMENT

CODE 66784
ACADEMIC YEAR 2021/2022
CREDITS
  • 9 cfu during the 3nd year of 8752 SCIENZE DELLA COMUNICAZIONE (L-20) - SAVONA
  • SCIENTIFIC DISCIPLINARY SECTOR ING-INF/05
    LANGUAGE Italian
    TEACHING LOCATION
  • SAVONA
  • SEMESTER 1° Semester
    PREREQUISITES
    Prerequisites
    You can take the exam for this unit if you passed the following exam(s):
    • Communication science 8752 (coorte 2019/2020)
    • COMPUTER SCIENCE FOR DIGITAL HUMANITIES 90597
    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

    Exam Board

    MAURO COCCOLI (President)

    GIOVANNI ADORNI

    GIANNI VIARDO VERCELLI (Substitute)

    LESSONS

    LESSONS START

    First semester 2021/2022

    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

    Date Time Location Type Notes
    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