Architecture of databases management systems. The Entity Relationship model. The relational model. Relational algebra: operators and queries. Analysis and transformation of an ER schema into a relational schema. Functional dependencies, normal forms, decomposition schemes. Introduction to concurrency control, reliability and log. The SQL language: basic concepts and advanced features. MySQL, a real databases management system.
P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone, Basi di dati ñ Modelli e linguaggi di interrogazione, seconda edizione, McGraw-Hill, 2006.
P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone, Basi di dati ñ Architetture e linee di evoluzione, seconda edizione, McGraw-Hill, 2007.
A. Albano, G. Ghelli, R. Orsini, Fondamenti di basi di dati, seconda edizione, Zanichelli, 2005.
P. J. Pratt, Guida a SQL, Apogeo, 2001.
L. Welling and L. Thomson, MySQL Tutorial, Pearson Education Italia, 2004.
Learning Objectives
Knowledge: The student acquires knowledge about the relational model, relational algebra and ER design methodology, in particular, learning to transform an ER diagram into a relational schema. Also captures the basic concepts and most advanced features of SQL learning how to translate the relational schema, and related query, in MySQL.
Acquired skills: The student will acquire the fundamental skills to design and analyse a relational database and to use it by means of a real databases management system, such as MySQL. Relational databases are the most used and are also of primary importance for the definition of concepts and methodologies developed further in subsequent proposals.
Capacity acquired at the end of the course: The student acquires the ability to design a database that meets the requirements of a specific application, accompanied by a critical assessment of the characteristics and performance. Additionally, the student will have the ability to critically evaluate databases already designed and / or implemented, and, if necessary, propose modifications in order to improve its structure. Finally, thanks to the skills acquired on the languages and databases systems, the student will be able to implement various aspects of applications that make intensive use of large amounts of data.
Prerequisites
Courses required: Programming
Teaching Methods
Total number of hours of the course: 225
Number of hours for personal study and other individual learning activities: 145
Number of hours on the classroom activity: 56
Number of hours related to laboratory activities (laboratory classes): 24
Further information
Frequency of lessons and practice: Recommended
Tools to support teaching UniFi E-Learning: http://el.unifi.it
Office hours:
By appointment via e-mail.
Department of Statistics, Computer Science, Applciations
Viale Morgagni, 65
50134 - Florence (FI)
Tel: 055 4237440 Fax: 055 4237436
E-Mail: donatella.merlini@unifi.it
Type of Assessment
Written exam and project in MySQL
Course program
Architecture of databases management systems. The Entity Relationship model. The relational model. Relational algebra: operators and queries. Analysis and transformation of an ER schema into a relational schema. Functional dependencies, normal forms, decomposition schemes. Introduction to concurrency control, reliability and log. The SQL language: basic concepts and advanced features. MySQL, a real databases management system.