|SCIENTIFIC DISCIPLINARY SECTOR||ING-INF/06|
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.
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
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.
- 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
The student should have a good knowledge of basic computer science, as well as good notions of object-oriented programming.
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
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)
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
Office hours: Dates by appointments
All class schedules are posted on the EasyAcademy portal.
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.
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.