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

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.

FURTHER INFORMATION

Students with disabilities, Specific Learning Disorders (SLD), or Special Educational Needs (SEN) are reminded that, in order to request accommodations for examinations, they must first submit their certification to the University’s Student Inclusion Services for students with disabilities and SLD.

Subsequently, to request exam accommodations, students with a disability or SLD must complete the form available on the following page: Services for students with disabilities or SLD | UniGe | University of Genoa.

Students with SEN, on the other hand, are required to send an email to the course instructor, copying the School Inclusion Coordinator for students with disabilities and SLD (laura.traverso@unige.it) and the Student Inclusion Office (inclusione.studenti@info.unige.it). The email must include:

• the name of the course
• the date of the exam session
• the student’s surname, first name, and student ID number
• the compensatory tools and dispensatory measures deemed necessary and requested

For all students, requests for accommodations must be submitted well in advance (at least 7 working days before the exam date). Late requests may not be accepted.