ISLA Santarém 26683

Fundamentals of Data Management

• ApresentaçãoPresentation

    
• ProgramaProgramme

  1. Basic concepts of databases: File System vs. DBMS. Database management systems. Database models. Transactions. Performance and scalability. Data access and security. 2. Design of relational databases: Entity-relationship model. Normalization theory. 3. Relational algebra: SQL - Structured Query Language. Data Manipulation Language (DML) statements. Data Definition Language (DDL) statements. View creation and manipulation. Index creation and manipulation. 4. Database query languages: T-SQL and PL-SQL. 5. NoSQL databases: ACID and BASE. Design and implementation. 6. Database applications. 7. Database development tools.
• ObjectivosObjectives

  O1. Provide students with knowledge of fundamental concepts, methods, and techniques in the field of databases.  O2. Build relational data models appropriate to the requirements of an information system, using conceptual and logical database design techniques. O3 Explore the potential of a database management system (DBMS).  O4 Explore NoSQL databases. Skills: C1. Design database systems suited to the needs and objectives of organizational management. C2. Create databases by implementing the mechanisms necessary for data integrity. C3. Properly use information extraction and database query operations. C4. Use database management mechanisms, taking into account operational issues (security, concurrency).
• BibliografiaBibliography

  Damas, L. (2017). SQL - Structured Query Language. Lisboa: FCA  Gouveia, F. (2021). Fundamentos de Bases de Dados. Lisboa: FCA. Meier, A., & Kaufmann, M. (2019). SQL & NoSQL databases. Springer Fachmedien Wiesbaden.  Ramakrishnan, R., Gehrke, G. (2018). Database management systems. 3rd edition. New York: McGraw-Hill.  Silberschatz, A., Korth, H. F. & Sudarshan, S. (2019). Databse System Concept. McGrawHill.
• MetodologiaMethodology

  Distance learning: 1. Theoretical classes presenting the subject matter using the expository method, followed by the application of interrogative and interactive methods for immediate consolidation of knowledge. Face-to-face: 2. Use of the Problem-Based Learning (PBL) methodology, where each of the topics studied will follow the following phases: a) identification and definition of the problem to be solved. b) Access and use of relevant information to solve the problem. c) Problem solving. d) Presentation of results and critical analysis. Independent: 3. Solving additional exercises proposed by the teacher. The teacher provides feedback (Tutorial Guidance - TG) on the results obtained by the student in solving the proposed problems, either in person in the classroom or remotely in asynchronous mode via the Moodle platform.
• LínguaLanguage

  Português
• TipoType

  Semestral
• ECTS

  5
• NaturezaNature

  Mandatory
• EstágioInternship

  Não
• AvaliaçãoEvaluation

  Avaliação Curricular (contínua):
  A1. Projeto prático (relatório e projeto). A2. Teste final individual.
  A classificação final é calculada através da fórmula Classificação Final = 0,5*A1+0,5*A2. O estudante é aprovado se obtiver classificação igual ou superior a 9,5 valores.
  Avaliação Final: O estudante realiza o exame completo (A=100%) e é aprovado se obtiver uma classificação igual ou superior a 9,5 valores em 20.
  Avaliação em Época de Recurso e Época Especial (A): O estudante realiza o exame completo (A=100%) e fica aprovado se obtiver uma classificação igual ou superior a 9,5 valores em 20.