Databases

Category: Discipline
  • Não
  • This curricular unit aims to present the importance of Data Management within a company, to guarantee both the daily operation of the business, as well as the support to the strategic decision. This unit will reinforce the framework for structuring and methodologies for creating databases.
  • Semestral

  • O apuramento de resultado final terá 2 componentes:

    - Teórica, valendo 40%, composta por:

    • 2 Testes - 30%
    • Participação, assiduidade e pontualidade: 10%

    - Prática, valendo 60%, composta por:

    • Trabalhos a realizar em aula ou em casa : 10%
    • Trabalhos intercalares, 2 entregas: 20%
    • Trabalho final: 30%

    A época de recurso terá 1 exame teórico (40%) e 1 trabalho único (60%) com conteúdos equivalentes à junção dos trabalhos intercalares e trabalho final de avaliação continua

    As notas positivas de avaliação continua são retidas para recurso, só sendo requerido ao aluno repetir componentes para as quais não tenha obtido avaliação mínima.

    Todas as provas, independentemente de tipo ou época têm nota miníma de 9,50 valores, arredondado à centéssima
  • The syllabus of the curricular unit is: A) Theorical concepts Introduction Entity-Relationship Model The Relational Model Schema refinement: Normalisation and Transactions concept Architecture of DBMS and some Advanced SQL B) Lab component Introduction to SQL language; Instructions: DDL, DML (DQL) and DCL Operations: WHERE, ORDER BY, GROUP BY; Advanced concept in SQL: Error control Relational Operators: Union, Intersection, and Subtraction Cartesian Product (external) Complex queries (filter with aggregated values) and sub-queries Set DDL; CREATE statement; Data types; Nullity; ALTER and DROP statements INDICES and VIEWS Exception handling Procedures (SP) and Triggers Tables: Cursors
  • The objectives are to provide students with the theoretical and practical knowledge required to design, construct and analyze relational databases: namely, to obtain the following skills and competences: 1. Understand the reasons for implementing relational databases in the business world 2. Transpose from a requirements analysis to an entity-association model to design databases; 3. Apply the concepts of the relational database model, transforming the entity-association model into a physical data model; 4. Apply the techniques of normalization of tables; 5. Understand architecture and main components of Database Management Systems; 6. Use the base and advanced SQL language for creating, querying, and modification of databases;
  • Mandatory
  • Real world scenario simulation, using, whenever possible and applicable, integration with backend development with common used languages (e.g. PHP or Python) Use of modular case studies, allowing students to develop different yet complementary components, producing more comprehensive solutions
  • Português
  • Livros Damas, Luís (2017). SQL (14ª edição). FCA Date, C. J. (2003). An Introduction to Database Systems (8 edition). Boston: Pearson. Sites Recursos educativos do SQL - SQL Server | Microsoft Learn. (n.d.). Retrieved September 26, 2025, from https://learn.microsoft.com/pt-pt/sql/sql-server/educational-sql-resources?view=sql-server-ver17
  • 4
  • 0
  • 5
  • 1
  • IPLUSO6030-1792
  • Databases
  • 1792
  • 6030
  • Information Systems Management

English Menu

Pesquisa

Login Form