Autenticação

Utilizador:

Senha:

Iniciar sessão

Esqueceu-se da senha?

Databases

Code:

TPSIA09

Sigla:

BD

Áreas Científicas
Classificação	Área Científica
OFICIAL	Ciências Informáticas

Ocorrência: 2023/2024 - 2S

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

Ciclos de Estudo/Cursos

Sigla	Nº de Estudantes	Plano de Estudos	Anos Curriculares	Créditos UCN	Créditos ECTS	Horas de Contacto	Horas Totais
TPSIA	26	Plano de Estudos	1	-	6	60	162

Língua de trabalho

Portuguese

Objetivos

The main objective of the curricular unit of Databases is to provide students with the necessary knowledge to analyze, construct and manipulate a relational database to support the manipulation of information in an Information System.

Learning Objectives:

Obj1: Know the fundamental concepts of Databases and Database Management Systems (DBMS) (relational).
Obj2: To know and understand the Entity-Relationship Model (MER).
Obj3: To analyze and design the MER of an Information System.
Obj4: Know and understand the Relational Model (RM).
Obj5: Know and apply the rules for transforming the MER into the RM.
Obj6: Know the concepts, normalization and normal form in relational Databases.
Obj7: know the SQL language in its DDL (Data Definition Language) and DML (Data Manipulation Language) aspects.
Obj8: To apply SQL language to the definition and manipulation of relational database schemas.
Obj9: Apply SQL language to data manipulation (insertion, update and removal) in relational databases.
Obj10: Apply the SQL language to construct simple and complex queries.
Obj11: know how to define code routines in DBMS.

Resultados de aprendizagem e competências

Students should develop skills to:
- Define a data model using the Entity-Relationship Model
- Implement standard relational databases
- Create and manipulate database information in SQL
- Retrieve information from a database using SQL

Modo de trabalho

Presencial

Programa

1. Fundamental concepts of Databases and Database Management Systems (relational)
2. Analysis and Modeling according to the Entity-Relationship Model (MER)
2.1 Requirement analysis
2.2. entities, attributes and relations
2.3. constraints: cardinality, participation and keys
2.4. the MER diagram
3. The Relational Model (RM)
3.1 Tables, columns and data types
3.2. constraints: primary key, foreign key, unique and check
4. Transformation from MER to MR
5. The Structured Query Language (SQL)
5.1 Data Definition Language (DDL) - create, alter and drop
5.2 Data Manipulation Language (DML) - insert, update and delete
5.3 Query information - select
5.3.1. distinguish, where, order by, and row functions
5.3.2. grouping information: group, group by, and having functions
5.3.3. join tables - inner join, outer join, self join
5.3.4. subqueries
6. Views
7. Programming logic and accesses to the data model 7.1.
7.1 Procedures
7.2. functions
7.3. triggers

Bibliografia Obrigatória

Abraham Silberschatz, Henry F. Korthand S. Sudarshan; Database System Concepts, 6th Edition, McGraw Hill, 2011. ISBN: ISBN 978-0-07-352332-3

Bibliografia Complementar

Luís Damas; SQL, 14ª Edição, FCA, 2017. ISBN: 978-972-722-829-4

Métodos de ensino e atividades de aprendizagem

The pedagogical methodology to be used in this course is based on two components, the expositive method accompanied by practical examples, complemented by practice in laboratory environment. The consolidation of knowledge is performed by the implementation of an integrative project of knowledge held in groups throughout the semester.

Will be used an e-learning platform (Moodle) to support teaching, as repository of information, forum, delivery of work and testing of self assessment and summative evaluation.

Software

MySQL Workbench
MySQL Community Server

Tipo de avaliação

Distributed evaluation without final exam

Componentes de Avaliação

Designation	Peso (%)
Teste	40,00
Trabalho laboratorial	60,00
Total:	100,00

Componentes de Ocupação

Designation	Tempo (Horas)
Estudo autónomo	20,00
Frequência das aulas	60,00
Trabalho laboratorial	25,00
Elaboração de projeto	60,00
Total:	165,00

Obtenção de frequência

Continuous assessment (*)
- Theoretical Component (CT): 3 Quizzes + Test
- Practical Component (PC): 3 Labs + Project: Phase 1 + Phase 2

Assessment by exam
- Theoretical Component (TC): Exam
- Practical Component (PC): Project

* -Access to continuous assessment is conditioned by at least 75% attendance in classes.

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

Continuous assessment
- Theoretical Component (CT):
  - 15% Quizzes
  - 25% Test 
  - Minimum grade of CT: 9.5 V

- Practical Component (PC):
  - 30% Labs
  - 30% Project: 50% Phase 1 + 50% Phase 2 
  - Minimum grade of PC: 9.5 V

Final grade: 40% CT + 60% CP (minimum final mark 9.5 V)


Assessment by exam
- Theoretical component (TC):
- 50% Exam (minimum grade 9.5 V)
- Practical Component (PC):
- 50% Project (minimum grade 9.5 V)

Final grade: 50% TC + 50% CP