Unit DATABASE MANAGEMENT SYSTEMS
- Course
- Electronic engineering for the internet-of-things
- Study-unit Code
- A003157
- Curriculum
- Consumer and aerospace iot
- Teacher
- Giuseppe Liotta
- Teachers
-
- Giuseppe Liotta
- Hours
- 81 ore - Giuseppe Liotta
- CFU
- 9
- Course Regulation
- Coorte 2022
- Offered
- 2022/23
- Learning activities
- Affine/integrativa
- Area
- Attività formative affini o integrative
- Academic discipline
- ING-INF/05
- Type of study-unit
- Opzionale (Optional)
- Type of learning activities
- Attività formativa monodisciplinare
- Language of instruction
- Italian
- Contents
- The main topics of the course are:
- Models and Languages for relational data bases: SQL, Relational Algebra, Relational Calculus
- Data base design: the ER model and the conceptual design. Translation of a conceptual schema into a logical schema. The normalization of a data base.
- The technology of a DBMS: The architecture of a DBMS and the structure of a dta base at the physical level. Sequential and hash structures, indices, B-trees, queries optimization. the physical structure of a data base
- Concurrency control in a DBMS. Theory of concurrency: view serializability and conflict equivalence. 2PL protocol and deadlock. Schedule based on time stamps. - Reference texts
- "BASI DI DATI : MODELLI E LINGUAGGI DI INTERROGAZIONE." P. ATZENI, S. CERI, P. FRATERNALI, S, PARABOSCHI, R. TORLONE, MCGRAW HILL QUARTA EDIZIONE
- Educational objectives
- Studemts are expected to learn the basic techniques to query, design, and mainatin a relational data base.
- Prerequisites
- Students are expected to know the basics of computer programming, computer architectures, algorithms and data structures. Students who take the exam of Data Base Management Systems are required to have already taken the exam called "Fundamentals of Computer Science".
- Teaching methods
- There are three types of lectures:
Lectures devoted to the theory of data bases.Students can download the slided of each lecture of this type before coming to class.
Case studies,where the theory is applied to concrete examples and exercises similar to those given during the final test are discussed.
Lectures about the practice of querying data bases. These lectures are devoted to SQl and some of them are given using the computer lab. - Other information
- Coming to classes is not mandatory but it is strongly recommended. The teacher experience is that almost all students who come to class pass the exam right at the end of the class and with marks above average; those who do not come to class regularly may have a harder time passing the exam.
Office hours every Teusday from 6:00 p.m. to 7:30 p.m.. Students are welcome to meet the teacher outside office hours upon e-mail exchange to shedule the meeting. - Learning verification modality
- The exam consists of two distinct evaluation tests
Written test
Duration:2 hours
Score: 21/30
Objective: evaluating the knowledge of theoretical concepts learned in the course and assessing basic abilities of manging and querying a data base
Oral test
Duration: 30 minutes
Score: 9/30
Objective: evaluating the ability of designing a simple data base, based on the result of a course assignment (tesina) where the students design a simple data base
The results of the exam are presented by the teacher to the student during a short discussion, in which the student can reply with his/her own observations. - Extended program
- Lectures are given in Italian. We report below, for each lecture, the covered topic (in Italian). Each topic is covered in one or more lectures lecture; each lecture cosnists of two hours in the classoroom/lab.
Lect.1: Presentazione del corso
Lect. 2: Modello relazionale
Lect. 3: Modello relazionale
Lect. 4: Esercitazione Modello Relazionale
Lect. 5: Algebra Relazionale
Lect. 6: Esercizi Algebra Relazione
Lect. 7: Calcolo relazionale
Lect. 8: Esercitazione Calcolo Rel.+ Laboratorio SQL DDL
Lect. 9: SQL-Interrogazioni semplic
Lect. 10: SQL-Interrogazioni complesse
Lect. 11: SQL-fine
Lect. 12: Esercitazione Laboratorio SQL
Lect. 13: Metodologie e modelli di progetto
Lect. 14: ER e progettazione concettuale
Lect. 15: ProgettazioneConcettuale
Lect. 16: Pattern
Lect. 17: ProgettazioneLogica-Ristrutturazione
Lect. 18: Esercitazione sulla Progettazione Concettuale (ER)
Lect. 19: ProgettazioneLogica-traduzione + Esercizio
Lect. 20: Esercitazione su Progettazione Logica
Lect. 21: Normalizzazione
Lect. 22: Esercitazione su normalizzazione (Copertura, Sintesi, esercizi)
Lect. 23: Progettazione fisica
Lect. 24: Progettazione fisica
Lect. 25: Progettazione fisica
Lect. 26: Progettazione fisica
Lect. 27: Progettazione fisica
Lect. 28: Esercitazione su progettazione fisica
Lect. 29: Affidabilità e concorrenza
Lect. 30: Esercitazione su progettazione fisica
Lect. 31:Affidabilità e concorrenza
Lect. 32: ANCORA SQL: Caratteristiche evolute ed applicazioni
Lect. 33: Affidabilità e concorrenza
Lect. 34: ANCORA SQL: Caratteristiche evolute ed applicazioni
Lect. 35:Esercitazione su SQL
Lect. 36: Esercitazione su affidabilità e concorrenza