Base Knowledge
N/A
Teaching Methodologies
Not available
Learning Results
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.
Program
1. Introduction to Databases and Basic Concepts
Data Models; Entities and Abstractions; Cardinality; Relational Data Model; Attributes; Primary, Candidate and Foreign Keys; Referential Integrity; Functional Dependency; Database Management Systems; Databases SQL and NOSQL Data; Database Architecture Levels;
2. Relational operations and basic aspects of SQL
SQL Language; Relational Operations; Joins; Data Types; Line and Group Functions; Subqueries; Integrity Constraints; Data Definition Language; Data Manipulation Language; Views; Sequences ; Security and Privileges; Schema definition and data manipulation using SQL; Data Dictionary; Indexing; Clustering;
3. Transactions and Concurrency Control
Transactions, Savepoints, Rollback Segments, Commits, Concurrency and Consistency, Locks, Deadlocks;
4. Functional Dependency and Normalization
Database Design; 1st, 2nd and 3rd Normal Form (1NF, 2NF, 3NF), Boyce Codd Normal Form (BCNF); Functional Dependency Inference Rules; Trivial and Non-Trivial Dependencies; Decomposition;
5. Database Project
Entity-Relationship Diagrams; Conceptual and Physical Model; Diagram of Occurrences; Degrees of Participation; Binary Relationships; Generalization and Specialization; Types of Attributes.
Internship(s)
NAO
Bibliography
Belo, O. (2021). Bases de dados relacionais – Implementação com mysql. FCA.
Damas, L. (2021). SQL – Structured query language (14.ª ed.). FCA.
Forta, B. (2012). SQL in 10 minutes (4.ª ed.). Sams Publishing.
Garcia-Molina, H. (2014). Database systems: The complete book. Prentice Hall.
Gouveia, F. (2021). Bases de dados – Fundamentos e aplicações (2.ª ed.). FCA.
Groff, J., Weinberg, P., & Wald, L. (2009). SQL: The complete reference (2.ª ed.). McGraw-Hill.
MySQL. (2023). MySQL Documentation – MySQL Reference Manual. https://dev.mysql.com/doc/
Oracle. (2023). Oracle Database Documentation.
https://docs.oracle.com/en/database/oracle/oracledatabase/
Ramakrishnan, R., & Gehrke, J. (2003). Database management systems. McGraw-Hill.