OVERVIEW

The course aims to provide the student with an essential knowledge of the world of databases. This choice, in the field of medical informatics, is due to the fact that databases are essential elements of health information systems. It was also chosen to guide the student in the design and implementation of web-based interfaces. Furthermore, this operational knowledge is particularly appreciated in today's world of work.

AIMS AND CONTENT

LEARNING OUTCOMES

Practical teaching of the use of databases in the field of medical informatics. It is intended that the student learns to model a database of medical and / or biological interest at a conceptual and logical level and to interface them with desktop and web applications. The basics of the SQL language will be learned

AIMS AND LEARNING OUTCOMES

Educational Goals:
The course aims to provide students with the ability to analyze a simple situation in a typical area of Medical Informatics. For this analysis, a classical theoretical tool is presented, such as the Entity-Relationship diagram.
Once the reality is analyzed and formalized with this tool, the classic Relational Data Base Management Systems (DBMS) is presented to the student. With such DBMS he/she can realize the logical schema of the analyzed reality.
For a complete use of these tools, students are provided with the basics of web programming with particular emphasis on the production of interfaces for databases.
Learning outcomes
- Design of a small DB starting from an informal explanation
- Design of a simple web interface starting from informal specifications

Open badge: expertise in project creation

PREREQUISITES

The student should have a good knowledge of basic computer science, as well as good notions of object-oriented programming.

TEACHING METHODS

Teaching is eminently practical. Obviously, basic information is provided with a minimum of ex-cathedra lessons; after which more and more complete examples are developed with a direct interaction between teacher, assistants and students.

Working students and students with DSA, disability or other special educational needs certification are advised to contact the teacher at the beginning of the course to agree on teaching and exam methods which, in compliance with the teaching objectives, take into account individual ways of learning

SYLLABUS/CONTENT

Definition of databases, concepts on the SQL language
Notions of HTLM and managed languages for website development (VB or C #)
Use and management of databases through websites and the use of classes
Notions of tools for the graphic management of sites (Masterpage and CSS)

RECOMMENDED READING/BIBLIOGRAPHY

A. Silberschatz et al. “Database system concepts” VI Ed. Mc Graw Hill 2012
D. Bocchicchio et al. “ASP .NET 4.5 e ASP .NET MVC 4.0 in C# e VB” Hoepli 2013

TEACHERS AND EXAM BOARD

Exam Board

MAURO GIACOMINI (President)

ELENA LAZAROVA

NORBERT MAGGI

SARA MORA

LAURA PASTORINO

MARCO MASSIMO FATO (President Substitute)

LESSONS

LESSONS START

https://easyacademy.unige.it/portalestudenti/index.php?view=easycourse&_lang=it&include=corso

Class schedule

The timetable for this course is available here: Portale EasyAcademy

EXAMS

EXAM DESCRIPTION

The exam consists in the textual presentation of a simple, but probable, typical situation of Medical Informatics. This short text should be analyzed, formalized in a logical diagram and a simple web interface (of a single page) should be produced that performs few basic functions. All the examination must be done to the computer.

ASSESSMENT METHODS

For the evaluation the following skills will be considered:
- The ability to analyze and formalize
- The formal correctness of the logical product diagram
- The correspondence of the interface to the required requirements.

Exam schedule