CODE 97163 ACADEMIC YEAR 2022/2023 CREDITS 9 cfu anno 2 INGEGNERIA GESTIONALE 10716 (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 FABIO ROLI Ricevimento: Contact the instructor by email. LUCA DEMETRIO Exam Board FABIO ROLI (President) LUCA DEMETRIO LUCA ONETO LESSONS LESSONS START https://corsi.unige.it/10716/p/studenti-orario Class schedule The timetable for this course is available here: Portale EasyAcademy 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 Data appello Orario Luogo Degree type Note 12/06/2023 15:30 GENOVA Scritto 10/07/2023 09:00 GENOVA Scritto 12/09/2023 09:00 GENOVA Scritto FURTHER INFORMATION Contact the instructor by email
