Study-unit DATABASE MANAGEMENT SYSTEMS
Course name | Computer science and electronic engineering |
---|---|
Study-unit Code | 70A00091 |
Curriculum | Ingegneria informatica |
Lecturer | Giuseppe Liotta |
Lecturers |
|
Hours |
|
CFU | 9 |
Course Regulation | Coorte 2021 |
Supplied | 2023/24 |
Supplied other course regulation | |
Learning activities | Caratterizzante |
Area | Ingegneria informatica |
Sector | ING-INF/05 |
Type of study-unit | Obbligatorio (Required) |
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 |