Data base

Not applicable.

According to the objectives of the course, its target public, and achievement goals, certain methodologies and strategies must be used in order to allow the right comprehension of the taught content.

As such, it is prioritized the use of several techniques and methodologies together to maximize the apprehension of contents, thus we have:

1. Expository method: oral exposition of theoretical contents using multimedia presentations, use of programs and resources specific to Databases;

2. Interrogative method: through questions directed to a student or to the group during the classes, allowing immediate feedback on the contents covered;

3. Active method: by using several techniques, such as conducting discussions/debates on the themes developed, case studies regarding important facts in the area of the matter, problem-solving and development of individual works;

4. Demonstrative method: useful to demonstrate the installation and operation of programs used in the development and management of Databases

It is expected that at the end of the course 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).

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.

MySQL. (2021). MySQL Documentation – MySQL Reference Manual. https://dev.mysql.com/doc/

Oracle. (2021). Oracle Database Documentation. https://docs.oracle.com/en/database/oracle/oracledatabase/