Skip to main content
CODE 66784
ACADEMIC YEAR 2020/2021
CREDITS
SCIENTIFIC DISCIPLINARY SECTOR ING-INF/05
LANGUAGE Italian
TEACHING LOCATION
  • SAVONA
SEMESTER 1° Semester
PREREQUISITES
Propedeuticità in ingresso
Per sostenere l'esame di questo insegnamento è necessario aver sostenuto i seguenti esami:
  • Communication science 8752 (coorte 2018/2019)
  • COMPUTER SCIENZE FOR DIGITAL HUMANITIES 66729 2018
TEACHING MATERIALS AULAWEB

OVERVIEW

The course is going to present basics on information management, with particular reference to database analysis and design. Also, students will be provided with tools and programs to implement databases. We will discuss the general methodology to create databases on PCs and on the Web, including query language and design techniques. At the end of this course, students will be able to manage information, design and create databases.

AIMS AND CONTENT

LEARNING OUTCOMES

The course aims at covering basics on database design and providing students with the needed capabilities to create and manage databases for network applications.

AIMS AND LEARNING OUTCOMES

The students will acquire an adequate level of knowledge on digital information management as well as capabilities in understanding database analysis and design. 

The students will be able to apply acquired notions and will have problem solving capabilities in the field of information management through database and database management systems. 

PREREQUISITES

66729 - FONDAMENTI DI INFORMATICA UMANISTICA

OR

90597 - TECNOLOGIE E LINGUAGGI PER LE DIGITAL HUMANITIES

TEACHING METHODS

Active lectures
Laboratory activities

SYLLABUS/CONTENT

Data and information
Information management
Information management systems
Database and database management systems
Logical and conceptual data models

Entity-relationship analysis 
From analysis to design
Database implementation
Relational algebra
SQL language
Database in a client/server architecture with PHP/MySQL
Hands-on laboratory

 

RECOMMENDED READING/BIBLIOGRAPHY

Teacher notes. 

R.A. Elmasri, S.B. Navathe, Fundamentals of Database Systems Ed. Pearson, 2016. 

TEACHERS AND EXAM BOARD

Exam Board

MAURO COCCOLI (President)

GIANNI VIARDO VERCELLI

GIOVANNI ADORNI (Substitute)

LESSONS

LESSONS START

First semester 2020/2021

EXAMS

EXAM DESCRIPTION

Quizzes and project work.

ASSESSMENT METHODS

The quizzes aim to proving that the students have become proficient in information mamagement and database theory and have acquired analysis skills. 

The project work aims to proving  that the students have acquired database design capabilities and skills in using database management system programs. 

Exam schedule

Data appello Orario Luogo Degree type Note
13/01/2021 09:00 SAVONA Orale
27/01/2021 09:00 SAVONA Orale
10/02/2021 09:00 SAVONA Orale
17/05/2021 09:00 SAVONA Orale
31/05/2021 09:00 SAVONA Orale
14/06/2021 09:00 SAVONA Orale
28/06/2021 09:00 SAVONA Orale
13/09/2021 09:00 SAVONA Orale