Skip to main content

ISLA IPGT 13304

Fundamentals of Databases

Computing Engineering
  • ApresentaçãoPresentation
    This curricular unit develops skills in the design and implementation of relational databases in the context of organisational information systems: conceptual modelling (Entity-Relationship model), the relational model, normalization and the SQL language. It is the first database course in the degree and prepares students for Database Programming (2nd semester).
  • ProgramaProgramme
    1. Introduction - An organization's information system. Concept of database and database management system. Information systems development.   2. Entity-Relationship Model - Entities and attributes. Types of relationships (degree, cardinality, participation).   3. Relational Model - Concept of relation, relational database and relational schema. Integrity constraints.   4. Relational Database Design - Mapping Entity-Relationship diagrams to relational schemas. Normalization.   5. Relational Algebra 6. SQL Language - Definition of the database structure. Data types. Commands for manipulating information.
  • ObjectivosObjectives
    Faced with a computerisation problem, students should be able to: 1. Design information systems suited to users' needs and to the organisation's management goals; 2. Define a data model according to the general principles of databases and to normalization theory; 3. Define the database schema and understand the basic notions of the relational model; 4. Create and manipulate a relational database in SQL (structure definition, data insertion, update and querying)..
  • BibliografiaBibliography
    Damas, L. (2017). SQL - Structured Query Language (14.ª ed.). FCA. Gouveia, F. (2014). Fundamentos de Bases de Dados. FCA. Silberschatz, A., Korth, H. F., & Sudarshan, S. (2019). Database System Concepts (7th ed.). McGraw-Hill. Elmasri, R., & Navathe, S. B. (2016). Fundamentals of Database Systems (7th ed.). Pearson. Ramakrishnan, R., & Gehrke, J. (2003). Database Management Systems (3rd ed.). McGrawHill.  
  • MetodologiaMethodology
    Innovative methodologies in this curricular unit include active learning through problem-solving and case studies, collaboration on group projects, use of interactive digital resources, regular formative assessments, and practical application of knowledge in real-world projects. These dynamic and engaging approaches help students develop solid database skills in an effective and motivating way. Classes are laboratory practice: each session combines exposition with a live demonstration in a DBMS and the solving of a practical worksheet. Students install and use a relational DBMS (PostgreSQL or SQL Server), modelling tools (draw.io) and the Moodle platform to submit worksheets and the practical assignment. The group assignment goes through every stage: requirements, E-R model, normalized relational schema, SQL implementation and queries.
  • LínguaLanguage
    Português
  • TipoType
    Semestral
  • ECTS
    6
  • NaturezaNature
    Mandatory
  • EstágioInternship
    Não
  • AvaliaçãoEvaluation

    Metodologia de avaliação:

    Os estudantes podem optar por uma das seguintes opções:

    Avaliação Curricular

    Opção

    Elementos de Avaliação

    Peso (%)

    Nota Mínima

    1

     

     

     

    Ou

    Trabalho Prático

     

    35%

    8

    Teste Final

     

     

    65%

    8

     

     

    2

    Teste de Avaliação Global (TAG)

     

    100%

    9,5

    O Trabalho Prático inclui apresentação/defesa obrigatória. A aprovação exige classificação final igual ou superior a 9,5 valores e o cumprimento das notas mínimas de cada elemento.

     

    Avaliação Final

    Todos os estudantes que não tenham concluído com sucesso a avaliação curricular terão direito a um exame final, a realizar numa época de avaliação.