View syllabus
DATA BASES AND WEB LABORATORY
FABRIZIO ENRICO ERMINIO BAIARDI
Academic year2018/19
CourseDIGITAL HUMANITIES
Code435AA
Credits12
PeriodSemester 1 & 2
LanguageItalian

ModulesAreaTypeHoursTeacher(s)
BASI DI DATIINF/01LEZIONI42
FABRIZIO ENRICO ERMINIO BAIARDI unimap
LABORATORIO WEBINF/01LEZIONI42
FABRIZIO ENRICO ERMINIO BAIARDI unimap
BARBARA GUIDI unimap
Learning outcomes
Knowledge

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.

Assessment criteria of knowledge

- 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:

  • Final oral exam
  • Final laboratory practical demonstration
  • Periodic written tests

 

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.

Teaching methods

Delivery: face to face

Attendance: Advised

Learning activities:

  • attending lectures
  • individual study
  • group work
  • Laboratory work

 

Teaching methods:

  • Lectures
  • laboratory

 

Syllabus

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

Bibliography

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

Non-attending students info

No difference

Assessment methods

written test

project

project presentation and discussion

oral test 

Updated: 20/09/2018 16:07