Teaching Methodologies
Theoretical lectures.
Practical classes of direct application of the concepts taught in the lectures.
The students have at their disposal notes and exercise sheets in the teaching platform of the school.
Evaluation is composed by an exam and a practical work to be developed during the semester.
Learning Results
To endow the students with basic knowledge and aptitudes that allow them to manipulate information in databases.
Present practices of clinical databases modelling.
Know and use techniques of optimization, mining and extraction of knowledge and data in the health sector
Sensitize and inform students of the importance of electronic health records, and the standards used for data communication
Program
1. Introduction to Databases
1.1. The Relational Model
1.2. The SQL language
1.3. Knowledge Extraction
2. 2. Clinical Database Modelling
2.1. Structure of clinical data
2.2. Essential set of clinical data
2.3. Building multiple views
2.4. Quality and reliability of data
3. Electronic Clinical Record
3.1. Development and characteristics
3.2. National standards
3.3. Quality of clinical records
3.4. Security and protection of clinical data
4. Electronic Health Record
Internship(s)
NAO
Bibliography
– C. J. Date, “An Introduction to Database Systems”, Pearson/Addison-Wesley, 2004, ISBN: 0-321-18956-6 (1A-5-120 (ISEC) – 12657)
– Ramez Elmasri, Shamkant B. Navathe, “Fundamentals of database systems”, 2004, Pearson/Addison Wesley, ISBN: 0-321-20448-4, (1A-5-119 (ISEC) – 12656)
– RAMAKRISSHNAN, R. – Database Management Systems, McGraw-Hill, (3rd Edition) 2003
– DAMAS, L. – SQL – Structured Query Language, FCA, 2005
– GOUVEIA, Feliz – Fundamentos de Bases de Dados, FCA 2014
– Weaver, C. A., Ball, M. J., Kim, G. R., & Kiel, J. M. (2015). Healthcare Information Management Systems: Cases, Strategies, and Solutions (Health Informatics) (4th ed.). Springer. ISBN 978-3-319-20764-3.
– WHO – World Health Organization, República Portuguesa, & European Observatory on Health Systems and Policies. (2018). Health System Review: Portugal. Phase 1 Final Report. https://www.sns.gov.pt/wp-content/uploads/2018/04/PortugalReviewReport_Printers_03April2018-2.pdf