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.
The course aims at covering basics on database design and providing students with the needed capabilities to create and manage databases for network applications.
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.
66729 - FONDAMENTI DI INFORMATICA UMANISTICA
OR
90597 - TECNOLOGIE E LINGUAGGI PER LE DIGITAL HUMANITIES
Active lectures Laboratory activities
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
Teacher notes.
R.A. Elmasri, S.B. Navathe, Fundamentals of Database Systems Ed. Pearson, 2016.
Ricevimento: On lectures' days, at the Savona Universtity Campus. On appointment, at the Department DIBRIS in Genoa. On appointment, via Teams.
MAURO COCCOLI (President)
GIANNI VIARDO VERCELLI
GIOVANNI ADORNI (Substitute)
First semester 2020/2021
METHODS AND MODELS FOR DIGITAL INFORMATION MANAGEMENT
Quizzes and project work.
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.
