Students are expected to acquire: - the ability to represent, organize, and retrieve data with the relational data base model and the SQL query language; - competence in database design with the entity relationship model The associated web laboratory introduces server-side programming in PHP and provide students with the necessary skills to implement a web application requiring the use of a database and the generation of dynamic web pages.
- In the written exam, the student must demonstrate his/her knowledge of the course material and to organise an effective and correctly written reply. - In the oral exam the student must demonstrate the ability to put into practice and to execute, with critical awareness, the activities illustrated or carried out under the guidance of the teacher during the course.
Methods:
Further information:
For the first module (data bases) there are two intermediate written tests. The exam consists in a written test and an oral exam. The second module requires the implementation and oral discussion of a project.
Delivery: face to face
Attendance: Advised
Learning activities:
Teaching methods:
MODULE 1: Data bases Relational data bases: models and languages - The relationa model - Algebra and relational calculus - SQL Data base design - Methods and models for design - Conceptual design - Logical design Laboratory: nonSQL database
MODULE 2: Web laboratory - Client-server architecture; dynamic web pages -The PHP language = My SQL - Project
Teacher slides and material
P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone. Basi di dati: modelli e linguaggi di interrogazione (Seconda o Terza Edizione) McGraw-Hill Italia, 2000-2006.
Antonio Albano: Sistemi per l'archiviazione e il recupero delle informazioni (booklet)
Course material is available from the course web site: https://elearning.humnet.unipi.it/course/view.php?id=2111
No difference
written test
project
project presentation and discussion
oral test