AIMS AND CONTENT

LEARNING OUTCOMES

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.

AIMS AND LEARNING OUTCOMES

Students should acquire adequate knowledge of digital information management and an effective understanding of database analysis and design methodologies.

Each learner should be able to apply the acquired knowledge and to understand and solve information management problems related to the use of databases.

TEACHING METHODS

Face-to-face lectures and exercises

SYLLABUS/CONTENT

• Data and information
• Information management
• Information systems
• Databases and information management programs
• Logical models and conceptual models of data
• Analysis and enity relationship model 
• From analysis to design
• Implementation of databases
• Relational algebra
• SQL language
• Databases in PHP/MySQL client/server architecture
• Data representation
• Lab exercises

The course partially contributes to the achievement of the Sustainable Development Goals of Agenda UN 2030 No. 9 Industry, Innovation and Infrastructure by addressing issues of information management, which are key to promoting innovation.

RECOMMENDED READING/BIBLIOGRAPHY

Teacher notes.

Peoplewho who should not be able to attend class may refer to one of the following texts, suggested as additional material useful for exam preparation: 

• P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone, Databases Ed. Mac Graw Hill, 2009.
• R.A. Elmasri, S.B. Navathe, Database Systems, Fundamentals Ed. Pearson Addison Wesley, 2001. 

Note: The materials provided meet accessibility criteria and can be provided, upon request, in different formats for easier reference to correspond to specific needs.

TEACHERS AND EXAM BOARD

Exam Board

MAURO COCCOLI (President)

LESSONS

LESSONS START

First semester

Class schedule

The timetable for this course is available here: Portale EasyAcademy

EXAMS

EXAM DESCRIPTION

Written test and practical test with related oral discussion of a small self-made project. 

N.B.: The materials provided to take the exam comply with the criteria of accessibility and can be provided, upon request, in different formats for easier reference in correspondence with specific needs against which additional time may be granted for the conduct of the examination.

ASSESSMENT METHODS

The exam is divided in two parts: a written test and the presentation of a project that will be discussed with the lecturer.

Through the "written" test, the acquisition of theoretical basics and analytical skills are verified.

Through the "practical" test, the acquisition of operational skills and knowledge of the most appropriate computer tools are verified.

Exam schedule

FURTHER INFORMATION

People with a disability or with a DSA may request for compensatory/dispensatory measures for the exam writing to  the Contact Person for the course of the University Committee for the Support of Students with Disabilities and DSA. The contact person will inform the lecturer.