Database Programming
- Details
- Category: Discipline
- Não
- This course aims for students to develop abstraction mechanisms, develop information structuring, develop the ability to effectively use information search languages and provide students with knowledge of analysis, design and implementation and management of databases. This UC focuses on the introduction and consolidation of the fundamental concepts of databases, providing students with the necessary skills for the conception, design, implementation and management of database systems.
- Semestral
Descrição
Data limite
Ponderação
Avaliação parte teórica
20-06-2026
50%
Teste de avaliação
(Nota mínima de 8 valores.
Nota abaixo de 8 valores será a nota final da avaliação na disciplina)
20-06-2026
70%
Tema de desenvolvimento individual 20-06-2026 20% Assiduidade e participação nas aulas 20-06-2026 10% Avaliação parte prática 20-06-2026 50% Trabalho em grupo com apresentação e avaliação individual
(Nota mínima de 8 valores.
Nota abaixo de 8 valores será a nota final da avaliação na disciplina)
20-06-2026 50% Exercícios de aplicação 40% Assiduidade e participação nas aulas
10%
Aprovação obtida com nota final de 10 valores, ou superior.
Nota inferior a 8 valores numa das componentes (prática ou teórica) será a nota final da disciplina
- Database Concepts and Conceptual Model Definition. Objectives, Types and Concepts Conceptual data model Data Modelling Analysis, design and creation of Databases Database Analysis (UML Language – Class Diagrams) Data relational model Transposition from a conceptual model to a relational model Database Design and Creation Database Management Systems Installation and configuration of Databases Database Administration SQL Language Simple queries Aggregate Functions, Subqueries, and Triggers Stored procedures Analysis, design and implementation of a database Database security NOSQL Databases
- The course aims for students to develop abstraction mechanisms, develop information structuring, develop the ability to effectively use information search languages and provide students with knowledge of analysis, design and creation, as well as the use and administration of Database Management Systems. Define and implement coherent strategies for copying data and privilege backups and access control. Master the SQL language and its use. The concepts and knowledge will be obtained through exercises and practical examples and an application project.
- Mandatory
- Online support will be made available to students and to bring students closer to the business reality, they will be used in activities to carry out situations identical to those verified in companies
- Português
- Navathe, Shamcant e Elamsri, Ramez - Fundamentals of Database Systems, 7th Edition, Pearson (2016) ISBN 978-0-13-397077-7 Damas, Luís – SQL - Structured Query Language, 14ª Edição atualizada (2020). FCA (2020). ISBN13: 978-972-722-829-4 Ramos, Pedro Nogueira – Desenhar Bases de Dados com UML, 2ª Edição (2012). Edições Sílabo Lda. Documentos de apoio e textos a fornecer pelos docentes
- 4
- 0
- 6
- 1
- IPLUSO6378-23527
- Database Programming
- 23527
- 6378
- Development for the Web and Mobile Devices
