Bases de Dados

Students must master basic algorithmic concepts.

The following teaching methodologies are used in this curricular unit:

1. Expository method: explanatory method where theoretical foundations and concepts are presented by the teacher and discussed with the class. Concepts and information will be presented to students through, for example, slide presentations or oral discussions. It will be used in classes to structure and outline the information.

2. Demonstrative method: based on the example given by the teacher of a technical or practical operation that one wishes to be learned. It focuses on how a given operation is carried out, highlighting the most appropriate techniques, tools and equipment. It will be used, for example, in practical and laboratory classes.

3. Interrogative method: process based on verbal interactions, under the direction of the teacher, adopting the format of questions and answers. It allows for greater dynamics in the classroom and consolidates learning. It will be used, for example, to remember elements of previous classes and in revisions of the lectured content.

4. Active methods: pedagogical techniques will be used in which the student is the center of the learning process, being an active participant and involved in his own training. The teacher assumes the role of facilitator, stimulating critical thinking, collaboration, creativity and student autonomy. They will be applied in classes to achieve a dynamic and more lasting learning environment.

Each class will consist of two moments:

1. Introductory presentation: At the beginning of the class, the teacher exposes and discusses the new contents under study with the students;

2. Practical application: After the introductory presentation, students develop work assignments and problem solving, individually and in group, for practical application of new concepts, autonomously and under the guidance of the teacher.

At the end of the curricular unit the student will be able to:

1. Identify the basic concepts in relational databases: relational model, integrity, normalization and relational operations;

2. Use databases through SQL language (Standard Query Language);

3. Design a transactional project;

4. Design and implement databases using the Entity-Relationship model;

5. Plan, develop and manage database applications.

1. Introduction to Databases and Basic Concepts (Data Models; Entities and Abstractions; Cardinality; Relational Data Model; Attributes; Primary Keys, Candidate Keys and Foreign Keys; Referential Integrity; Functional Dependence);

2. Relational operations and basic aspects of SQL (SQL Language; Relational Operations; Data Types; Integrity Constraints; Data Definition Language; Data Manipulation Language; Views; Security and Privileges; Schema definition and data manipulation using SQL);

3. Transactions and Concurrency Control (Transactions, Savepoints; Rollback Segments; Commits; Concurrency and Consistency; Blocking; Deadlocks);

4. Functional Dependence and Normalization (Database Design; 1st, 2nd and 3rd Normal Form (1FN, 2FN, 3FN), Boyce Codd Normal Form (FNBC); Functional Dependency Inference Rules);

5. Database Design (Entity-Relationship Diagrams; Degrees of Participation; Binary Relationships).

• - an individual written test - 50.0%
• - a group project - 50.0%

• - two individual practical assignments (30% each) - 60.0%
• - a group project - 40.0%

NAO

Belo, O. (2021). Bases de dados relacionais – Implementação com MySQL. FCA.

Damas, L. (2021). SQL – Structured query language (14th ed.). FCA.

Forta, B. (2012). SQL in 10 minutes (4th ed.). Sams Publishing.

Garcia-Molina, H. (2014). Database systems: The complete book. Prentice Hall.

Gouveia, F. (2021). Bases de dados – Fundamentos e aplicações (2nd ed.). FCA.

Groff, J., Weinberg, P., & Wald, L. (2009). SQL: The complete reference (2nd ed.). McGraw-Hill. (Complementary Bibliography).

MySQL. (2021). MySQL documentation – MySQL reference manual. https://dev.mysql.com/doc/

Oracle. (2021). Oracle database documentation. https://docs.oracle.com/en/database/oracle/oracle-database/

Ramakrishnan, R., & Gehrke, J. (2003). Database management systems. McGraw-Hill. (Complementary Bibliography).