CODE | 97163 |
---|---|
ACADEMIC YEAR | 2022/2023 |
CREDITS |
|
SCIENTIFIC DISCIPLINARY SECTOR | ING-INF/05 |
LANGUAGE | Italian (English on demand) |
TEACHING LOCATION |
|
SEMESTER | 2° Semester |
TEACHING MATERIALS | AULAWEB |
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.
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.
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.
The student must have the knowledge of data representation in computers, computer architecture, basic algorithms for sorting and searching, high-level programming languages.
Lectures with slides.
Exercises on design of data base systems and queries with the SQL language.
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.
Ramez Elmasri, Shamkant B. Navathe, Fundamentals of Database Systems, 7/E, Pearson, 2017
Office hours: Contact the instructor by email.
FABIO ROLI (President)
LUCA DEMETRIO
LUCA ONETO
All class schedules are posted on the EasyAcademy portal.
Intermediate in class assignments (closed-book solutions of numerical/coding exercises and open-ended questions), or final written exam.
Cclosed-book solutions of numerical/coding exercises and open-ended questions.
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. |
Contact the instructor by email