DATABASE DESIGN

Insegnamento
DATABASE DESIGN
Insegnamento in inglese
DATABASE DESIGN
Settore disciplinare
ING-INF/05
Corso di studi di riferimento
EUROPEAN HERITAGE, DIGITAL MEDIA AND THE INFORMATION SOCIETY
Crediti
6.0
Ripartizione oraria
Ore Attività frontale: 42.0
Anno accademico
2018/2019
Anno di erogazione
2018/2019
Anno di corso
1
Lingua
INGLESE
Percorso
INTERNAZIONALE
Docente responsabile dell'erogazione
BOCHICCHIO Mario Alessandro

Descrizione dell'insegnamento

Course presentation and aim

The course aims at providing the students coming from the humanities with the basics of Database Design. A particular focus will be placed on theories and tools that have become fundamental in their primary field of interest.

The following topics will be taught:

- Database and relational databases;

- Database management systems;

- Relational Model and Relational Algebra;

- SQL: data definition and manipulation;

- Basics of Computer-Human Interaction: data-centric user interfaces;

- Architectural aspects: Desktop Applications, Web Applications and Apps;

- Principles of Data Analytics;

- Database applications for Humanities and Cultural Heritage.

Reference material:

All needed reference material is composed, organized and constantly updated by the teacher. It will be posted in the course moodle site.

Textbook

“Fundamentals of Data Base Systems", 6th Edition, Elmasri & Navathe, Pearson International Edition

As a secondary reference, the following texts may be consulted:

- "Datawarehouse Design- Modern Principles and Methodologies", Matteo Golfarelli, Stefano Rizzi, McGrawHill

Acquired skills

The student will be able to understand data model, to interact with existing databases and to collaborate with software engineers to design data-centric applications. Such skills will prove useful in other courses (ex. web technologies) to design online applications and online services for humanities.

Teaching method

Frontal lessons and lectures, for theoretical aspects, will be followed by participatory learning sessions and hands-on sessions to reinforce the comprehension and to acquire the abilities relevant to the field of database design.

Students evaluation

Students will be asked to solve problems including theoretical and practical task, by means of a computer, within a given time.

Semestre
Primo Semestre (dal 24/09/2018 al 25/01/2019)

Tipo esame
Obbligatorio

Valutazione
Orale - Voto Finale

Orario dell'insegnamento
https://easyroom.unisalento.it/Orario