ISLA Santarém 8448

Databases

• ApresentaçãoPresentation

    
• ProgramaProgramme

  1. Basic concepts about 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. The theory of normalization. 3. Relational algebra: SQL - Structured Query Language. Data Manipulation Instructions. (DML). Structure Definition Instructions (DDL). Creation and Manipulation of Views. Creation and Manipulation of Indexes. 5. Database interrogation languages: T-SQL and PL-SQL. 6. NoSQL databases: ACID and BASE. Design and Implementation. 7. Database applications. 8. 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 suited to the requirements of an information system, using conceptual and logical database design techniques. O2 Explore the potential of a database management system (DBMS). O3 Explore NoSQL databases. Competences: C1. Design database systems suited to the needs and management objectives of organizations. C2. Create a database for a medium problem by implementing the mechanisms necessary for data integrity. C3. Appropriately use information extraction and interrogation operations from a database. C4. Use database management mechanisms, taking into account exploitation issues (security, competition).
• 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

  Synchronous distance learning: 1. Theoretical classes explaining the subject using the expository method, following the application of interrogative and interactive methods for immediate consolidation of knowledge. Face to face: 2. Use of the Problem Based Learning methodology (PBL) 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 relevant information to solve the problem. c) Resolution of the problem. d) Presentation of the result and critical analysis. Autonomous: 3. Resolution of additional exercises proposed by the teacher. The teacher provides feedback (Tutorial Guidance - OT) on the results obtained by the student in solving the proposed problems, in person in a classroom context or remotely in asynchronous mode via the Moodle platform.
• LínguaLanguage

  Português
• TipoType

  Semestral
• ECTS

  7
• 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.