-
Presentation
Presentation
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.
-
Class from course
Class from course
-
Degree | Semesters | ECTS
Degree | Semesters | ECTS
Bachelor | Semestral | 6
-
Year | Nature | Language
Year | Nature | Language
2 | Mandatory | Português
-
Code
Code
ULHT2531-1792
-
Prerequisites and corequisites
Prerequisites and corequisites
Not applicable
-
Professional Internship
Professional Internship
Não
-
Syllabus
Syllabus
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
-
Objectives
Objectives
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;
-
Teaching methodologies
Teaching methodologies
Use of interactive class game dynamics through platforms like Kahoot.
-
References
References
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.
-
Assessment
Assessment
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.
-
Mobility
Mobility
No
