Databases

Category: Discipline
  • Books Learning PostgreSQL: Create, develop and manage relational databases in real world applications using PostgreSQL. (2023). Packt Publishing. Kaufmann, M., & Meier, A. (2023). SQL and NoSQL Databases: Modeling, Languages, Security and Architectures for Big Data Management (2ª ed.). Springer. Campbell, L., & Majors, C. (2017). Database Reliability Engineering: Designing and Operating Resilient Database Systems (1 edition). Beijing Boston Farnham Sebastopol Tokyo: O'Reilly Media. Date, C. J. (2003). An Introduction to Database Systems (8 edition). Boston: Pearson. Elmasri, R., & Navathe, S. B. (2015). Fundamentals of Database Systems (7 edition). Hoboken, NJ: Pearson. Teorey, T. J., Lightstone, S. S., Nadeau, T., & Jagadish, H. V. (2011). Database Modeling and Design: Logical Design (5 edition). Amsterdam: Morgan Kaufmann.  
  • Data Science
  • 6321
  • 1792
  • Databases
  • ISMAT6321-1792
  • 2
  • 6
  • 0
  • 12
  • Não
  • Português
  • Use of interactive class game dynamics through platforms like Kahoot.
  • Mandatory
  • 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;
  • The syllabus of the curricular unit is: A) Theorical component 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 Error control: TRY structure ... CATCH Procedures (SP) and Triggers Tables: Cursors

  • Na parte teórica, os 50% da avaliação terá as 3 seguintes distribuições:
    -Teste final - 25%
    -2 mini testes - 20%
    -Participação em aula - 5%
    Na parte teórica, os 50% da avaliação terá as 3 seguintes distribuições:
    - Participação, assiduidade e pontualidade: 5%
    - Queries a realizar em aula ou TPC : 5%
    - Trabalhos intercalares, 2 entregas: 15%
    - Trabalho final: 25%
    A época de recurso terá 1 exame teórico e 1 trabalho único com modelação, DDL, DML e programação, com mais questões que a entrega final de frequência.

    A utilização de ferramentas de inteligência artificial (IA) para a realização de elementos de avaliação não é permitida nesta UC. Este impedimento deve-se ao objetivo de ser pretender avaliar a capacidade conceptual e de sistematização de conceitos estruturantes da unidade. Sempre que necessário, com fundamento em indício, é legítimo ao docente calendarizar uma prova oral de avaliação, convocando o/a estudante a comparecer, sob pena da anulação da avaliação à UC.
  • Semestral
  • Databases are an essential component of information systems and are present in most computer applications used on a daily basis. Their value is increasingly significant, as many organizational decisions rely on the analysis of stored data. This course unit aims to present the importance of data management within organizations, both for ensuring daily business operations and for supporting strategic decision-making. It also seeks to reinforce the fundamental concepts, structures, and methodologies involved in creating and managing databases. The Databases course unit aims to equip students with fundamental knowledge regarding structured data storage, the reduction of redundancy, and data processing to derive useful information.

English Menu

Pesquisa

Login Form