Planeamento
Aulas Teóricas
Concepts in DBMS:
Concepts in DBMS: Overview of transaction management. Security and authorization. Database application development. No relational databases and big databases.
Introduction to Schema Refinement and normalization
Introduction to Schema Refinement. Problems Caused by Redundancy. Decomposition. Functional Dependencies. Normal Forms: First, Second and Third Normal Form.
Relational Model II (2sd part) and Complex Integrity Constraints in SQLSchema
Complex integrity constraints in SQL. Constraints over a single table. Domain constraints and distinct types. Assertions: ICs over several tables. Triggers and active databases. Examples of triggers in SQL. Designing active databases. Why triggers can be hard to understand. Constraints versus triggers. Other uses of triggers
SQL: QUERIES - III and IV
Aggregate operators. The GROUP BY and HAVING clauses. Examples of aggregate queries.Division operator.
Null values. Comparisons using null values. Logical connectives AND, OR, and NOT. Impact on SQL constructs. Outer joins.
SQL: QUERIES I e II
SQL:Overview, the form of a basic SQL query and examples.Expressions and Strings in the SELECT command.UNION, INTERSECT, and EXCEPT. Nested queries. Correlated nested queries.Set-comparison operators. Examples of nested queries.
Project support
Project support
Relational Model IV
Introduction to Views, Data Independence, Security. Updates on Views. Destroying/Altering Tables and Views. Enforcing Integrity Constraints. Project-E1: A solution and common errors.
Relational Model III - Logical Database Design
Logical database design: ER to relational. Entity sets to tables. Relationship sets (without constraints) to tables. Translating relationship sets with key constraints. Translating relationship sets with participation constraints. Translating weak entity sets, class hierarchies and Aggregation.
Relational Model I and II (1st part)
Introduction to the relational model. Creating and modifying relations using SQL.Integrity constraints over relations. Key constraints. Foreign key constraints. General constraints.
Conceptual design with ER model IV
Conceptual design with the ER model. Aggregation versus ternary relationships.
Conceptual design with ER model II e III
E/A modeling: Weak entities, aggregation and generalization.
Conceptual design with the ER model. Entity versus attribute. Entity versus relationship.
Conceptual design with ER model I
Data and data models, The Universe of Discourse. Levels of abstraction in database design: Conceptual, logical and physical. An introduction to Entity/Relationship (E/R) modeling. Entities, relationships and constraints.
Course presentation
Course presentation. Motivation and overview of DBMS, planning, evaluation method and bibliography.
Concepts in DBMS:
Concepts in DBMS: Overview of transaction management. Security and authorization. Database application development. No relational databases and big databases.
Introduction to Schema Refinement and normalization
Introduction to Schema Refinement. Problems Caused by Redundancy. Decomposition. Functional Dependencies. Normal Forms: First, Second and Third Normal Form.
Relational Model II (2sd part) and Complex Integrity Constraints in SQLSchema
Complex integrity constraints in SQL. Constraints over a single table. Domain constraints and distinct types. Assertions: ICs over several tables. Triggers and active databases. Examples of triggers in SQL. Designing active databases. Why triggers can be hard to understand. Constraints versus triggers. Other uses of triggers
SQL: QUERIES - III and IV
Aggregate operators. The GROUP BY and HAVING clauses. Examples of aggregate queries.Division operator.
Null values. Comparisons using null values. Logical connectives AND, OR, and NOT. Impact on SQL constructs. Outer joins.
SQL: QUERIES I e II
SQL:Overview, the form of a basic SQL query and examples.Expressions and Strings in the SELECT command.UNION, INTERSECT, and EXCEPT. Nested queries. Correlated nested queries.Set-comparison operators. Examples of nested queries.
Project support
Project support
Relational Model IV
Introduction to Views, Data Independence, Security. Updates on Views. Destroying/Altering Tables and Views. Enforcing Integrity Constraints. Project-E1: A solution and common errors.
Relational Model III - Logical Database Design
Logical database design: ER to relational. Entity sets to tables. Relationship sets (without constraints) to tables. Translating relationship sets with key constraints. Translating relationship sets with participation constraints. Translating weak entity sets, class hierarchies and Aggregation.
Relational Model I and II (1st part)
Introduction to the relational model. Creating and modifying relations using SQL.Integrity constraints over relations. Key constraints. Foreign key constraints. General constraints.
Conceptual design with ER model IV
Conceptual design with the ER model. Aggregation versus ternary relationships.
Conceptual design with ER model II e III
E/A modeling: Weak entities, aggregation and generalization.
Conceptual design with the ER model. Entity versus attribute. Entity versus relationship.
Conceptual design with ER model I
Data and data models, The Universe of Discourse. Levels of abstraction in database design: Conceptual, logical and physical. An introduction to Entity/Relationship (E/R) modeling. Entities, relationships and constraints.
Course presentation
Course presentation. Motivation and overview of DBMS, planning, evaluation method and bibliography.
Aulas de Problemas
SQL: QUERIES
Laboratory class: SQL/DML
SQL: QUERIES
Laboratory class: SQL/DML
SQL: QUERIES
Laboratory class: SQL/DML
SQL: QUERIES
Laboratory class: SQL/DML
SQL: QUERIES
Laboratory class: SQL/DML
SQL: QUERIES
Laboratory class: SQL/DML
SQL: QUERIES
Laboratory class: SQL/DML
SQL: QUERIES
Laboratory class: SQL/DML
SQL: QUERIES
Exercises SQL/Data Manipulation Language (DML)
SQL: QUERIES
Exercises SQL/Data Manipulation Language (DML)
Project support
Project support
Project support
Project support
Lab class: Logical Database Design: ER to Relational
Logical Database Design: ER to Relational - exercise Sopontes and Tour management
Lab class: Logical Database Design: ER to Relational
Logical Database Design: ER to Relational - exercise Sopontes and Tour management
ogical Database Design: ER to Relational
Logical Database Design: ER to Relational - exercise Intership management
ogical Database Design: ER to Relational
Logical Database Design: ER to Relational - exercise Intership management
Laboratory class: Access to Mysql. SQL/DDL.
Laboratory class: Access to Mysql. Introduction to SQL/DDL.
Laboratory class: Access to Mysql. SQL/DDL.
Laboratory class: Access to Mysql. Introduction to SQL/DDL.
Conceptual design with ER
Conceptual design with ER model - exercise Tour management
Conceptual design with ER
Conceptual design with ER model - exercise Tour management
Conceptual design with ER model
Conceptual design with ER model - exercise Sopontes
Conceptual design with ER model
Conceptual design with ER model - exercise Sopontes
Course presentation and ER model
T/P Course presentation. Conceptual design with ER model - exercise Intership management
Course presentation and ER model
T/P Course presentation. Conceptual design with ER model - exercise Intership management
No class
The TP classes start next week
No class
The TP classes start next week
SQL: QUERIES
Laboratory class: SQL/DML
SQL: QUERIES
Laboratory class: SQL/DML
SQL: QUERIES
Laboratory class: SQL/DML
SQL: QUERIES
Laboratory class: SQL/DML
SQL: QUERIES
Laboratory class: SQL/DML
SQL: QUERIES
Laboratory class: SQL/DML
SQL: QUERIES
Laboratory class: SQL/DML
SQL: QUERIES
Laboratory class: SQL/DML
SQL: QUERIES
Exercises SQL/Data Manipulation Language (DML)
SQL: QUERIES
Exercises SQL/Data Manipulation Language (DML)
Project support
Project support
Project support
Project support
Lab class: Logical Database Design: ER to Relational
Logical Database Design: ER to Relational - exercise Sopontes and Tour management
Lab class: Logical Database Design: ER to Relational
Logical Database Design: ER to Relational - exercise Sopontes and Tour management
ogical Database Design: ER to Relational
Logical Database Design: ER to Relational - exercise Intership management
ogical Database Design: ER to Relational
Logical Database Design: ER to Relational - exercise Intership management
Laboratory class: Access to Mysql. SQL/DDL.
Laboratory class: Access to Mysql. Introduction to SQL/DDL.
Laboratory class: Access to Mysql. SQL/DDL.
Laboratory class: Access to Mysql. Introduction to SQL/DDL.
Conceptual design with ER
Conceptual design with ER model - exercise Tour management
Conceptual design with ER
Conceptual design with ER model - exercise Tour management
Conceptual design with ER model
Conceptual design with ER model - exercise Sopontes
Conceptual design with ER model
Conceptual design with ER model - exercise Sopontes
Course presentation and ER model
T/P Course presentation. Conceptual design with ER model - exercise Intership management
Course presentation and ER model
T/P Course presentation. Conceptual design with ER model - exercise Intership management
No class
The TP classes start next week
No class
The TP classes start next week