Descriptive summary of the curricular unit This curricular unit aims to provide students with the necessary technical skills for the design of databases in organizations as well as to highlight the knowledge concerning the new challenges of digital transformation (Big Data, Internet of Things, Virtual Reality and Augmented Reality, Artificial Intelligence and Machine Learning).
Objectives and learning outcomes 1. Know the importance of information systems in organizations. 2. Understand the models of structured analysis of information systems. 3. Analyze the construction of E-R models. 4. Identify and structure the normalization process. 5. Identify and understand the relational model in SMEs. 6. Use the SQL language. 7. Study a database management system. 8. Design and implement a database adjusted to a PE. 9. Acquire comprehensive knowledge concerning the new challenges of digital transformation (Big Data, Internet of Things, Virtual Reality and Augmented Reality, Artificial Intelligence and Machine Learning.
Skills to be developed 1. Assess the feasibility of methods and processes from the point of view of their effectiveness, cost and suitability; 2. Produce and present technical work reports; 3. Demonstrate capacity for methodical analysis of critical information. 4. Adapt to and keep up with technological developments in their professional activity.
Programme
1. Introduction to information systems - Information in organizations - Information systems in organizations - The technologies and challenges of digital transformation in organizations - Information management 2. Database management systems (DBMS) - Databases - Concept and main functions of a DBMS - Structure of a DBMS - Database specific languages 3. Data modeling - The importance of data modeling - The evolution of data models - Degrees of data abstraction 4. The relational model - Basic terminology - Key attributes - Integrity rules - Relational Algebra Operators 5. The entity-relationship (E-R) model - Entities - Attributes - Relationships - Relationship degrees - E-R Diagram 6. Functional dependencies and normalization - The importance of normalization - Functional dependencies - The normalization process 7. The SQL language (Structured Query Language) - Introduction to SQL - Basic Structure - Data Definition Language (DDL) - Data Manipulation Language (DML) 8. Tables - Creating and manipulating tables - Primary and foreign key concepts - Definition of relations between tables - Field properties 9. Forms - Ways of creating forms - Types of forms - Creation and manipulation - Properties - Subforms 10. Queries - Creating a query - Setting criteria in queries - Selection queries - Cross-referencing queries - Action queries 11. Reports - Process of writing a report - Automatic reports and wizards - Creation and manipulation - Reports with subforms or subreports 12. Macros - Introduction to Macros - Creating Macros - Definition of events - Macros associated with changes in controls or events - Activating macros with command buttons in forms - Application design through macros and forms".
Demonstration of the syllabus coherence with the curricular unit's learning objectives
- Objective 1 will be achieved through the contents covered in Points 1; - Objective 2 will be achieved through the contents covered in Points 2; - Objective 3, 4 and 5 will be achieved through the contents covered in Points 3,4, 5 and 6; - Objective 6 will be achieved through the contents covered in Points 7. - Objective 7,8 and 9 will be achieved through the contents covered in Points 8,9,10,11 and 12.
Main literature
Ramakrishnan, Raghu and Gehrke, Johannes;Database Management Systems (3rd Edition) , Publisher McGraw-Hill Education, 2020. ISBN: 9780071231510
Belo, Orlando;Bases de Dados Relacionais - Implementação com MySQL, FCA ¿ Editora Informática, 2021. ISBN: 9789727229215
Supplementary Bibliography
Damas, Luís;SQL ¿ Structured Query Language (14.ª Edição Atualizada), FCA ¿ Editora Informática, 2017. ISBN: 978 972 722 829-4
Silberschatz, Abraham; Korth, Henry F. & S. Sudarshan;Database Systems Concepts (7th Edition) , McGraw-Hill Education, 2019. ISBN: 1260084507
Ramos, Pedro Nogueira;Desenhar Bases de Dados com UML - 2ª Edição , Edições Sílabo, 2008. ISBN: 978-972-618-474-4
Desenho e Implementação de Bases de Dados com Microsoft Access XP, Edições Centro Atlântico. ISBN: 9789728426545
Learning Methods
Use of expository method for the introduction of theoretical concepts and interrogative method for reflection on the content. Use of experimental methods, which include activities of application of the contents taught and the realization of practical work, under the guidance of the teacher.
Assessment Components
Avaliação apenas com exame final
Assessment Components
Description
Type
Time (hours)
Conclusion Date
Attendance (estimated)
Lessons
30
Assessment
Teste/Exame
3
Practical Work
Projectos
20
Autonomous study
Study
54
Total:
107
Demonstration of the coherence between the teaching methodologies and the learning outcomes
The teaching methodology assumes theoretical and practical characteristics according to the nature of the subjects taught and the objectives of the course unit. It is encouraged the spirit of reflection and discovery in students as a way to truly obtain qualifications both in the assimilation of theoretical knowledge and the ability to apply it to practical situations. This way the defined objectives will be achieved, both in terms of understanding the concepts and in terms of the ability to apply them in practice.