Databases

Code:

INF32152

Sigla:

Áreas Científicas
Classificação	Área Científica
OFICIAL	Informática

Ocorrência: 2023/2024 - 2S

Ativa?	Yes
Unidade Responsável:	Departamento de Sistemas e Informática
Curso/CE Responsável:	Informatics Engineering

Ciclos de Estudo/Cursos

Sigla	Nº de Estudantes	Plano de Estudos	Anos Curriculares	Créditos UCN	Créditos ECTS	Horas de Contacto	Horas Totais
INF	143	Plano de Estudos	1	-	6	75	162

Docência - Responsabilidades

Docente	Responsabilidade
Cláudio Miguel Garcia Loureiro dos Santos Sapateiro

Docência - Horas

Theorethical and Practical :	3,00
Practical and Laboratory:	2,00

Type	Docente	Turmas	Horas
Theorethical and Practical	Totais	3	9,00
	Cláudio Miguel Garcia Loureiro dos Santos Sapateiro		6,00
	Gabriel César Ferreira Pestana		3,00
Practical and Laboratory	Totais	6	12,00
	João Paulo Portelinha Santos		6,00
	Luís Manuel Dias Damas		6,00

Língua de trabalho

Portuguese

Objetivos

-Know the potential of a Relational Database Management System - RDBMS

-Construction and manipulation of relational database schemas

- Query development

-Development of logic layer of data interaction

Resultados de aprendizagem e competências

-Application layer modeling aimed at supporting data persistence

-Insertion, Update and Manipulation of data in relational databases

Modo de trabalho

Presencial

Programa

436 / 5.000

-Fundamental concepts of DBs and DBMS(R)
-Analysis and Modeling according to the Entity-Relationship Model (MER)
-The Relational Model (MR)
-Transformation of MER into MR
-The Structured Query Language (SQL) and sublanguages:
-Data Definition Language (DDL) -Data Manipulation Language (DML) -Logic programming and data model access
- Procedures
-Functions
-Triggers
-Control of access permissions
- Complementary topics of BDs

Bibliografia Obrigatória

Abraham Silberschatz, Henry F. Korth and S. Sudarshan; Database System Concepts, McGraw Hill. ISBN: 978-0-07-352332-3
Luís Damas; Linguagem SQL, FCA. ISBN: 978-972-722-901-7

Métodos de ensino e atividades de aprendizagem

In addition to the lab tasks, exercises and UC project that can be done asynchronously, there are support forums and presential classes at the defined times for exposition and synthesis of materials, clarification of doubts, carrying out exercises and support.

Software

MySQL

Tipo de avaliação

Distributed evaluation without final exam

Componentes de Avaliação

Designation	Peso (%)
Participação presencial	30,00
Teste	30,00
Trabalho laboratorial	40,00
Total:	100,00

Componentes de Ocupação

Designation	Tempo (Horas)
Elaboração de projeto	45,00
Estudo autónomo	15,00
Frequência das aulas	75,00
Trabalho laboratorial	30,00
Total:	165,00

Obtenção de frequência

Check evaluation criteria

Fórmula de cálculo da classificação final

Assessment continues:
10% tokens (3) + 20% Delivery of laboratory work + 30% final written test + 40% final project grade (40% phase1 + 60% phase2)

minimum average chip score: 9.5
Minimum average grade for laboratory work deliveries: 9.5
minimum final project grade 9.5
minimum final test score: 9.5

Failure to meet the minimum grades excludes the student from the continuous assessment modality, particularly in relation to the forms and work delivery components), from participation in the final written test.

Assessment by exam:
50% exam + 50% project
Note: minimum grades for each component: 9.5

Recomendar Página Voltar ao Topo