Class Databases

The Curricular Unit (UC) of Databases belongs to the fundamental core of UCs of the Informatics Engineering course. Information storage is fundamental in any organization and it is in this UC that Students learn how to design and implement relational databases and to manipulate their information in order to obtain treated and organized information in its classical form using the SQL language.

This UC is taught in the 2nd year together with the UCs of Software Engineering, Analysis and Design of Systems and Programming Languages ¿¿I  and the students develop a small joint project that integrates knowledge of the four mentioned UCs, allowing the student to understand the complete dynamics of a Small computer project.

1. Empirical notion of database (DB). Historical models and relational model. BD's design principles. Real Database Management Systems (DBMS): independence of database design.

2. Relational theory. Relations and Attributes. Functional and multivalue dependencies. Keys of Relationship. Scheme of the relationship. Entity-Relationship Diagrams. Cardinality 1: 1, 1: N and N: N ratios

3. Data redundancy and inconsistency. Elimination of redundancy associated with functional dependencies and multivalue dependencies. Normal forms. Data normalization, practical application up to the 3rd Normal Form.

4. The DML and DDL components of SQL.

5. Other topics about Databases: NoSQL Databases and Distributed Databases.

Students will be asked to comment on their classmates' schemes as part of their assessment.
A game is used to solve a enigma using SQL.

• Damas, Luís (2017). SQL, 14ª edição.FCA

• Gouveia, Feliz (2014). Fundamentos de Base de Dados, FCA.