ITA | ENG
B024254 - DATABASE MANAGEMENT SYSTEMS
Main information
Teaching Language
Course Content
Suggested readings
Learning Objectives
Prerequisites
Teaching Methods
Further information
Type of Assessment
Course program
Academic Year 2020-21
Course year
Third year - First Semester
Belonging Department
Information Engineering (DINFO)
Modulo di sola Frequenza of
Scientific Area
ING-INF/05 - INFORMATION PROCESSING SYSTEMS
Credits
6
Teaching Hours
54
Teaching Term
14/09/2020 ⇒ 18/12/2020
Attendance required
No
Type of Evaluation
Giudizio Finale
Course Content
show
Course program
show
Lectureship
Mutuality
Course teached as:
B003376 - BASI DI DATI
3-years First Cycle Degree (DM 270/04) in COMPUTER ENGINEERING
Curriculum TECNICO SCIENTIFICO
B003376 - BASI DI DATI
3-years First Cycle Degree (DM 270/04) in COMPUTER ENGINEERING
Curriculum TECNICO SCIENTIFICO
Teaching Language
Italian
Course Content
Relational algebra; the relational model; SQL: constructs to create and query a database; database design using the Entity-relationship model; analysis of ER diagrams and translation to the relational model; triggers; transactions; functional dependencies and normal forms; database normalization; case studies: PostgreSQL
Suggested readings (Search our library's catalogue)
Sistemi di Basi di Dati - Fondamenti
R.A. Elmasri, S.B. Navathe
Ed. Pearson, Addison Wesley
Basi di dati: Modelli e linguaggi di interrogazione
P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone
Ed. McGraw-Hill
R.A. Elmasri, S.B. Navathe
Ed. Pearson, Addison Wesley
Basi di dati: Modelli e linguaggi di interrogazione
P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone
Ed. McGraw-Hill
Learning Objectives
- The relational model
- Management and query of databases using the SQL
- database design using the Entity relationship model
- Translation of ER diagrams into the relational model
- Database normalization
- Management and query of databases using the SQL
- database design using the Entity relationship model
- Translation of ER diagrams into the relational model
- Database normalization
Prerequisites
Operating systems
Teaching Methods
Class lectures (45 h) and lab activities (10 h)
Further information
Handsout available through the e-learning system https://e-l.unifi.it/
Type of Assessment
written and oral test
Course program
The relational model (tables and integrity constraints); relational algebra (union intersection, difference, select, project, join); the SQL language (data types, integrity constraints, the basic select construct, aggregate operators, nested queries, correlated queries, scalar queries, views); Database design using the Entity-relationship model; Analysis of ER diagrams; normal forms and functional dependencies; database normalization; Triggers; Transactions; case studies: PostgreSQL