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 as well as to visualize data. At the end of this course, students will be able to manage information, design and create databases.

AIMS AND CONTENT

LEARNING OUTCOMES

The class aims to provide students with a general overview of database analysis and design, as well as to develop their ability to create and manage databases on PCs and on the Web.

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 as well as data visualization tolls.

PREREQUISITES

66729 - FONDAMENTI DI INFORMATICA UMANISTICA

OR

90597 - TECNOLOGIE E LINGUAGGI PER LE DIGITAL HUMANITIES

TEACHING METHODS

Active lectures
Laboratory activities

Please note that the university laboratory and rooms meet more common accessibility criteria and they can be enhanced with specific aids and supporting technologies to make easy using computers  for everyone, according to their specific needs.

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
Data visualization
Hands-on laboratory

RECOMMENDED READING/BIBLIOGRAPHY

Teacher notes. 

People who cannot attend lessons will make reference to the book below, suggested as additional material, useful to face the final exam: 

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

Please note that the provided learning materials meet more common accessibility criteria, however they can be arranged in different formats, if needed, to improve their ease-of-use, according to each students' specific needs.

TEACHERS AND EXAM BOARD

Exam Board

MAURO COCCOLI (President)

GIANNI VIARDO VERCELLI

GIOVANNI ADORNI (Substitute)

LESSONS

LESSONS START

First semester 2022/2023

Class schedule

METHODS AND MODELS FOR DIGITAL INFORMATION MANAGEMENT

EXAMS

EXAM DESCRIPTION

Quizzes and project work.

Please note that the provided exam materials meet more common accessibility criteria, however they can be arranged in different formats, if needed, to improve their ease-of-use, according to each students' specific needs; moreover, an extra time will be given to finish the exam if needed.

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

FURTHER INFORMATION

Students with disabilities or learning disorders are allowed to use specific modalities and supports that will be determined on a case-by-case basis in agreement with the Delegate for the course in the Committee for the Inclusion of Students with Disabilities. Students are invited to contact the teacher and copy the Delegate.