Salta al contenuto principale della pagina

INFORMATION SYSTEMS

CODE 97163
ACADEMIC YEAR 2022/2023
CREDITS
  • 9 cfu during the 2nd year of 10716 INGEGNERIA GESTIONALE (L-9) - GENOVA
  • SCIENTIFIC DISCIPLINARY SECTOR ING-INF/05
    LANGUAGE Italian (English on demand)
    TEACHING LOCATION
  • GENOVA
  • SEMESTER 2° Semester
    TEACHING MATERIALS AULAWEB

    OVERVIEW

    The course of Information Systems provides the basic knowledge, skills and abilities for the management and operation of a relational database, providing the essential elements of the SQL language for queries. The first part of the course is related to the conceptual design of a relational database. The second deals with the logical design. The last part of the course is about the development of queries using the SQL and Python programming languages.

     

    AIMS AND CONTENT

    LEARNING OUTCOMES

    The aim of this course is to provide students with fundamental concepts on data base management systems, with a special focus on relational data bases.

    AIMS AND LEARNING OUTCOMES

    This course is aimed to provide the student with the knowledge and understanding of the relational data model. In particular, the techniques and methodologies to design, build, manage and maintain a relational database are described. The conceptual database design is carried out through the ER (Entity Relationship) model, while the design of queries is carried out through the SQL language.

    PREREQUISITES

    The student must have the knowledge of data representation in computers, computer architecture, basic algorithms for sorting and searching, high-level programming languages.

     

    TEACHING METHODS

    Lectures with slides.
    Exercises on design of data base systems and queries with the SQL language.

    SYLLABUS/CONTENT

    1. Database Architecture. 
    2. The relational model, table definition and query formulation in SQL and relational algebra.
    3. Database conceptual design using the ER model, and ER-to-Relational mapping.
    4. SQL and Python programming languages.
     

    RECOMMENDED READING/BIBLIOGRAPHY

    Ramez Elmasri, Shamkant B. Navathe, Fundamentals of Database Systems, 7/E, Pearson, 2017

    TEACHERS AND EXAM BOARD

    Exam Board

    FABIO ROLI (President)

    LUCA DEMETRIO

    LUCA ONETO

    LESSONS

    Class schedule

    All class schedules are posted on the EasyAcademy portal.

    EXAMS

    EXAM DESCRIPTION

    Intermediate in class assignments (closed-book solutions of numerical/coding exercises and open-ended questions), or final written exam.

    ASSESSMENT METHODS

    Cclosed-book solutions of numerical/coding exercises and open-ended questions.

    Exam schedule

    Date Time Location Type Notes
    12/06/2023 09:00 GENOVA Scritto Le modalità di dettaglio della prova d'esame sono descritte dal docente durante il corso.
    10/07/2023 09:00 GENOVA Scritto Le modalità di dettaglio della prova d'esame sono descritte dal docente durante il corso.
    12/09/2023 09:00 GENOVA Scritto Le modalità di dettaglio della prova d'esame sono descritte dal docente durante il corso.

    FURTHER INFORMATION

    Contact the instructor by email