Unit DATABASES
- Course
- Programming and management of computer systems
- Study-unit Code
- GP000703
- Curriculum
- In all curricula
- Teacher
- Alessandra Tappini
- Teachers
-
- Alessandra Tappini
- Hours
- 42 ore - Alessandra Tappini
- CFU
- 6
- Course Regulation
- Coorte 2023
- Offered
- 2023/24
- Learning activities
- Affine/integrativa
- Area
- Attività formative affini o integrative
- Academic discipline
- ING-INF/05
- Type of study-unit
- Obbligatorio (Required)
- Type of learning activities
- Attività formativa monodisciplinare
- Language of instruction
- Italian
- Contents
- Relational Databases: Model and Languages. Relational Model. Integrity Constraints. Relational Algebra: Union, Intersection, Difference, Selection, Projection, and Join. Relational Calculus: Calculus on Domains, Calculus on Tuples with Range Declaration. SQL Language: Definition of Data, Query, Data Manipulation. Design of Databases: Design Methodologies and Models. The Entity-Relationship Model. Conceptual Design. Logical Design: Restructuring E-R Schemas, Translation to the Relational Model.
- Reference texts
- "BASI DI DATI." P. ATZENI, S. CERI, P. FRATERNALI, S, PARABOSCHI, R. TORLONE, MCGRAW HILL, VI EDIZIONE.
Slides provided by the teacher. - Educational objectives
- The objective of the course is to acquire skills related to the design and querying of relational databases.
- Prerequisites
- None.
- Teaching methods
- Lessons held in the classroom.
- Other information
- Attendance is recommended. However, all the treated topics can be found on the suggested textbook.
- Learning verification modality
- The exam consists of a test of both a theoretical and practical nature.
- Extended program
- - Relational Databases: Model and Languages.
- Relational Model. Integrity Constraints.
- Relational Algebra: Union, Intersection, Difference, Selection, Projection, and Join.
- Relational Calculus: Calculus on Domains, Calculus on Tuples with Range Declaration.
- SQL Language: Definition of Data, Query, Data Manipulation.
- Design of Databases: Design Methodologies and Models. The Entity-Relationship Model.
- Conceptual Design.
- Logical Design: Restructuring E-R Schemas, Translation to the Relational Model.