OVERVIEW

The course provides basic skills on the design of information systems and on the conceptual, logical and physical structure of relational databases

AIMS AND CONTENT

LEARNING OUTCOMES

This teaching unit introduces database design and their lifecycle, the tools for their design, the languages for the creation, querying, and manipulation of centralized databases, and the fundamentals of relational databases.

AIMS AND LEARNING OUTCOMES

Enrolled students will be able to apply the acquired knowledge through the design of simple relational databases and queries. The design will focus on the Entity-Relation model (ER), while SQL will be used to formulate queries. Also, the course will provide a minimal introduction to the Python programming language to integrate the learned concepts and integrate databases inside applications.

PREREQUISITES

Knowledge of the fundamentals of programming and notions of mathematical analysis

TEACHING METHODS

In-person classes with slides-aided explanations.
Programming exercises with both SQL and Python.

Students with valid certifications for Specific Learning Disorders (SLD), disabilities, or other special educational needs are invited to contact the instructor and the Politecnica School's disability representative, Prof. Federico Scarpa (federico.scarpa@unige.it), at the beginning of the course. This will allow them to discuss and agree upon any necessary teaching adjustments that, while respecting the course objectives, take individual learning styles into account.

SYLLABUS/CONTENT

1. Architectures of modern databases
2. Entity-Relation model: implementation of tables and queries using SQL
3. Design of tables through the ER model, and translation into the logic model
4. Queries with SQL and integration with Python

RECOMMENDED READING/BIBLIOGRAPHY

Ramez Elmasri, Shamkant B. Navathe, Sistemi di Basi di Dati - Fondamenti e Complementi ,7/E, Pearson, 2018.

All the provided material will be shared on Aulaweb. Notes taken during class are sufficient to prepare the exam.

TEACHERS AND EXAM BOARD

Exam Board

ANTONIO SGORBISSA (President)

LUCA DEMETRIO

FABIO ROLI (President Substitute)

LESSONS

LESSONS START

https://corsi.unige.it/corsi/8719/studenti-orario

EXAMS

EXAM DESCRIPTION

Evaluations during the semester (closed-book exams with questions and programming exercises), or final written exam plus optional oral exam.

Valutazioni in classe durante il semestre (soluzione a libro chiuso di esercizi numerici/programmazione e domande a risposta aperta), oppure esame scritto finale ed orale facoltativo.

ASSESSMENT METHODS

Solving exercises requiring the design of conceptual and logical schemas, loading data into a database, querying databases and presentation of the results of the queries.

FURTHER INFORMATION

Contact the teachers of the course to ask for more informatio.